textbox value doest not inserted in asp.net

Question

this is my code. i am inserting the value in database.but topic column is always empty userby and date is inserted properly. tell me what i have to do so that all the values can be inserted.

try

{
cn.Open();

string sql1 = "insert into Topics(Topic,UserBy,Date)values('" + TextBoxScrap.Text + "','" + Session["uname"].ToString() + "','" + DateTime.Now.ToString() + "')";

SqlCommand cmd = new SqlCommand(sql1, cn);
cmd.ExecuteNonQuery();
cn.Close();
TextBoxScrap.Text = "";

}
catch (Exception ex)
{
Response.Write(ex.ToString());
}

Rupali Shinde · Answer

Hi Hajinder Please check your database column data type. txtbox1.text is string type. if column type is not string than it may possible that it is not getting inserted into database. If it works out Please Accept this as Answer

Hajinder Jassal · Answer

MUJHE VALUE INSERT KRNI HAI. MAIN TEXTBOX MEIN VALIE FILL TO KRTA HU BUT VO STORE NAHI HO RAHI DATABASE MEIN BAKI VALUES HO RAHI HAI STORE BS USI TEXTBOX KI NAHI HO RAHI STORE.

Hajinder Jassal · Answer

sir i've done with this method but doesn't work breakpoint is inserted and while debugging stepwise all the other values are shown but textbox value contains double quotes like this ''. solve this issue

Rajeesh Menoth · Answer

Hi protected void Page_Load ( object sender  EventArgs e ) { if (! IsPostBack ) { if ( this . TextBox1 . Text ==  ) { error . Text =  Marked Fields are compulsory!!  ; } else { //..... } } } Reference : http://stackoverflow.com/questions/5693236/textbox-text-always-returning-empty-string-instead-of-users-entered-text

Rupali Shinde · Answer

Hi Hajinder Please check below code : add condition to check string null or empty. if you added you are code on page load  in that case may be your textbox value is empty. if (string.IsNullOrEmpty(TextBox1.Text)) { TextBox1.Text = Empty; } string sql1 = insert into Student(NameEmailHolidayDate)values(' + TextBox1.Text + '' + Session[uname].ToString() + '' + DateTime.Now.ToString() + '); SqlCommand cmd1 = new SqlCommand(sql1 conn); cmd1.ExecuteNonQuery(); conn.Close(); TextBox1.Text = ; If it works out Please Accept this as Answer

Praveen Dhatrika · Answer

put a break point at sql1 statment and see if the value exists TextBoxScrap.Text and also Session[uname].Text