DataGrid更新数据

最新推荐文章于 2023-09-07 17:33:09 发布

cgj4750014

最新推荐文章于 2023-09-07 17:33:09 发布

阅读量500

点赞数

分类专栏： ASP.NET 文章标签： datagrid dataset textbox server object string

本文链接：https://blog.csdn.net/cgj4750014/article/details/2880991

版权

ASP.NET 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>

SqlConnection myConnection;

    protected void Page_Load(Object Src, EventArgs E)
    {
        myConnection = new SqlConnection("server=(local)//NetSDK;database=pubs;Trusted_Connection=yes");

        if (!IsPostBack)
            BindGrid();
    }

    public void MyDataGrid_Edit(Object sender, DataGridCommandEventArgs e)
    {
        MyDataGrid.EditItemIndex = (int)e.Item.ItemIndex;
        BindGrid();
    }

    public void MyDataGrid_Cancel(Object sender, DataGridCommandEventArgs e)
    {
        MyDataGrid.EditItemIndex = -1;
        BindGrid();
    }

    public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
    {
        String updateCmd = "UPDATE Authors SET au_id = @Id, au_lname = @LName, au_fname = @FName, phone = @Phone, "
             + "address = @Address, city = @City, state = @State, zip = @Zip, contract = @Contract where au_id = @Id";

SqlCommand myCommand = new SqlCommand(updateCmd, myConnection);

        myCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NVarChar, 11));
        myCommand.Parameters.Add(new SqlParameter("@LName", SqlDbType.NVarChar, 40));
        myCommand.Parameters.Add(new SqlParameter("@FName", SqlDbType.NVarChar, 20));
        myCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.NChar, 12));
        myCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 40));
        myCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar, 20));
        myCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.NChar, 2));
        myCommand.Parameters.Add(new SqlParameter("@Zip", SqlDbType.NChar, 5));
        myCommand.Parameters.Add(new SqlParameter("@Contract", SqlDbType.NVarChar,1));

myCommand.Parameters["@Id"].Value = MyDataGrid.DataKeys[(int)e.Item.ItemIndex];

String[] cols = {"@Id","@LName","@FName","@Phone","@Address","@City","@State","@Zip","@Contract"};

        int numCols = e.Item.Cells.Count;
        for (int i=2; i<numCols-1; i++) //跳过第一、第二和最后一列
        {
            String colvalue =((TextBox)e.Item.Cells[i].Controls[0]).Text;

            // 检查在所需字段中是否有空值
            if (i<6 && colvalue == "")
            {
                Message.InnerHtml = "错误：“作者 ID”、“姓名”或“电话”不允许使用空值";
                Message.Style["color"] = "red";
                return;
            }

myCommand.Parameters[cols[i-1]].Value = colvalue;
}

        //追加最后一行，将 true/false 值转换为 0/1
        if (String.Compare(((TextBox)e.Item.Cells[numCols-1].Controls[0]).Text, "True", true)==0)
                    myCommand.Parameters["@Contract"].Value = "1";
        else
                    myCommand.Parameters["@Contract"].Value = "0";

myCommand.Connection.Open();

        try
        {
            myCommand.ExecuteNonQuery();
            Message.InnerHtml = "<b>已更新记录</b><br>" + updateCmd;
            MyDataGrid.EditItemIndex = -1;
        }
        catch (SqlException exc)
        {
            if (exc.Number == 2627)
                Message.InnerHtml = "错误：已存在具有相同主键的记录";
            else
                Message.InnerHtml = "错误：未能更新记录，请确保正确填写了字段";
            Message.Style["color"] = "red";
        }

myCommand.Connection.Close();

BindGrid();
}

    public void BindGrid()
    {
        SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors", myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");

        MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
        MyDataGrid.DataBind();
    }

</script>

<h3><font face="宋体">更新数据行</font></h3>

    <ASP:DataGrid id="MyDataGrid" runat="server"
      Width="800"
      BackColor="#ccccff"
      BorderColor="black"
      ShowFooter="false"
      CellPadding=3
      CellSpacing="0"
      Font-Name="Verdana"
      Font-Size="8pt"
      HeaderStyle-BackColor="#aaaadd"
      OnEditCommand="MyDataGrid_Edit"
      OnCancelCommand="MyDataGrid_Cancel"
      OnUpdateCommand="MyDataGrid_Update"
      DataKeyField="au_id"
    >

</ASP:DataGrid>

</form>

</body>
</html>

cgj4750014

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
DataGrid更新数据

SqlConnection myConnection; protected void Page_Load(Object Src, EventArgs E) { myConnection = new SqlConnection("server=(local)//NetSDK;database=pubs;Trusted_Connection=yes"
复制链接

扫一扫