System.Data.SqlClient.SqlException:

[kal2na2]

:((hi System.Data.SqlClient.SqlException: Prepared statement '(@Start_Code nchar(3),@Start1_Code nchar(3))select ' expects parameter @Start1_Code, which was not supplied. I am getting such error in my project asp.net with code behind C#.net any idea how to resolve it kal2na2 -- modified at 6:12 Friday 2nd December, 2005

[Colin Angus Mackay]

kal2na2 wrote:

System.Data.SqlClient.SqlException: Prepared statement '(@Start_Code nchar(3),@Start1_Code nchar(3))select ' expects parameter @Start1_Code, which was not supplied. I am getting such error in my project asp.net with code behind C#.net any idea how to resolve it

Yes, the answer is to supply the appropriate parameters to the SqlCommand object as indicated by the exception message. You might like to post the code that creates and executes the SQL - it would make answering the question easier.

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[kal2na2]

hi here i am posting my code lbs and lbd are listbox names sqlConnection1.Open(); string selectCommand="select Date,Start1_Code ,Start2_Code from Dates where Start1_Code='SMTP' and Start2_Code='SAD' Order By Date"; SqlDataAdapter myCommand=new SqlDataAdapter(selectCommand,sqlConnection2); myCommand.SelectCommand.Parameters.Add(new SqlParameter("@Start1_Code",SqlDbType.NChar,3)); myCommand.SelectCommand.Parameters["@Start1_Code"].Value=txtMsg.Text; ; myCommand.SelectCommand.Parameters.Add(new SqlParameter("@Start2_Code",SqlDbType.NChar,3)); myCommand.SelectCommand.Parameters["@Start2_Code"].Value =Start2_Station_Code; DataSet dataset=new DataSet(); myCommand.Fill(dataset,"Dates"); lbs.DataSource=dataset.Tables["Dates"].DefaultView; lbs.DataBind(); lbd.DataSource =dataset.Tables["Dates"].DefaultView; lbd.DataBind(); sqlConnection2.Close(); kal2na2

[Colin Angus Mackay]

You are supplying parameters that are not being used. No where in your SQL Statement do you use @Start1_Code or @Start2_Code Did you mean your SQL Statement to be: SELECT Date, Start1_Code, Start2_Code FROM Dates WHERE Start1_Code=@Start1_Code and Start2_Code=@Start2_Code ORDER BY Date Also, you have stated that @Start1_Code is nchar(3), but in your SQL Statement you have 'SMTP' which is 4 characters. What is sqlConnection1? You open it, but it is never used.

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[kal2na2]

hi its sqlConnection2.Open() not sqlConnection1.Open() string selectCommand="select Date,Start1_Code ,Start2_Code from Dates where Start1_Code='SMP' and Start2_Code='SAD' Order By Date"; but still same thing persits is something wong in my stored procedure kal2na2