{
//得到单位编号
string rowToDelete = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
//转换为整数
//int ID=Convert.ToInt32(rowToDelete);
//从数据库中删除
string str = "DELETE FROM DB1 where DB1_1=" + "'" + rowToDelete + "'" + "";
try
{
conn.RunSql(str);
//重新绑定数据
GridViewBind();
}
catch (Exception ex)
{
Response.Write("数据库错误，错误原因：" + ex.Message);
Response.End();
}
}
/// <summary>
/// 更新记录过程
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
string DB1_1 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text;
//string DB1_2 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;
string DB1_2 = (((DropDownList))GridView1.Rows[e.RowIndex].FindControl("ddlXL")).SelectedItem.Text;
//判断表单项是否有空并给出提示信息
if (DB1_1 == "" DB1_2 == "")
{
conn.Alert("请输入完整信息！", Page);
return;
上一篇:在C#中把两个DataTable连接起来，相当于Sql的Inner Join方法
下一篇:调整错乱盘符的解决方案
|
精品推荐