amirfallah3301
چهارشنبه 01 دی 1389, 21:47 عصر
سلام دوستان مشکل این کد کجاست ؟ این اخطار رو میده ==> Incorrect syntax near '*'.
public partial class delete : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
conn.ConnectionString =
"Data Source=.\\SQLExpress;" +
"User Instance=true;" +
"Integrated Security=true;" +
"AttachDbFilename=|DataDirectory|Database.mdf;";
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataAdapter dta = new SqlDataAdapter("select * from users", conn);
DataSet ds = new DataSet();
ds.Clear();
dta.Fill(ds, "users");
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "delete * from users where scode=@c";
cmd.Parameters.AddWithValue("@c", TextBox1.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
//End
}
}
public partial class delete : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
conn.ConnectionString =
"Data Source=.\\SQLExpress;" +
"User Instance=true;" +
"Integrated Security=true;" +
"AttachDbFilename=|DataDirectory|Database.mdf;";
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataAdapter dta = new SqlDataAdapter("select * from users", conn);
DataSet ds = new DataSet();
ds.Clear();
dta.Fill(ds, "users");
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "delete * from users where scode=@c";
cmd.Parameters.AddWithValue("@c", TextBox1.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
//End
}
}