Getting ORA: 000936-missing Expression error

Question

I am using visual studio 2005 ASP.NET C#

Please Help With this code.

 

protected void Button1_Click(object sender, EventArgs e)

{

System.Text.StringBuilder sb = new System.Text.StringBuilder();

sb.Append("<!-- Inject Script Filtered -->");

ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString());

Label2.Text = System.DateTime.Now.ToString("dd-MMM-yyyy");

try

{

conn.Open();

string stn = "insert into vendor_master(req_no,req_dt,req_by,ven_cd,acc_grp_cd,ven_title,name,name1,srch_1,st_house_no,colony,locality,postal_cd,city_cd,state_cd,country_cd,std_cd,tel_no,mob_no1,mob_no2,fax_no,email_id,email_id1,ssi_sts_cd,ven_type_cd,gst_class_cd,pan_no,gst_no,cont_dept,cont_func,cont_title,cont_first_nm,cont_last_nm,cont_tel,cont_extn,cont_fax,cont_mail_id,cont_mail_id1,old_ven_cd,active_ind,del_ind)values(" + this.Label1.Text + ",'" + this.Label2.Text + "','" + this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.DropDownList1.Text + "','" + this.TextBox3.Text + "','" + this.TextBox4.Text + "','" + this.TextBox5.Text + "','" + this.TextBox6.Text + "','" + this.TextBox7.Text + "','" + this.TextBox8.Text + "','" + this.TextBox9.Text + "'," + this.TextBox10.Text + "," + this.TextBox11.Text + ",'" + this.DropDownList2.Text + "','" + this.DropDownList3.Text + "','" + this.TextBox12.Text + "','" + this.TextBox13.Text + "','" + this.TextBox14.Text + "','" + this.TextBox15.Text + "','" + this.TextBox16.Text + "','" + this.TextBox17.Text + "','" + this.TextBox18.Text + "','" + this.DropDownList4.Text + "','" + this.DropDownList5.Text + "','" + this.DropDownList6.Text + "','" + this.TextBox19.Text + "','" + this.TextBox20.Text + "','" + this.TextBox21.Text + "','" + this.TextBox22.Text + "','" + this.DropDownList7.Text + "','" + this.TextBox23.Text + "','" + this.TextBox24.Text + "','" + this.TextBox25.Text + "','" + this.TextBox26.Text + "','" + this.TextBox27.Text + "','" + this.TextBox28.Text + "','" + this.TextBox29.Text + "','" + this.TextBox30.Text + "','" + this.TextBox31.Text + "','" + this.TextBox32.Text + "','" + this.TextBox33.Text + "')";

OleDbCommand cmd = new OleDbCommand(stn, conn);

cmd.ExecuteNonQuery();

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

finally

{

Label1.Text = "";

Label2.Text = "";

TextBox1.Text = "";

TextBox2.Text = "";

DropDownList1.SelectedIndex = -1;

TextBox3.Text = "";

TextBox4.Text = "";

TextBox5.Text = "";

TextBox6.Text = "";

TextBox7.Text = "";

TextBox8.Text = "";

TextBox9.Text = "";

TextBox10.Text = "";

TextBox11.Text = "";

DropDownList2.SelectedIndex = -1;

DropDownList3.SelectedIndex = -1;

TextBox12.Text = "";

TextBox13.Text = "";

TextBox14.Text = "";

TextBox15.Text = "";

TextBox16.Text = "";

TextBox17.Text = "";

TextBox18.Text = "";

DropDownList4.SelectedIndex = -1;

DropDownList5.SelectedIndex = -1;

DropDownList6.SelectedIndex = -1;

TextBox19.Text = "";

TextBox20.Text = "";

TextBox21.Text = "";

TextBox22.Text = "";

DropDownList7.SelectedIndex = -1;

TextBox23.Text = "";

TextBox24.Text = "";

TextBox25.Text = "";

TextBox26.Text = "";

TextBox27.Text = "";

TextBox28.Text = "";

TextBox29.Text = "";

TextBox30.Text = "";

TextBox31.Text = "";

TextBox32.Text = "";

TextBox33.Text = "";

conn.Close();

autogenerated();

BindGrid();

Label2.Text = System.DateTime.Now.ToString("dd-MMM-yyyy");

}

}