salmah
شنبه 10 خرداد 1393, 00: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");
}
}
}