如何将我的enitity代码转换为参数化代码 [英] How can I convert my enitity code to parameterized code

问题描述

我使用此实体代码以降序显示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屋！