在我的asp.net中，我想在数据集中获取gridview数据，如何执行此操作 [英] In my asp.net iwant to get gridview data in a dataset how to do this

问题描述

在我的asp.net中，我想获取数据集中的gridview数据该怎么做

任何人都可以帮助我.....

In my asp.net iwant to get gridview data in a dataset how to do this

any one please help me.....

推荐答案

看看这个

Have a look on this

DataTable dt = new DataTable();

    // add the columns to the datatable            
    if (GridView1.HeaderRow != null)
    {

        for (int i = 0; i < GridView1.HeaderRow.Cells.Count; i++)
        {
            dt.Columns.Add(GridView1.HeaderRow.Cells[i].Text);
        }
    }

    //  add each of the data rows to the table
    foreach (GridViewRow row in GridView1.Rows)
    {
        DataRow dr;
        dr = dt.NewRow();

        for (int i = 0; i < row.Cells.Count; i++)
        {
            dr[i] = row.Cells[i].Text.Replace(" ","");
        }
        dt.Rows.Add(dr);
    }

    //  add the footer row to the table
    if (GridView1.FooterRow != null)
    {
        DataRow dr;
        dr = dt.NewRow();

        for (int i = 0; i < GridView1.FooterRow.Cells.Count; i++)
        {
            dr[i] = GridView1.FooterRow.Cells[i].Text.Replace(" ","");
        }
        dt.Rows.Add(dr);
    }

尝试一下...


数据集中的Gridview数据

DataSet ds =(DataSet)Gridview1.DataSource;

从数据库获取数据并填充到gridview

Try this...


Gridview data in dataset

DataSet ds = (DataSet)Gridview1.DataSource;

Get data from database and populate to gridview

SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlDataReader rd;
SqlCommand cmd = new SqlCommand("Select * from tablename", con);
rd = cmd.ExecuteReader();
GridView1.DataSource = rd;
GridView1.DataBind();
rd.Close();
con.Close();

在aspx页面中

In aspx page

<asp:gridview id="GridView1" runat="server" xmlns:asp="#unknown"> 
</asp:gridview>

希望这会有所帮助.
欢呼

Hope this helps.
cheers

嗨

在下面使用，

hi

used below,

DataSet tbl = GrdCCCSList.DataSource as DataSet; 

希望对您有帮助

hope this will help you

这篇关于在我的asp.net中，我想在数据集中获取gridview数据，如何执行此操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！