如何将我的enitity代码转换为参数化代码 [英] How can I convert my enitity code to parameterized code
本文介绍了如何将我的enitity代码转换为参数化代码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用此实体代码以降序显示datagrid我正在使用wpf c#和MySQL:
baseEntities dc = new baseEntities();
// 按降序显示表格中的数据
Mydatagrid .ItemsSource = dc.myentity.OrderByDescending(p = > p.myColumn)。ToList();
我尝试了什么:
我想将我的代码转换为paramatrized代码。
我希望得到你的帮助。
解决方案
我用过这个,它和我一起工作:
$ b
使用(MySqlConnection con = new MySqlConnection(ConString))
{
con.Open();
CmdString =按照mycolumn DESC的SELECT * FROM database.mytable order;
MySqlCommand cmd = new MySqlCommand(CmdString,con);
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable(mytable);
sda.Fill(dt);
myDataGrid.ItemsSource = dt.DefaultView;
}
感谢您的帮助。
< blockquote>
我们需要使用Func ...
baseEntities dc = new baseEntities();
Func< string> myColumnName =ColumnName;
//按降序显示表中的数据
Mydatagrid.ItemsSource = dc.myentity.OrderByDescending(myColumnName).ToList();
I used this entity code to display datagrid in descending order I'm using wpf c# and MySQL :
baseEntities dc = new baseEntities();
//display data in table in descending order
Mydatagrid.ItemsSource = dc.myentity.OrderByDescending(p => p.myColumn).ToList();
What I have tried:
I want to convert my code to paramatrized code .
I wish your help .
解决方案
I used this and it's work with me :
using (MySqlConnection con = new MySqlConnection(ConString)) { con.Open(); CmdString = "SELECT * FROM database.mytable order by mycolumn DESC "; MySqlCommand cmd = new MySqlCommand(CmdString, con); MySqlDataAdapter sda = new MySqlDataAdapter(cmd); DataTable dt = new DataTable("mytable"); sda.Fill(dt); myDataGrid.ItemsSource = dt.DefaultView; }
Thank you for help .
we need to use Func ... baseEntities dc = new baseEntities(); Func<string> myColumnName = "ColumnName"; //display data in table in descending order Mydatagrid.ItemsSource = dc.myentity.OrderByDescending(myColumnName ).ToList();
这篇关于如何将我的enitity代码转换为参数化代码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文