excel.txt

非常好的.net学习经验记录

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);