private void cmdValidate_Click(object sender, EventArgs e) { string connect = "Data Source=(local);Initial Catalog=TESTSHARP;User Id=sa;Password=Diamond"; System.Data.SqlClient.SqlCommand myquery; System.Data.SqlClient.SqlConnection myConnection = new System.Data.SqlClient.SqlConnection(connect); string sqlorder = "INSERT INTO BUYPRODUCT VALUES('0004','MALAD','VAVAL',18,20,'bombance','20070925','FCK_DA','STONE','TANIMA')"; try { myConnection.Open(); myquery = new System.Data.SqlClient.SqlCommand(sqlorder,myConnection); myquery.ExecuteNonQuery(); MessageBox.Show("connection OK!!!"); myConnection.Close(); } catch (Exception ex) { MessageBox.Show("Ú‘±Ž¸”s!!!!" + ex.Message); myConnection.Close(); } }