or




private void radGridView1_CellEndEdit(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e) { //TextBox t1 = RadGridView1.MasterGridViewInfo.CurrentRow.Cells("Company").Value.ToString(); //TextBox t2 = RadGridView1.MasterGridViewInfo.CurrentRow.Cells("something").Value.ToString { using (var cn = new SqlConnection(connString)) { cn.Open(); try { SqlCommand cmd = new SqlCommand("UPDATE myTable SET Column = @Parm1 WHERE Col = @Parm2", cn); var parm1 = cmd.CreateParameter("Parm1"); parm1.Value = t1.Text; var parm2 = cmd.CreateParameter("Parm2"); parm2.Value = t2.text;; cmd.Parameters.Add(parm1); cmd.Parameters.Add(parm2); int rowsAffected = cmd.ExecuteNonQuery(); } catch (SqlException ex) { //MessageBox.Show(ex.StackTrace); } } } }
public void FillDropDownList(string connString) { String Query = "SELECT * FROM information_schema.tables where Table_Name like 'Table%'"; using (var cn = new SqlConnection(connString)) { cn.Open(); DataTable dt = new DataTable(); try { SqlCommand cmd = new SqlCommand(Query, cn); SqlDataReader myReader = cmd.ExecuteReader(); dt.Load(myReader); } catch (SqlException e) { //TODO } radDropDownList1.DataSource = dt; radDropDownList1.ValueMember = "TABLE_NAME"; radDropDownList1.DisplayMember = "TABLE_NAME"; } }