textbox value doest not inserted in asp.net

Hajinder Jassal

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());
}

6 Replies

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

Rupali Shinde11y ago
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
0
Hajinder Jassal11y ago
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.
0

Rajeesh Menoth11y ago

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

-1

Hajinder Jassal11y ago
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
0
Rupali Shinde11y ago
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(Name,Email,HolidayDate)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
-1
Praveen Dhatrika11y ago
put a break point at sql1 statment and see if the value exists TextBoxScrap.Text and also Session["uname"].Text
-1