• 含有dropdownlist的gridview增删改查

     

    含有dropdownlist的gridview增删改查

    分类： asp.net2012-03-27 09:26 790人阅读 评论(0) 收藏 举报
    datasetstringasptextboxobjectexception

    GridView控件修改、删除例子，修改时含有DropDownList控件。
    示例运行效果图：

    GridViewUp.aspx文件代码：

    [html] view plaincopy
     
    1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewUp.aspx.cs" Inherits="gridview_GridViewUp" %>  
    2.   
    3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
    4. <html xmlns="http://www.w3.org/1999/xhtml">  
    5. <head runat="server">  
    6.     <title>无标题页</title>  
    7. </head>  
    8. <body>  
    9.     <form id="form1" runat="server">  
    10.         <div>  
    11.             <table cellpadding="0" cellspacing="0" border="0" width="80%" style="font-size: 11px">  
    12.                 <tr>  
    13.                     <td align="center">  
    14.                         <asp:GridView ID="GridView1" runat="server" Width="100%" CellPadding="4" ForeColor="#333333"  
    15.                             AutoGenerateColumns="False" AllowPaging="True" PageSize="12" OnRowCancelingEdit="GridView1_RowCancelingEdit"  
    16.                             OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowDeleting="GridView1_RowDeleting"  
    17.                             DataKeyNames="id,name" OnPageIndexChanging="GridView1_PageIndexChanging" DataMember="card,price" OnRowDataBound="GridView1_RowDataBound" GridLines="None">  
    18.                             <Columns>  
    19.                                 <asp:BoundField HeaderText="身份证号" DataField="card" Visible=false />  
    20.                                 <asp:BoundField HeaderText="编号" DataField="id" ReadOnly="True" />  
    21.                                 <asp:BoundField DataField="name" HeaderText="姓名" ReadOnly="True" />  
    22.                                 <asp:TemplateField HeaderText="身份证号">  
    23.                                     <ItemTemplate>  
    24.                                         <%# Eval("card") %>  
    25.                                     </ItemTemplate>  
    26.                                     <EditItemTemplate>  
    27.                                         <asp:TextBox ID="TBCard" Text='<%# Eval("card") %>' runat="server" Width="140px" />  
    28.                                     </EditItemTemplate>  
    29.                                     <ItemStyle Width="150px" />  
    30.                                 </asp:TemplateField>  
    31.                                 <asp:TemplateField HeaderText="学历">  
    32.                                     <ItemTemplate>  
    33.                                         <%# Eval("description")%>  
    34.                                     </ItemTemplate>  
    35.                                     <EditItemTemplate>  
    36.                                         <asp:HiddenField ID="HDFXueli" runat="server" Value='<%# Eval("xueli") %>' />  
    37.                                         <asp:DropDownList ID="DDLXueli" runat="server" Width="90px" />  
    38.                                     </EditItemTemplate>  
    39.                                     <ItemStyle Width="100px" />  
    40.                                 </asp:TemplateField>  
    41.                                 <asp:TemplateField HeaderText="价格">  
    42.                                     <ItemTemplate>  
    43.                                         <%# Eval("price") %>  
    44.                                     </ItemTemplate>  
    45.                                     <EditItemTemplate>  
    46.                                         <asp:TextBox ID="TBPrice" Text='<%# Eval("price") %>' runat="server" Width="90px" />  
    47.                                     </EditItemTemplate>  
    48.                                     <ItemStyle Width="100px" />  
    49.                                 </asp:TemplateField>  
    50.                                 <asp:BoundField HeaderText="建立时间" DataField="createdate" ReadOnly="True" />  
    51.                                 <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" HeaderText="操作" />  
    52.                             </Columns>  
    53.                             <PagerSettings FirstPageText="" LastPageText="" NextPageText="" PreviousPageText="" />  
    54.                             <RowStyle Height="20px" BackColor="#F7F6F3" ForeColor="#333333" />  
    55.                             <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />  
    56.                             <EditRowStyle BackColor="#999999" />  
    57.                             <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />  
    58.                             <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />  
    59.                             <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />  
    60.                             <AlternatingRowStyle BackColor="White" ForeColor="#284775" />  
    61.                         </asp:GridView>  
    62.                     </td>  
    63.                 </tr>  
    64.             </table>  
    65.         </div>  
    66.     </form>  
    67. </body>  
    68. </html>  


    GridViewUp.aspx.cs文件代码：

    [csharp] view plaincopy
     
    1. using System;  
    2. using System.Data;  
    3. using System.Configuration;  
    4. using System.Collections;  
    5. using System.Web;  
    6. using System.Web.Security;  
    7. using System.Web.UI;  
    8. using System.Web.UI.WebControls;  
    9. using System.Web.UI.WebControls.WebParts;  
    10. using System.Web.UI.HtmlControls;  
    11. using System.Data.SqlClient;  
    12.   
    13. public partial class gridview_GridViewUp : System.Web.UI.Page  
    14. {  
    15.     protected void Page_Load(object sender, EventArgs e)  
    16.     {  
    17.         if (!IsPostBack)  
    18.         {  
    19.             GridViewBind();  
    20.         }  
    21.     }  
    22.   
    23.     protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)  
    24.     {  
    25.         GridView1.PageIndex = e.NewPageIndex;  
    26.         GridViewBind();  
    27.     }  
    28.   
    29.     private void GridViewBind()  
    30.     {  
    31.         string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;  
    32.         string SqlStr = "SELECT a.*,b.description FROM test01 a,xueli b where a.xueli=b.code and a.id<1000 and a.id>200";  
    33.         DataSet ds = new DataSet();  
    34.   
    35.         try  
    36.         {  
    37.             SqlConnection conn = new SqlConnection(connStr);  
    38.             if (conn.State.ToString() == "Closed") conn.Open();  
    39.             SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);  
    40.             da.Fill(ds, "test01");  
    41.             if (conn.State.ToString() == "Open") conn.Close();  
    42.   
    43.             GridView1.DataSource = ds.Tables[0].DefaultView;  
    44.             GridView1.DataBind();  
    45.         }  
    46.         catch (Exception ex)  
    47.         {  
    48.             Response.Write("数据库错误，错误原因：" + ex.Message);  
    49.             Response.End();  
    50.         }  
    51.     }  
    52.   
    53.     protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)  
    54.     {  
    55.         if (((DropDownList)e.Row.FindControl("DDLXueli")) != null)  
    56.         {          
    57.             DropDownList ddlxueli = (DropDownList)e.Row.FindControl("DDLXueli");  
    58.   
    59.             // 生成 DropDownList 的值，绑定数据  
    60.             string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;  
    61.             string SqlStr = "SELECT * from xueli";  
    62.             DataSet ds = new DataSet();  
    63.   
    64.             SqlConnection conn = new SqlConnection(connStr);  
    65.             if (conn.State.ToString() == "Closed") conn.Open();  
    66.             SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);  
    67.             da.Fill(ds, "xueli");  
    68.             if (conn.State.ToString() == "Open") conn.Close();  
    69.   
    70.             ddlxueli.DataSource = ds.Tables[0].DefaultView;  
    71.             ddlxueli.DataTextField = "description";  
    72.             ddlxueli.DataValueField = "code";  
    73.             ddlxueli.DataBind();  
    74.             //  
    75.   
    76.             // 选中 DropDownList  
    77.             ddlxueli.SelectedValue = ((HiddenField)e.Row.FindControl("HDFXueli")).Value;  
    78.             //  
    79.         }  
    80.     }  
    81.   
    82.     protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)  
    83.     {  
    84.         GridView1.EditIndex = e.NewEditIndex;  
    85.         GridViewBind();  
    86.     }  
    87.     protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)  
    88.     {  
    89.         GridView1.EditIndex = -1;  
    90.         GridViewBind();  
    91.     }  
    92.   
    93.     protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)  
    94.     {  
    95.         string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();  
    96.         string card = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TBCard")).Text;  
    97.         string xueli = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DDLXueli")).SelectedValue;  
    98.         string price = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TBPrice")).Text;  
    99.   
    100.         string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;  
    101.         string SqlStr = "update test01 set card='" + card + "',xueli='" + xueli + "',price='" + price + "' where id=" + id;  
    102.   
    103.         try  
    104.         {  
    105.             SqlConnection conn = new SqlConnection(connStr);  
    106.             if (conn.State.ToString() == "Closed") conn.Open();  
    107.             SqlCommand comm = new SqlCommand(SqlStr, conn);  
    108.             comm.ExecuteNonQuery();  
    109.             comm.Dispose();  
    110.             if (conn.State.ToString() == "Open") conn.Close();  
    111.   
    112.             GridView1.EditIndex = -1;  
    113.             GridViewBind();  
    114.         }  
    115.         catch (Exception ex)  
    116.         {  
    117.             Response.Write("数据库错误，错误原因：" + ex.Message);  
    118.             Response.End();  
    119.         }  
    120.     }  
    121.   
    122.     protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)  
    123.     {  
    124.         string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();  
    125.         string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;  
    126.         string SqlStr = "delete from test01 where id=" + id;  
    127.   
    128.         try  
    129.         {  
    130.             SqlConnection conn = new SqlConnection(connStr);  
    131.             if (conn.State.ToString() == "Closed") conn.Open();  
    132.             SqlCommand comm = new SqlCommand(SqlStr, conn);  
    133.             comm.ExecuteNonQuery();  
    134.             comm.Dispose();  
    135.             if (conn.State.ToString() == "Open") conn.Close();  
    136.   
    137.             GridView1.EditIndex = -1;  
    138.             GridViewBind();  
    139.         }  
    140.         catch (Exception ex)  
    141.         {  
    142.             Response.Write("数据库错误，错误原因：" + ex.Message);  
    143.             Response.End();  
    144.         }  
    145.     }  
    146. }  


    sql server生成表代码：
    [sql] view plaincopy
     
    1. CREATE TABLE [dbo].[test01] (  
    2.     [id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,  
    3.     [name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,  
    4.     [card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,  
    5.     [xueli] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,  
    6.     [price] [decimal](18, 0) NULL ,  
    7.     [createdate] [datetime] NULL   
    8. ) ON [PRIMARY]  
    9. GO  
    10.   
    11. ALTER TABLE [dbo].[test01] ADD   
    12.     CONSTRAINT [DF_test01_createdate] DEFAULT (getdate()) FOR [createdate],  
    13.     CONSTRAINT [PK_test01] PRIMARY KEY CLUSTERED   
    14.     (  
    15.         [id]  
    16.     ) ON [PRIMARY]   
    17. GO  
    18.   
    19. CREATE TABLE [dbo].[xueli](  
    20.     [id] [int] IDENTITY(1,1) NOT NULL,  
    21.     [code] [int] NULL,  
    22.     [description] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,  
    23. CONSTRAINT [PK_xueli] PRIMARY KEY CLUSTERED   
    24. (  
    25.     [id] ASC  
    26. )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]  
    27. ) ON [PRIMARY]  
    28.   
    29. xueli表中的数据：  
    30. id    code    description  
    31. 1    1    博士  
    32. 2    2    硕士  
    33. 3    3    学士  
  • 相关阅读:
    MYSQL mysql.user表中权限对应的解释
    MYSQL LOCK IN SHARE MODE&FOR UPDATE
    什么是索引
    ol,li,ul,dl,dt,dd
    CSS类与选择器【转】http://www.cnblogs.com/duanhuajian/archive/2012/12/17/2821524.html
    bootstrap笔记
    iPhone应用程序开发基础之一： IBOutlet与IBAction
    Objective-C中的加号与减号
    Linux下*.tar.gz文件解压缩命令
    【PHP+MySQL学习笔记】php操作MySQL数据库中语句
  • 原文地址：https://www.cnblogs.com/nuaaydh/p/4391555.html
Copyright © 2020-2023  润新知