?? excel.txt
字號:
private void bind()
{
OleDbConnection con =new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source="+Server.MapPath("abc.xls"));
OleDbDataAdapter da =new OleDbDataAdapter("select * from [users$]",con);
DataSet ds =new DataSet();
da.Fill(ds);
dg.DataSource =ds.Tables[0].DefaultView;
dg.DataBind();
}
OleDbConnection con =new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source="+Server.MapPath("abc.xls"));
OleDbDataAdapter da =new OleDbDataAdapter("select * from [users$]",con);
ds.DataSetName ="students";
da.Fill(ds,"學生表");
dg.DataSource =ds.Tables[0].DefaultView;
dg.DataBind();
ds.WriteXml(MapPath("abc.xml"),XmlWriteMode.IgnoreSchema);
// SqlConnection con1=new SqlConnection("server=(local);database=demo;uid=sa;pwd=;");
// SqlDataAdapter da1 =new SqlDataAdapter("select * from students",con1);
// da1.Update(ds);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -