salmah
جمعه 09 خرداد 1393, 23:30 عصر
با سلام من از این کد برای به روز رسانی استفاده می کنم لطفا ببینید اشکال کار کجاست وقتی برروی دکمه ثبت کلیک میکنم وارد catch میشه وتغییرات ثبت نمیشه
SqlConnection cnc = new SqlConnection();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet dataset = new DataSet();
cnc.ConnectionString = ConfigurationManager.ConnectionStrings["shbtConnectionString"].ToString();
cmd.Connection = cnc;
cmd.CommandText = "SELECT * FROM tsabt";
adapter.SelectCommand = cmd;
adapter.Fill(dataset, "tsabt");
foreach (DataRow row in dataset.Tables["tsabt"].Rows)
{
if (row["sid"].ToString() == Label2.Text)
{
row["oid"] = dd_oid.SelectedValue;
row["nid"] = dd_nid.SelectedValue;
row["mid"] = dd_mid.SelectedValue;
row["bid"] = dd_bid.SelectedValue;
row["dta"] = dta.Text;
row["accept"] = CheckBox1.Checked;
}
try
{
int result = adapter.Update(dataset, "tsabt");
if (result > 0)
Response.Redirect("accept.aspx");
else
Response.Redirect("pm.aspx");
}
catch
{
Response.Redirect("pm2.aspx");
}
}
}
SqlConnection cnc = new SqlConnection();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet dataset = new DataSet();
cnc.ConnectionString = ConfigurationManager.ConnectionStrings["shbtConnectionString"].ToString();
cmd.Connection = cnc;
cmd.CommandText = "SELECT * FROM tsabt";
adapter.SelectCommand = cmd;
adapter.Fill(dataset, "tsabt");
foreach (DataRow row in dataset.Tables["tsabt"].Rows)
{
if (row["sid"].ToString() == Label2.Text)
{
row["oid"] = dd_oid.SelectedValue;
row["nid"] = dd_nid.SelectedValue;
row["mid"] = dd_mid.SelectedValue;
row["bid"] = dd_bid.SelectedValue;
row["dta"] = dta.Text;
row["accept"] = CheckBox1.Checked;
}
try
{
int result = adapter.Update(dataset, "tsabt");
if (result > 0)
Response.Redirect("accept.aspx");
else
Response.Redirect("pm.aspx");
}
catch
{
Response.Redirect("pm2.aspx");
}
}
}