how can i insert textbox values into database in c#

Question

how can i insert textbox values into database in c# where textbox place kept inside in datalist give example

Gaurav Raj · Answer

This code Is work instead of other code can u explain why protected void Button2_Click1(object sender EventArgs e) { com.User_Id = Convert.ToInt32(Session[Id]); Button btn = (Button)sender; string Id = ((Button)sender).CommandArgument; com.Blog_Id = Convert.ToInt32(Id); DataListItem item = (DataListItem)btn.NamingContainer; TextBox txt = (TextBox)item.FindControl(CommentTxt); com.Comment = txt.Text; com.Time1 = DateTime.Now.ToString(h:mm:ss); cs.da.CommentTables.InsertOnSubmit(com); cs.da.SubmitChanges(); Response.Redirect(Request.Url.AbsoluteUri);//prevent to reinsert data after refresh data UpdatePanel1.Update(); }

Ramesh Barik · Answer

Please share your page markup.

Gaurav Raj · Answer

This Code not Work all value are inserted but textbox value are get blank in database

Ranjeet Patra · Answer

Hi Gaurav Try to find the textbox inside the datalist and get that value of the text box and then insert into database. foreach (DataListItem item in myDataList.Items) { TextBox myTextBox = (TextBox)item.FindControl( myTextBox ); string text = myTextBox.text; // Do whatever you need with that string value here }