在程序中，如何使用DataGrid，能否给个简单的例子。

[dlmeijianyu]

第一次使用DataGrid,能否给个例子。

[林g]

你现在用的是不是vs2003？

[怫悰]

冒泡帮顶接分

MSDN帮助里没有例子？

[junwu1989]

右键属性生成器,列->添加绑定列指定好字段.

int nid=Convert.ToInt32(Request.QueryString["nid"]);//这个是传值
SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["constr"]);
SqlDataAdapter sda=new SqlDataAdapter("newsnews",conn);
sda.SelectCommand.CommandType=CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@nid",nid);
DataSet ds=new DataSet();
sda.Fill(ds);
this.DataGrid1.DataSource=ds;
this.DataGrid1.DataBind();

[hmilj245216]

是DataGrid还是DataGridView??

[marvelstack]

给你两个，
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx

[Eagle_ice]

前台：

<asp:DataGrid ID="ShowStuInfolist" runat="server" AutoGenerateColumns="False" Height="193px" Width="577px" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" GridLines="None" OnItemCommand="ShowStuInfolist_ItemCommand" OnItemDataBound="ShowStuInfolist_ItemDataBound"   >
            <Columns>
                <asp:BoundColumn DataField="Sno"  HeaderText="学号"></asp:BoundColumn>
                <asp:BoundColumn DataField="Sname" HeaderText="姓名"></asp:BoundColumn>
                <asp:BoundColumn DataField="Ssex" HeaderText="性别"></asp:BoundColumn>
                <asp:BoundColumn DataField="Sbirth" HeaderText="出生年月"></asp:BoundColumn>
                <asp:BoundColumn DataField="ClassName" HeaderText="班级名称"></asp:BoundColumn>
                <asp:BoundColumn DataField="Spolitical" HeaderText="政治面貌"></asp:BoundColumn>
                <asp:TemplateColumn HeaderText="操作">
                    <ItemTemplate>
                         <asp:LinkButton ID="Modify" runat="server" CommandName="Modify">更改</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateColumn>
                <asp:TemplateColumn HeaderText="操作">
                    <ItemTemplate>
                         <asp:LinkButton ID="Delbtn" runat="server" CommandName="Delete">删除</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateColumn>
            </Columns>
            <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
            <SelectedItemStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
            <ItemStyle BackColor="#DEDFDE" ForeColor="Black" />
            <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" />
        </asp:DataGrid></td>

后台：

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class ShowStuInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = StuDB.createSqlconnection();
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from InfoStudent", con);
        SqlDataReader sdr = cmd.ExecuteReader();
        this.ShowStuInfolist.DataSource = sdr;
        this.ShowStuInfolist.DataBind();
        con.Close();
    }
    protected void ShowStuInfolist_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        string Sno = e.Item.Cells[0].Text;
        if (e.CommandName == "Modify")  
        {
            Response.Redirect("Modify.aspx?sno="+Sno);
        }
        if (e.CommandName == "Delete")
        {
            SqlConnection con = StuDB.createSqlconnection();
            con.Open();
            SqlCommand cmd = new SqlCommand("delete from InfoStudent where Sno="+Sno, con);
            cmd.ExecuteNonQuery();
            con.Close();
            
        }
        Page_Load(source, e);
       
    }
    protected void ShowStuInfolist_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        e.Item.Cells[7].Attributes.Add("onclick", "javascript:return confirm('确定删除?');");
    }
}