Posted on: 8/20/2013 4:10:01 PM | Views : 837

with the code below i can update the table
protected void UpdateContent2() { int converthistoryid = int.Parse(TxtHistoryID.Text); SqlConnection conn = new SqlConnection(strconnection); SqlCommand cmd = new SqlCommand("UPDATE MedicalHistory SET GeneralHistory=@GeneralHistory, FamilyHistory=@FamilyHistory, EndocrineSystem=@EndocrineSystem WHERE HistoryID = @HistoryID ", conn); // HistoryID=@HistoryID // cmd.Parameters.AddWithValue("@GeneralHistory", "Edwin"); cmd.Parameters.AddWithValue("@GeneralHistory", "Edwin"); cmd.Parameters.AddWithValue("@FamilyHistory", "mills"); cmd.Parameters.AddWithValue("@EndocrineSystem", "laryea"); cmd.Parameters.AddWithValue("@HistoryID", TxtHistoryID.Text); try { conn.Open(); cmd.ExecuteNonQuery(); ...

Go to the complete details ...