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 }

how can i insert textbox values into database in c#

Answers (4)