Friday 19 February 2021

how to insert Gujarati character in c#.net with SQL Server database

How to Insert Gujarati, Hindi, Marathi, Urdu etc ... characters or string using C#.Net with SQL Server    

(YOUTUBE VIDEO : https://youtu.be/TyyAnvaZCy0)  


Steps to Store languages in database:

1.Install Google Input Tool
2. Choose Your language inside a Google Input
3. Create a Database
4. Create a Table with NVarchar Data Type
5. Create a Your Window Form
6. Click on Button Then Insert data inside a database
7. Query:

insert into tablenm values(N'"+TEXTBOX NAME+"')

                    N is used to Insert Any Character 


Example:  

1. Window Form


2. Table and DataBase Structure:



3. Button Click Then Save data



Source code of CS File Listed here



        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\hp\documents\visual studio 2012\Projects\WindowsFormsApplication2\WindowsFormsApplication2\Database1.mdf;Integrated Security=True");
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into demo values(N'" + textBox1.Text + "')", con);
            cmd.ExecuteNonQuery();
            con.Close();
        }
  

__________________________________________________

(YOUTUBE VIDEO : https://youtu.be/TyyAnvaZCy0)  






No comments:

Post a Comment