how can i insert textbox values into database in c#

Gaurav Raj

9y798.NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gaurav Raj9y ago
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 Barik9y ago
Please share your page markup.
Gaurav Raj9y ago
This Code not Work all value are inserted but textbox value are get blank in database
Ranjeet Patra9y ago
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
}