如何将gridview的数据绑定到datatable [英] How to bind the data of gridview to datatable
问题描述
我想将gridview的数据绑定到Datatable,
网格视图源来自MS SQL Server 2008
这是aspx页面
< asp:GridView ID = GridView1 runat = server
>
< 列 >
< asp:TemplateField >
< ItemTemplate >
< asp:CheckBox ID = chkb runat = server / >
< / ItemTemplate >
< / asp:TemplateField >
< /列 >
< / asp:GridView >
Cs
SqlDataAdapter da = new SqlDataAdapter(Select * from test,con);
DataSet ds = new DataSet();
da.Fill(ds,test);
GridView1.DataSource = ds;
GridView1.DataBind();
我想通过数据再次到sql server到另一个表plz帮帮我
DataTable tbl = GridView1.DataSource as DataTable;
使用此代码..
您应该使用EF从数据库中获取数据,然后您应该实现通过对给定数据进行一些处理来动态创建数据表的下一个方法,如下一个示例所示:
public static DataTable ListToDataTable(List< User> entityList)
{
DataTable usersDataTable = new DataTable();
//
usersDataTable.Columns.Add( ID, typeof ( INT 跨度>));
usersDataTable.Columns.Add( Person, typeof ( string ));
usersDataTable.Columns.Add( Center, typeof ( string ));
usersDataTable.Columns.Add( 服务, typeof ( string ));
usersDataTable.Columns.Add( UserName, typeof ( string ));
usersDataTable.Columns.Add( Email, typeof ( string ));
//
foreach (用户用户 in entityList)
{
usersDataTable.Rows.Add(user.ID,
字符串 .Format( {0} {1} ,user.FirstName,user.LastName),
(user.Center == null ? DGASPC:user.Center.Name),
(user.Service == null ? string .Empty:user.Service.Name),
user.UserName,
(user.Email == null ? string .Empty:user.Email));
}
//
返回 usersDataTable;
}
< asp:gridview id =GridView1runat =serverxmlns:asp =#unknown>
>
< columns> < asp:templatefield>
< itemtemplate>
< asp:checkbox id =chkbrunat =servertext =<%Eval( your =row =name)& gt;=>
使用
'所以它将解决% >]]>
I want to bind the data of gridview to Datatable ,
source of grid view is from MS SQL Server 2008
Here is the aspx page
<asp:GridView ID="GridView1" runat="server"
>
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="chkb" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Cs
SqlDataAdapter da = new SqlDataAdapter("Select * from test", con);
DataSet ds = new DataSet();
da.Fill(ds, "test");
GridView1.DataSource = ds;
GridView1.DataBind();
and i want to pass the data again to sql server to another table plz help me out
DataTable tbl = GridView1.DataSource as DataTable;
use this code..
You should use EF to get your data from database, then you should implement a method like the next one to dynamic create a data table by doing also some processing on the given data like in the next example:
public static DataTable ListToDataTable(List<User> entityList) { DataTable usersDataTable = new DataTable(); // usersDataTable.Columns.Add("ID", typeof(int)); usersDataTable.Columns.Add("Person", typeof(string)); usersDataTable.Columns.Add("Center", typeof(string)); usersDataTable.Columns.Add("Service", typeof(string)); usersDataTable.Columns.Add("UserName", typeof(string)); usersDataTable.Columns.Add("Email", typeof(string)); // foreach (User user in entityList) { usersDataTable.Rows.Add(user.ID, String.Format("{0} {1}", user.FirstName, user.LastName), (user.Center == null ? "DGASPC" : user.Center.Name), (user.Service == null ? string.Empty : user.Service.Name), user.UserName, (user.Email == null ? string.Empty : user.Email)); } // return usersDataTable; }
<asp:gridview id="GridView1" runat="server" xmlns:asp="#unknown">
>
<columns> <asp:templatefield>
<itemtemplate>
<asp:checkbox id="chkb" runat="server" text="<%Eval(" your="" row="" name")>"="">
use
' so it will resolve%>]]>
这篇关于如何将gridview的数据绑定到datatable的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!