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"; } }
radTreeView1.AllowEdit = true;radTreeView1.BeginEdit();RadTreeNode ethernetNode = radTreeView1.Nodes.Add("Ip address: 0.0.0.0");


| try |
| { |
| this.Cursor = Cursors.WaitCursor; |
| grdSearchResults.SuspendUpdate(); |
| //remove all filters |
| foreach (GridViewDataColumn dc in grdSearchResults.MasterGridViewTemplate.Columns) |
| dc.Filter.StringValue = string.Empty; |
| //add new pax to current manifest |
| for (int i = 0; i < nb; i++) |
| paxList.AddNew(); |
| UpdateScreenState(); |
| grdSearchResults.Rows[paxList.Count - nb].IsCurrent = true; |
| grdSearchResults.Columns[0].IsCurrent = true; |
| grdSearchResults.GridElement.ScrollToRow(0); |
| if (grdSearchResults.CurrentCell != null) |
| ((GridDataCellElement)grdSearchResults.CurrentCell).BeginEdit(); |
| } |
| catch (Exception exc) |
| { |
| ExceptionPolicy.HandleException(exc, "Client Policy"); |
| } |
| finally |
| { |
| this.Cursor = Cursors.Default; |
| grdSearchResults.ResumeUpdate(); |
| } |
grdSearchResults.GridElement.BeginUpdate();
instead of SuspendUpdate but the grid throws an argument out of range exception stating that Value is out of range???

