本文介绍了在这种情况下如何在asp中编写LINQ查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
table_name:游戏 列名:名称
名称 3test 4test Aron Ball选择名称来自游戏其中名称< ' A' order by name
输出 3test 4test
如何在asp中运行LINQ
SqlCommand cmd = 新 SqlCommand( 从游戏中选择名称<'A'按名称排序,con); SqlDataAdapter adapBrand = new SqlDataAdapter(cmd); DataSet dataBrand = new DataSet(); adapBrand.Fill(dataBrand); pubcon.Close(); dataBrand.Tables [ 0 ]。TableName = brandall; DataView dataView = new DataView(); EnumerableRowCollection< datarow>查询; query =如何将LINQ查询写入获取记录 i sqlserver中的code-keyword> get ? dataView = query.AsDataView(); DataList1.DataSource = dataView; DataList1.DataBind();谢谢
解决方案var query = from g 在游戏中 其中 g.Name < orderby g.Name 选择 g;
希望我说对了;) -KR
试试这个: DataTable dt = new DataTable(); dt.Columns.Add( new DataColumn( name, typeof ( string ))); dt.Rows.Add( new Object [] { 3test}); dt.Rows.Add( new Object [] { 4test}); dt.Rows.Add( new Object [] { Aron}); dt.Rows.Add( new Object [] { Ball}); 正则表达式reg = 新正则表达式( @ ^ \d +); var result = dt.AsEnumerable() .Where(a => reg.IsMatch(a.Field< string> ;( name))) .OrderBy(a => a.Field< ; string>( name)); // 结果返回:OrderedEnumerableRowCollection< DataRow>
退货:
3test 4test
table_name : game Column Name : name
name 3test 4test Aron Ballselect name from game where name <'A' order by name
output 3test 4test
how to do in asp LINQ
SqlCommand cmd = new SqlCommand("select name from game where name <'A' order by name ", con); SqlDataAdapter adapBrand = new SqlDataAdapter(cmd); DataSet dataBrand = new DataSet(); adapBrand.Fill(dataBrand); pubcon.Close(); dataBrand.Tables[0].TableName = "brandall"; DataView dataView = new DataView(); EnumerableRowCollection<datarow> query; query = how to write a LINQ query to get record as i get in sqlserver? dataView = query.AsDataView(); DataList1.DataSource = dataView; DataList1.DataBind();Thank you
解决方案 var query = from g in game where g.Name < "A" orderby g.Name select g;Hope I got it right ;) -KR
Try this: DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("name", typeof(string))); dt.Rows.Add(new Object[]{"3test"}); dt.Rows.Add(new Object[]{"4test"}); dt.Rows.Add(new Object[]{"Aron"}); dt.Rows.Add(new Object[]{"Ball"}); Regex reg = new Regex(@"^\d+"); var result = dt.AsEnumerable() .Where(a=>reg.IsMatch(a.Field<string>("name"))) .OrderBy(a=>a.Field<string>("name")); //result returns: OrderedEnumerableRowCollection<DataRow>Returns:
3test 4test更多推荐
在这种情况下如何在asp.net中编写LINQ查询
发布评论