I have Store & Retrieve Data in Tamil Fonts
Note:First I have change the Font Tamil Font after i did my work
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
sqlcon.Open();
SqlCommand sqlcmd = new SqlCommand("Insert into Tbl_Name values('" + TxtName.Text + "')", sqlcon);
sqlcmd.ExecuteNonQuery();
dt = getds();
dataGridView1.DataSource = dt;
}
public DataTable getds()
{
DataTable dt=new DataTable ();
SqlDataAdapter sqladp = new SqlDataAdapter("Select * from dbo.Tbl_Name", sqlcon);
sqladp.Fill(dt);
return dt;
}
private void button2_Click(object sender, EventArgs e)
{
DataTable dtt1 = new DataTable();
dtt1 = getds();
dataGridView1.DataSource = dtt1;
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int i = dataGridView1.SelectedCells[0].RowIndex;
string st1 = dataGridView1.Rows[i].Cells[0].Value.ToString();
TxtName.Text = st1;
}