C#

musefan wrote:

I thought he was using CD to goto the correct directory for makecert

I are Troll

cd c:\Program Files\Microsoft Visual Studio 9.0\VC
START makecert -ss CBBC

cd "C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin"
makecert -ss CBBC

cd c:\Program Files\Microsoft Visual Studio 9.0\VC
START /D"C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin\" makecert.exe -ss CBBC

cd "C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin"
makecert -ss CBBC

<br />
        private void button1_Click(object sender, EventArgs e)<br />
        {<br />
            string strValue= "0932;093E;0926;0947;0928;";<br />
            Regex rgexp = new Regex(@"([0-9A-Fa-f]{4});");<br />
            string strResult= rgexp.Replace(strValue, match =>  ((char)Int32.Parse(match.Groups[1].Value, NumberStyles.HexNumber)).ToString());<br />
            textBox1.Text=strResult;<br />
        }<br />

Girish481 wrote:

Unicode String to Hindi

Girish481 wrote:

I am using VS 2005 Prof Edition.

I are Troll

Girish481 wrote:

I have to store these files data into databases like Oracle, SQL Server. So, i was in search to first convert a unicode string to convert it into editable text; i.e. something like :

Girish481 wrote:

Unicode String is "This is a unicode string" and i wish :
New String is : "Something text after conversion";

Girish481 wrote:

and then if i select hindi (an Indian Language) font for new string; it will show me the original string as it was in Unicode.

I are Troll

Girish481 wrote:

Probably i am not able to explain my need

Girish481 wrote:

. See, whatever you have said, that is fine that if i says dim x as string="Hindi Words"; they are visible in the dotnet;

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

public partial class Form1 : Form
{
    const String ओम् = "ॐ (that's Ohm)"; // Hindi character (both in var-name and contents!)
    TextBox myTextBox;
    RichTextBox myRichBox;

    public Form1()
    {
        InitializeComponent();

        myTextBox = new TextBox();
        myTextBox.Dock = DockStyle.Top;
        myTextBox.Text = ओम्;
        this.Controls.Add(myTextBox);

        myRichBox = new RichTextBox();
        myRichBox.Dock = DockStyle.Top;
        myRichBox.Text = ओम्;
        this.Controls.Add(myRichBox);

        String cs = "Server=.;Database=Northwind;Trusted_Connection=True;";
        using (SqlConnection con = new SqlConnection(cs))
        using (SqlCommand cmd = con.CreateCommand())
        {
            // prep command
            cmd.CommandText = "UPDATE Customers SET CompanyName = @what WHERE ContactName = @ContactName";
            cmd.Parameters.AddWithValue("ContactName", "Antonio Moreno");
            cmd.Parameters.AddWithValue("what", ओम्);
            con.Open();
            
            // update that contact to have the Ohm-string in it's companyname
            // this is to prove that the character is stored in Sql Server.
            // We'll be searching for this character in the next query;
            cmd.ExecuteNonQuery();

            // now find that contact by using the Ohm-character and the Sql like operator            
            cmd.Parameters.Clear();
            cmd.CommandText = "SELECT CompanyName + '.' + ContactName FROM Customers WHERE CompanyName LIKE @bla";
            cmd.Parameters.AddWithValue("bla", "%ॐ%"); // search for any records containing the Ohm-character in column CompanyName
            string result = cmd.ExecuteScalar().ToString();

            myTextBox.Text = result; // should display a box-character with a name (this is what you wanted to prevent)
            myRichBox.Text = result; // should display a Ohm-character with a name (this is per your requirement)
        }
    }
}

Girish481 wrote:

1.How do i convert Unicode Text to Edibable Text?

Girish481 wrote:

and the SQL Server Error is :

I are Troll

Girish481 wrote:

First i really wish to heartly thank to you for your continue support.

Girish481 wrote:

1.How do i give/type Unicode in the textbox, something like :
Select * from mytable where name like '%ओम%' (Here i am copying from your reply)

SELECT * FROM mytable WHERE name LIKE N'%ओम%'

public partial class Form1 : Form
{
    const String Ohm = "ओम्";
    RichTextBox myRichBox;

    public Form1()
    {
        InitializeComponent();

        myRichBox = new RichTextBox();
        myRichBox.Dock = DockStyle.Top;
        myRichBox.Text = "ओ"; // Search part of the Ohm
        this.Controls.Add(myRichBox);

        using (SqlConnection con = new SqlConnection(
            "Server=.;Database=AdventureWorks;Trusted_Connection=True;"))
        using (SqlCommand cmd = con.CreateCommand())
        {
            cmd.CommandText = 
                "UPDATE Person.Contact SET FirstName = @what WHERE ContactID = @ContactID";
            cmd.Parameters.AddWithValue("ContactID", 25);
            cmd.Parameters.AddWithValue("what", "O" + Ohm); // write full Ohm to database
            con.Open();

            cmd.ExecuteNonQuery();

            cmd.Parameters.Clear();
            cmd.CommandText = 
                "SELECT ContactID FROM Person.Contact WHERE FirstName LIKE N'%@what%'";
            // For some strange reason, adding a parameter doesn't work
            //  cmd.Parameters.AddWithValue("what", myRichBox.Text);
            // As a workaround;
            cmd.CommandText = cmd.CommandText.Replace("@what", myRichBox.Text);
            string result = cmd.ExecuteScalar().ToString();

            myRichBox.Text = "Found record @Id; " + result;
        }
    }
}

I are Troll

Girish481 wrote:

Something like if table is having Unicode values then problem is how do i supply / search in the table using textbox1 and then populate my FlexGrid.

I are Troll