使用LINQ to DataSet填充Gridview。 [英] Fill Gridview using LINQ to DataSet.
本文介绍了使用LINQ to DataSet填充Gridview。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我是LINQ&的新手通过LINQ填充GridView。请参阅我的代码:
SqlConnection connection = new SqlConnection(ConfigurationManager) .AppSettings [ mas]);
DataSet ds = new DataSet();
string Query = string .Empty;
private void Bind_LINQ_To_DataSet()
{
Query = select * from dbo.Movie;
SqlDataAdapter da = new SqlDataAdapter(查询,连接);
da.Fill(ds, dbo.Movie);
var tbl = 来自 p ds.Tables [ dbo.Movie]。AsEnumerable()
其中 p.Field< int>( ID)== Convert.ToInt32(TextBox1.Text)
select p;
GridView1.Visible = true ;
GridView1.DataSource = tbl;
GridView1.DataBind();
}
受保护 void Button1_Click( object sender,EventArgs e)
{
Bind_LINQ_To_DataSet();
}
我的GridVIew是空的。任何建议都非常感激。
解决方案
Query = select * from dbo.Movie;
SqlDataAdapter da = new SqlDataAdapter(查询,连接);
da.Fill(ds, dbo.Movie);
var tbl = 来自 p ds.Tables [ dbo.Movie]。AsEnumerable()
其中 p.Field< int>( ID)== Convert.ToInt32(TextBox1.Text)
选择 new p;
GridView1.Visible = true ;
GridView1.DataSource = tbl.Tabels [ 0 ]。DefaultView;
GridView1.DataBind();
或
DataTable table =(DataTable)Session [ 保存];
var query = 来自 c table.AsEnumerable()
选择 new {c.Week, c.Person,c.Guess,c.Actual};
GridView2.DataSource = query;
GridView2.DataBind();
可以尝试这样并将数据表绑定到Gridview数据源。 />
DataTable movie = ds.Tables [ dbo.Movie跨度>];
IEnumerable< DataRow> query =
from movie in movie.AsEnumerable()
其中 movie.Field< int>( ID) == Convert.ToInt32(TextBox1.Text)
选择电影;
// 从查询中创建一个表。
DataTable boundTable = query.CopyToDataTable< DataRow>();
GridView1.Visible = true ;
GridView1.DataSource = boundTable;
GridView1.DataBind();
< / datarow > < / int > < / datarow >
I'm new in LINQ & filling GridView through LINQ. Please see my code :
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["mas"]);
DataSet ds = new DataSet();
string Query = string.Empty;
private void Bind_LINQ_To_DataSet()
{
Query = "select * from dbo.Movie";
SqlDataAdapter da = new SqlDataAdapter(Query, connection);
da.Fill(ds, "dbo.Movie");
var tbl = from p in ds.Tables["dbo.Movie"].AsEnumerable()
where p.Field<int>("ID") == Convert.ToInt32(TextBox1.Text)
select p;
GridView1.Visible = true;
GridView1.DataSource = tbl;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
Bind_LINQ_To_DataSet();
}
My GridVIew comes empty. Any suggestion really appreciate.
解决方案
Query = "select * from dbo.Movie"; SqlDataAdapter da = new SqlDataAdapter(Query, connection); da.Fill(ds, "dbo.Movie"); var tbl = from p in ds.Tables["dbo.Movie"].AsEnumerable() where p.Field<int>("ID") == Convert.ToInt32(TextBox1.Text) select new p; GridView1.Visible = true; GridView1.DataSource = tbl.Tabels[0].DefaultView; GridView1.DataBind();
or
DataTable table = (DataTable)Session["Save"]; var query = from c in table.AsEnumerable() select new { c.Week,c.Person,c.Guess,c.Actual}; GridView2.DataSource = query; GridView2.DataBind();
May be you can try like this and bind the datatable to the Gridview datasource.
DataTable movie = ds.Tables["dbo.Movie"]; IEnumerable<DataRow> query = from movie in movie.AsEnumerable() where movie.Field<int>("ID") == Convert.ToInt32(TextBox1.Text) select movie; // Create a table from the query. DataTable boundTable = query.CopyToDataTable<DataRow>(); GridView1.Visible = true; GridView1.DataSource = boundTable ; GridView1.DataBind(); </datarow></int></datarow>
这篇关于使用LINQ to DataSet填充Gridview。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文