Member Avatar for panksd 
SqlConnection cn = new SqlConnection(MyConn.cnstring);
//string sql = "insert into Insert1 values(?,?,?,?,?)";

SqlCommand cmd ;
cmd = new SqlCommand("insert into Insert1 values(?,?,?,?,?)", cn);

cmd.Parameters.AddWithValue("sname", txtname.Text);
cmd.Parameters.AddWithValue("srno", txtrno.Text);
cmd.Parameters.AddWithValue("sdob", dob.Value);
cmd.Parameters.AddWithValue("sadd", txtadd.Text);
cmd.Parameters.AddWithValue("sgender", cmdgender.Text);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();

When I use this code folowing error will gererate
"Incorrect syntax near '?'."

Edited by kvprajapati because: Added [code] tags. For easy readability, always wrap programming code within posts in [code] (code blocks).
  • 2 Contributors
  • 1 Reply
  • 55 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Geekitygeek
Member Avatar for Geekitygeek

Use named-parameters

cmd = new SqlCommand("insert into Insert1(sname,srno,sdob,sadd,sgender) values (@sname,@srno,@sdob,@sadd,@sgender)", cn);

cmdForm.Parameters.Add("@sname", OleDbType.Char).Value = this.txtname.Text;

cmdForm.Parameters.Add("@srno", OleDbType.Char).Value = this.txtrno.Text;

cmdForm.Parameters.Add("@sdob", OleDbType.Date).Value = this.dob.Value

cmdForm.Parameters.Add("@sadd", OleDbType.Char).Value = this.txtadd.Text;

cmdForm.Parameters.Add("@sgender", OleDbType.Char).Value = this.cmdgender.Text;
commented: Thanks! +8
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.