救命!!!!!dataGrid的例子谁有啊????--在线等待

把tablen放到一个dataset上，然后
datagride.datasource =dataset.table(0),vb.net winform中的用法，0表示第一个表，如果有多个表的话

Me.DataGridProductList.DataSource = ProductDatatable
Me.DataGridProductList.DataBind()

给个代码啊..救命啊@!@@@@@@
我得数据源是admins 表是users...帮帮我啊...

如果是webform的话，还需要进行绑定
datagrid.dataBind()

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{

}
}
public void BindGrid()
{
sqlConnection1.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ksjwdb"];
content = Request.QueryString["keykord"];
item = Request.QueryString["item"]==null?"gcmc":Request.QueryString["item"];
string CommandString ="select jdzch,gcmc,jsdw,jldw AS UpDownID,sgzbdw FROM zj_cx_zjgc where 2>1 AND "+item+" like '%"+content+"%' ";
SqlDataAdapter myCommane = new SqlDataAdapter(CommandString,sqlConnection1);
myCommane.Fill(dataSet1,"tabmsg");

//dataSet1.Tables[tabmsg].DefaultView[0]["jdzch"]
this.DataGrid1.DataSource = dataSet1.Tables["tabmsg"].DefaultView;
DataGrid1.DataBind(); }

private void GridBind2(string QueryStr)
{
string strconn=ConfigurationSettings.AppSettings["strconn"];
SqlConnection myconn=new SqlConnection(strconn);

try
{
myconn.Open();
SqlDataAdapter sqlDataAdapter1=new SqlDataAdapter(QueryStr ,myconn);
DataSet ds=new DataSet();
sqlDataAdapter1.Fill(ds,"Info");
DataView dv=new DataView(ds.Tables["Info"]);
DataGrid1.DataSource=dv;
DataGrid1.DataBind();

}
catch(Exception ex)
{
Response.Write(ex.Message);
Response.End();
}
finally
{
if(myconn.State==ConnectionState.Open)
myconn.Close();
}
}

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); try
{
if (conn.State.ToString() == "Closed")
{
conn.Open();
}

SqlDataAdapter myReader = new SqlDataAdapter("browse_news_other",conn);
DataSet DS = new DataSet();

myReader.Fill(DS,"news");
startIndex=DS.Tables[0].Rows.Count;
Db_G_news.DataSource = DS;
Db_G_news.DataBind();
myReader.Dispose();
DS.Dispose();
ShowStats();
}
catch(Exception ex)
{
string Error_info_detail=Server.UrlEncode(ex.Message.ToString());
Response.Redirect("Error_page.aspx?Error_info="+ Error_info_detail);
}
finally
{
if (conn.State.ToString() == "Open")
{
conn.Close();
conn.Dispose();
}
}

不明白啊!!!!!
我的数据源是admins,表是users,列是id,name,age
怎么放到控件上啊帮帮我啊..

public class jiang_zhongping_search : System.Web.UI.Page
{
SqlConnection Conn=new SqlConnection("server = ???.???.???.???;database = admins;uid = ???;password = ???;Timeout = 1200");private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
string sql="select * from users.....";
SqlCommand comm = new SqlCommand(sqlsel,Conn);
comm.CommandTimeout = 180;
SqldataAdapter sda=new SqldataAdapter(comm);
DataSet ds=new DataSet();
sda.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}
}
          }=====================================
下面是可直接运行的
<%@ Import Namespace="System.Data" %><html>

<script language="C#" runat="server">    ICollection CreateDataSource() {
        DataTable dt = new DataTable();
        DataRow dr;        dt.Columns.Add(new DataColumn("整数值", typeof(Int32)));
        dt.Columns.Add(new DataColumn("字符串值", typeof(string)));
        dt.Columns.Add(new DataColumn("日期时间值", typeof(DateTime)));
        dt.Columns.Add(new DataColumn("布尔值", typeof(bool)));
        dt.Columns.Add(new DataColumn("货币值", typeof(double)));        for (int i = 0; i < 9; i++) {
            dr = dt.NewRow();            dr[0] = i;
            dr[1] = "项 " + i.ToString();
            dr[2] = DateTime.Now;
            dr[3] = (i % 2 != 0) ? true : false;
            dr[4] = 1.23 * (i+1);            dt.Rows.Add(dr);
        }        DataView dv = new DataView(dt);
        return dv;
    }    void Page_Load(Object sender, EventArgs e) {
        MyDataGrid.DataSource = CreateDataSource();
        MyDataGrid.DataBind();
    }</script><body>    <h3><font face="宋体">简单的 DataGrid 示例</font></h3>    <form runat=server>      <ASP:DataGrid id="MyDataGrid" runat="server"
        BorderColor="black"
        BorderWidth="1"
        GridLines="Both"
        CellPadding="3"
        CellSpacing="0"
        Font-Name="宋体"
        Font-Size="8pt"
        HeaderStyle-BackColor="#aaaadd"
      />  </form></body>
</html>

调试易

救命!!!!!dataGrid的例子谁有啊????--在线等待

解决方案 »