wpf excel导入mysql_WPF把excel数据导入到数据库

List

listdatagrid;

//MainWindowViewModel存字段的类里面就放了几个字段

​

DB.zeroqiEntities db = new

DB.zeroqiEntities();//ef

//把excel数据导入到datagrid显示出来​

private void Button_Click(object sender,

RoutedEventArgs e)

{

MainWindowViewModel mainmodel ;

listdatagrid=new List();

DataTable

tb= GetDataFromExcelByConn();

for (int i

= 0; i < tb.Rows.Count; i++)

{

mainmodel = new

MainWindowViewModel();

mainmodel.card_code=

tb.Rows[i]["会员卡号"].ToString();

mainmodel.card_style =

tb.Rows[i]["会员类别"].ToString();

mainmodel.card_name =

tb.Rows[i]["会员名称"].ToString();

mainmodel.sex =

tb.Rows[i]["性别"].ToString();

listdatagrid.Add(mainmodel);

}

<