المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Parameterized Query ........... which was not supplied



C# Programming
01-09-2011, 03:52 PM
I have receieved this error , what is the wrong ?

Parameterized Query '(@StartDate nvarchar(6),@EndDate nvarchar(6),@StartTime nvarchar' expects parameter @MarkedListNumber, which was not supplied

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "update VopMessage_tbl set StartDate=@StartDate , EndDate=@EndDate , StartTime=@StartTime , EndTime=@EndTime where MarkedListNumber=@MarkedListNumber";
cmd.Connection = con;
cmd.Parameters.Add("@StartDate", SqlDbType.NVarChar);
cmd.Parameters.Add("@EndDate", SqlDbType.NVarChar);
cmd.Parameters.Add("@StartTime", SqlDbType.NVarChar);
cmd.Parameters.Add("@EndTime", SqlDbType.NVarChar);
cmd.Parameters.Add("@MarkedListNumber", SqlDbType.Int);
con.Open();
for (int t = 0; t <span class="code-keyword">