ASP.net DataGrid、GridView使用

1.   protected void Page_Load(object sender, EventArgs e)
     {
        //将TextBox2设置为只读，可以回传数据
        TextBox2.Attributes.Add("Readonly", "True");

       

        //第一次加载页面设为当前日期
        if (!IsPostBack)
        {
            this.TextBox2.Text = DateTime.Now.Date.ToShortDateString();
        }

 

      }

 

     这样设置后才可以下拉选择日期后回传数据，在前台.aspx代码页中写 Readonly = “true”，不可以使数据回传。

2. Asp.net GridView使用

         //连接数据库
        string strConnection;
        strConnection = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();

        conn = new OleDbConnection(strConnection);
        conn.Open();

 

        OleDbDataAdapter da = new OleDbDataAdapter(strSq, conn);
        DataSet          ds = new DataSet();
        da.Fill(ds, "ds");
         this.GridView1.DataSource = ds.Tables[0].DefaultView;
         this.GridView1.DataBind();

 

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Font-Size="Small" ForeColor="#333333" Height="100px" Style="margin-left:15px" mce_Style="margin-left:15px" Width="290px" HorizontalAlign="Center" BorderWidth="1px"> <RowStyle BackColor="#F7F6F3" ForeColor="#333333"/> <Columns> <%--第一列加入序号--%> <asp:TemplateField HeaderText="序号"> <ItemTemplate> <asp:Label runat="server" ID="labelId" Text="<%# Container.DataItemIndex + 1%>"></asp:Label>　　　 　 </ItemTemplate> <ItemStyle HorizontalAlign="Center" Wrap="false" /> </asp:TemplateField> <%--数据绑定两列 --%> <asp:BoundField DataField="日期" HeaderText="已休日期"> <ItemStyle HorizontalAlign="Center" Width="45%" Wrap="False" /> </asp:BoundField> <asp:BoundField DataField="备注" HeaderText="备注" > <ItemStyle HorizontalAlign="Center" Width="43%" Wrap="False" /> </asp:BoundField> </Columns> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" HorizontalAlign="Center"/> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView>

 

 

 

 <asp:DataGrid ID="DataGrid1" runat="server" AllowSorting="True" align="center" Width="559px" AutoGenerateColumns="False" Font-Bold="False" Font-Italic="False" Font-Names="Arial" Font-Overline="False" Font-Size="9pt" Font-Strikeout="False" Font-Underline="False" OnDeleteCommand="DataGrid1_DeleteCommand" OnEditCommand="DataGrid1_EditCommand" OnItemDataBound="DataGrid1_ItemDataBound" OnUpdateCommand="DataGrid1_UpdateCommand" OnCancelCommand="DataGrid1_CancelCommand"> <HeaderStyle Font-Size="Larger" Font-Bold="True" ForeColor="Black"> </HeaderStyle> <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Size="9pt" Font-Strikeout="False" Font-Underline="False" /> <Columns> <asp:TemplateColumn HeaderText="工号"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.工号") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Width="16px" Text='<%# DataBinder.Eval(Container, "DataItem.工号") %>'> </asp:TextBox> </EditItemTemplate> <HeaderStyle Width="60px" /> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="姓名"> <ItemTemplate> <asp:Label ID="Label3" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.姓名") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TextBox3" runat="server" Width="16px" Text='<%# DataBinder.Eval(Container, "DataItem.姓名") %>'> </asp:TextBox> </EditItemTemplate> <HeaderStyle Width="60px" /> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="部门"> <ItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.部门") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TextBox2" runat="server" Width="16px" Text='<%# DataBinder.Eval(Container, "DataItem.部门") %>'> </asp:TextBox> </EditItemTemplate> <HeaderStyle Width="30px" /> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="计资地点"> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.计资地点") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TextBox4" runat="server" Width="20px" Text='<%# DataBinder.Eval(Container, "DataItem.计资地点") %>'> </asp:TextBox> </EditItemTemplate> <HeaderStyle Width="20px" /> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="入厂日期"> <ItemTemplate> <asp:Label ID="Label5" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.入厂日期") %>'> </asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TextBox5" runat="server" Width="46px" Text='<%# DataBinder.Eval(Container, "DataItem.入厂日期") %>'> </asp:TextBox> </EditItemTemplate> <HeaderStyle Width="46px" /> </asp:TemplateColumn> <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" HeaderText="编辑操作" CancelText="取消" EditText="编辑"> <HeaderStyle Width="60px" /> </asp:EditCommandColumn> <asp:ButtonColumn Text="删除" HeaderText="删除" CommandName="Delete"> <HeaderStyle Width="30px" /> </asp:ButtonColumn> </Columns> </asp:DataGrid>

 

public void fill() { id = this.TextId.Text; //配置信息绑定 string strSql; strSql = "select * from Holidays where 工号='"+ id +"'"; //this.DataGrid1.DataKeyField = "id"; //这句话很重要 ds = new DataSet(); da = new OleDbDataAdapter(strSql, conn); da.Fill(ds, "ds"); this.DataGrid1.DataSource = ds.Tables[0].DefaultView; this.DataGrid1.DataBind(); } public void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { //删除指定条目 string id1 = this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString(); //db.delete("delete from Text where id=" + voteid + ""); string query= "delete from Holidays where 工号='" + id1 + "'"; myCmd.CommandText = query; myCmd.ExecuteNonQuery(); this.fill(); } public void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {//选中被编辑行 this.DataGrid1.EditItemIndex = e.Item.ItemIndex; ListItemType lit_footer = e.Item.ItemType; //如果是编辑行 if (lit_footer == ListItemType.EditItem) { //设置编辑的textbox的宽度,自己设吧 ((TextBox)(e.Item.Cells[1].Controls[0])).Width = Unit.Pixel(75); } this.fill(); } public void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { //取消编辑 this.DataGrid1.EditItemIndex = -1; //控件中要编辑的项的索引。默认值为 -1，指示不编辑 DataGrid 控件中的任何项 this.fill(); } public void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) {//更新操作 string id1 = this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString(); string name = ((TextBox)(e.Item.Cells[0].Controls[1])).Text.ToString(); string text = ((TextBox)(e.Item.Cells[1].Controls[1])).Text.ToString(); string next = ((TextBox)(e.Item.Cells[2].Controls[1])).Text.ToString(); DateTime dt = DateTime.Now; string query = "update Holidays set 工号='" + name + "',姓名='" + text + "',部门='" + next + "' where 工号='" + id1 + "'"; myCmd.CommandText = query; myCmd.ExecuteNonQuery(); this.DataGrid1.EditItemIndex = -1; this.fill(); } public void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { ListItemType lit_footer = e.Item.ItemType; //如果是编辑行 if (lit_footer == ListItemType.EditItem) { //设置编辑的textbox的宽度,自己设吧 Cell[表示在DataGrid中的行数], //从0开始 ((TextBox)(e.Item.Cells[1].Controls[1])).Width = Unit.Pixel(85); ((TextBox)(e.Item.Cells[0].Controls[1])).Width = Unit.Pixel(75); ((TextBox)(e.Item.Cells[2].Controls[1])).Width = Unit.Pixel(75); } //鼠标动作 if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { //e.Item.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#9999FF'"); //e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=c;"); //((LinkButton)(e.Item.Cells[4].Controls[0])).Attributes.Add("onclick", "return confirm('确认删除？')"); } }