Comments by Member 11796666 (Top 11 by date)

Dear Phil.o
It is Microsoft SQl Serevr 2008

Dear ....
I used this and it was useful but there is an error as below:
"THE OVER SQL construct or statement is not supported"
but an additional column(1-2-3-...) is added to my table in sql.
what about the error?
best wishes

protected void Button1_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(ViewState["id"]);
SqlConnection con = new SqlConnection()
//con.ConnectionString = "";
string q = "update ooo set title=@title where id=@id";
SqlCommand cmd = new SqlCommand(q, con);
cmd.Parameters.Add("@id", id);
cmd.Parameters.AddWithValue("@title",TextBox1.Text);
cmd.Parameters.AddWithValues("@title1",TextBox2.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}

Dear Richard
To complete the program, It is enough to add these;
TextBox2.Text = dr["title1"].ToString();
cmd.Parameters.AddWithValue("@title",TextBox2.Text);
best wishes