I have a Datagrid that loads different columns from SQL database as thus:
ok to be more lucid; each value from the textbox is coming from each column in the datagrid say; Column MATH = 8, Column ENGLIS = 9, Column science = 10; etc. so when each rows is selected each columns shows in textbox1 so my question is; how can i save this figures back to there respective columns in the database; that is say; Column MATH value back to Column MATH and likewise english and science I have tried this so far but I would like to do it without the ',' in the text boxes.
What I have tried:
<pre>SqlConnection Conn = new SqlConnection(shoolmanangmentconn);
DataTable dt = new DataTable();
Conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE tbl_TestingTheApplicationSubject SET MATH=@MATH, ENGLISH=@ENGLISH, SOCIAL=@SOCIAL, SCIENCE=@SCIENCE, RME=@RME, PRETECH=@PRETECH, HOMEECOMICS=@HOMEECOMICS, HISTORY=@HISTORY, OWOP=@OWOP, ICT=@ICT, FRENCH=@FRENCH, CREATIVEART=@CREATIVEART, LANGUAGE=@LANGUAGE WHERE IDNO=@IDNO", Conn);
cmd.CommandType = CommandType.Text;
string[] arryval = txtresults.Text.Split(new[] { ' ', ',' }, StringSplitOptions.RemoveEmptyEntries);
int i = 0;
cmd.Parameters.Clear();
**cmd.Parameters.AddWithValue("@IDNO",txtids.Text)**;
cmd.Parameters.AddWithValue("@ENGLISH", arryval[i++]);
cmd.Parameters.AddWithValue("@MATH", arryval[i++]);
cmd.Parameters.AddWithValue("@SOCIAL", arryval[i++]);
cmd.Parameters.AddWithValue("@SCIENCE", arryval[i++]);
cmd.Parameters.AddWithValue("@PRETECH", arryval[i++]);
cmd.Parameters.AddWithValue("@ICT", arryval[i++]);
cmd.Parameters.AddWithValue("@RME", arryval[i++]);
cmd.Parameters.AddWithValue("@HOMEECOMICS", arryval[i++]);
cmd.Parameters.AddWithValue("@HISTORY", arryval[i++]);
cmd.Parameters.AddWithValue("@OWOP", arryval[i++]);
cmd.Parameters.AddWithValue("@CREATIVEART", arryval[i++]);
cmd.Parameters.AddWithValue("@FRENCH", arryval[i++]);
cmd.Parameters.AddWithValue("@LANGUAGE", arryval[i++]);
cmd.ExecuteNonQuery();
}