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
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();
}
__________________________________________________
No comments:
Post a Comment