what's the error on this when i run it it's give me this error ""String or binary data would be truncated. The statement has been terminated."" it's update by using ID that i take it from Drop Down list
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string constr = "Data Source=YAZAN-PC ; initial Catalog=Elder ; user = sa ; pwd =yazan7;";
SqlConnection con = new SqlConnection(constr);
string sql = "Select * from Users;";
con.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
DataRow dr = dt.NewRow();
dr["ID"] = "0";
dt.Rows.InsertAt(dr, 0);
ddlID.DataSource = dt;
ddlID.DataValueField = "ID";
ddlID.DataBind();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string constr = "Data Source = YAZAN-PC ;" +
"initial catalog = Elder;" +
"user = sa ; pwd = yazan7;";
SqlConnection con = new SqlConnection(constr);
string Sql =
"Update Users Set Name=@Name , Gender=@Gender , Email=@Email ,UserType=@UserType, BirthDate=@BirthDate , Password=@Password, RePassword=@RePassword where ID=@ID;";
con.Open();
SqlCommand cmd = new SqlCommand(Sql, con);
cmd.Parameters.AddWithValue("@Name", txtName.Text);
cmd.Parameters.AddWithValue("@Gender", rblGender.SelectedValue);
cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
cmd.Parameters.AddWithValue("@UserType", rblUserType.SelectedValue);
cmd.Parameters.AddWithValue("@BirthDate", txtBirthDate.Text);
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
cmd.Parameters.AddWithValue("@RePassword", txtRePassword.Text);
cmd.ExecuteNonQuery();
con.Close();
}
Aucun commentaire:
Enregistrer un commentaire