omid6630
یک شنبه 29 خرداد 1390, 12:57 عصر
بسم الله و سلام
پیغام خطا :
Incorrect syntax near 'Test'. این خطا رو از SqlDataReader sdr1=cmd1.ExecuteReader(); میگیره .
if (e.CommandName=="Change")
{
int id = Convert.ToInt32(e.CommandArgument);
SqlConnection cnn1 = new SqlConnection(SqlHelper.strConnectionString);
string select = "select * Test where id=@id";
SqlCommand cmd1 = new SqlCommand(select, cnn1);
cmd1.Parameters.AddWithValue("@id", id);
cnn1.Open();
SqlDataReader sdr1=cmd1.ExecuteReader();
sdr1.Read();
//txtid.Text = sdr1["id"].ToString();
//txtmodel.Text = sdr1["model"].ToString();
txtdate.Text = sdr1["Date"].ToString();
sdr1.Close();
cnn1.Close();
ViewState["id"] = id;
}
}
پیغام خطا :
Incorrect syntax near 'Test'. این خطا رو از SqlDataReader sdr1=cmd1.ExecuteReader(); میگیره .
if (e.CommandName=="Change")
{
int id = Convert.ToInt32(e.CommandArgument);
SqlConnection cnn1 = new SqlConnection(SqlHelper.strConnectionString);
string select = "select * Test where id=@id";
SqlCommand cmd1 = new SqlCommand(select, cnn1);
cmd1.Parameters.AddWithValue("@id", id);
cnn1.Open();
SqlDataReader sdr1=cmd1.ExecuteReader();
sdr1.Read();
//txtid.Text = sdr1["id"].ToString();
//txtmodel.Text = sdr1["model"].ToString();
txtdate.Text = sdr1["Date"].ToString();
sdr1.Close();
cnn1.Close();
ViewState["id"] = id;
}
}