C# Programming
02-14-2013, 05:05 AM
Hey Guys,
I know I can access my ItemTemplated Checkbox this way:
foreach (GridViewRow rowItem in GridView1.Rows) { CheckBox ckBxSelect = ((CheckBox)rowItem.FindControl("chkBxSelect")); // chk.checked will access the checkbox state on button click event if (ckBxSelect.Checked) { Response.Write("True"); } }
Ive built 1 LINQ object joined from 2 Datatables which comes from 2 WebServices. My GridView is bound to my LINQ object. When the user clicks submit, a foreach loop inserts that LINQ object into my database like so:
protected void Button1_Click(object sender, EventArgs e){mySQLDatabaseDataContext dbc = new mySQLDatabaseDataContext("Data Source=JBBBZ7V1\\SQLEXPRESS;Initial Catalog=WLSData;Integrated Security=True"); mySQLTableName newRecord; foreach (var item in LINQobject) { newRecord = new mySQLTableName(); newRecord.CustName = forAppr.custName; newRecord.Status = ""; newRecord.DateTimeSubmitted = DateTime.Now; dbc.mySQLTableName.InsertOnSubmit(newRecord); } dbc.SubmitChanges();}
Like I said, my checkbox is in a TemplateField like so:
When I am inserting from my LINQ object, I would like the "Status" field to update with "True" if checkbox is checked or "False" if checkbox is not checked. Like so:
protected void Button1_Click(object sender, EventArgs e){mySQLDatabaseDataContext dbc = new mySQLDatabaseDataContext("Data Source=JBBBZ7V1\\SQLEXPRESS;Initial Catalog=WLSData;Integrated Security=True"); mySQLTableName newRecord; foreach (var item in LINQobject) { newRecord = new mySQLTableName(); newRecord.CustName = forAppr.custName; if(ckBxSelect.Checked) { newRecord.Status = "True"; } Else { newRecord.Status = "False"; } newRecord.DateTimeSubmitted = DateTime.Now; dbc.mySQLTableName.InsertOnSubmit(newRecord); } dbc.SubmitChanges();}
However,
This code will throw an exception because of the object not being set to a reference.
Please help. Is there a better way do update my database?
Im totally lost. :(
I know I can access my ItemTemplated Checkbox this way:
foreach (GridViewRow rowItem in GridView1.Rows) { CheckBox ckBxSelect = ((CheckBox)rowItem.FindControl("chkBxSelect")); // chk.checked will access the checkbox state on button click event if (ckBxSelect.Checked) { Response.Write("True"); } }
Ive built 1 LINQ object joined from 2 Datatables which comes from 2 WebServices. My GridView is bound to my LINQ object. When the user clicks submit, a foreach loop inserts that LINQ object into my database like so:
protected void Button1_Click(object sender, EventArgs e){mySQLDatabaseDataContext dbc = new mySQLDatabaseDataContext("Data Source=JBBBZ7V1\\SQLEXPRESS;Initial Catalog=WLSData;Integrated Security=True"); mySQLTableName newRecord; foreach (var item in LINQobject) { newRecord = new mySQLTableName(); newRecord.CustName = forAppr.custName; newRecord.Status = ""; newRecord.DateTimeSubmitted = DateTime.Now; dbc.mySQLTableName.InsertOnSubmit(newRecord); } dbc.SubmitChanges();}
Like I said, my checkbox is in a TemplateField like so:
When I am inserting from my LINQ object, I would like the "Status" field to update with "True" if checkbox is checked or "False" if checkbox is not checked. Like so:
protected void Button1_Click(object sender, EventArgs e){mySQLDatabaseDataContext dbc = new mySQLDatabaseDataContext("Data Source=JBBBZ7V1\\SQLEXPRESS;Initial Catalog=WLSData;Integrated Security=True"); mySQLTableName newRecord; foreach (var item in LINQobject) { newRecord = new mySQLTableName(); newRecord.CustName = forAppr.custName; if(ckBxSelect.Checked) { newRecord.Status = "True"; } Else { newRecord.Status = "False"; } newRecord.DateTimeSubmitted = DateTime.Now; dbc.mySQLTableName.InsertOnSubmit(newRecord); } dbc.SubmitChanges();}
However,
This code will throw an exception because of the object not being set to a reference.
Please help. Is there a better way do update my database?
Im totally lost. :(