偶是菜鸟,大家帮帮我!谢谢了。(关于读取数据的问题) 恩 都是通过ado.net ole db 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 读取EXCEL文件可以使用ado.net(oleDb).txt文件当然只能自己读写了。 这上面这样的代码很多!用 EXCEL 做关键字搜索一下吧! 各位大侠能帮我把代码贴出来吗?感谢啊。还有怎样把一个EXCEL文件转成DLL文件?请指教啊。:) 当他是数据库一样连接完了读啊(其实就是一张表),string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = e:\\bj.xls;Extended Properties=Excel 8.0" ;myConn = new OleDbConnection( strCon ) ;string sql="select * from [Sheet1$]";//默认的,自己看他的工作簿叫什么名字............................ using System ;using System.Drawing ;using System.Collections ;using System.ComponentModel ;using System.Windows.Forms ;using System.Data ;using System.Data.OleDb ;public class Form1 : Form{private Button button1 ;private System.Data.DataSet myDataSet ;private DataGrid DataGrid1 ;private System.ComponentModel.Container components = null ;public Form1 ( ){//初始化窗体中的各个组件InitializeComponent ( ) ;//打开数据链接,得到数据集GetConnect ( ) ;}//清除程序中使用过的资源protected override void Dispose ( bool disposing ){if ( disposing ){if ( components != null ) {components.Dispose ( ) ;}}base.Dispose ( disposing ) ;}private void GetConnect ( ){//创建一个数据链接string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = c:\\sample.xls;Extended Properties=Excel 8.0" ;OleDbConnection myConn = new OleDbConnection ( strCon ) ;string strCom = " SELECT * FROM [Sheet1$] " ;myConn.Open ( ) ;//打开数据链接,得到一个数据集OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ;//创建一个 DataSet对象myDataSet = new DataSet ( ) ;//得到自己的DataSet对象myCommand.Fill ( myDataSet , "[Sheet1$]" ) ;//关闭此数据链接myConn.Close ( ) ;}private void InitializeComponent ( ){DataGrid1 = new DataGrid ( ) ;button1 = new Button ( ) ;SuspendLayout ( ) ;DataGrid1.Name = "DataGrid1";DataGrid1.Size = new System.Drawing.Size ( 400 , 200 ) ;button1.Location = new System.Drawing.Point ( 124 , 240 ) ;button1.Name = "button1" ;button1.TabIndex = 1 ;button1.Text = "读取数据" ;button1.Size = new System.Drawing.Size (84 , 24 ) ;button1.Click += new System.EventHandler ( this.button1_Click ) ;this.AutoScaleBaseSize = new System.Drawing.Size ( 6 , 14 ) ;this.ClientSize = new System.Drawing.Size ( 400 , 280 ) ;this.Controls.Add ( button1 ) ;this.Controls.Add ( DataGrid1 ) ;this.Name = "Form1" ;this.Text = "读取Excle表格中的数据,并用DataGrid显示出来!" ;this.ResumeLayout ( false ) ;}private void button1_Click ( object sender , System.EventArgs e ){DataGrid1.DataMember= "[Sheet1$]" ;DataGrid1.DataSource = myDataSet ;}static void Main ( ) {Application.Run ( new Form1 ( ) ) ;}} C#如何实现不同窗体之间的数据通信 求数组拆分算法 求助!如何检测Powerpoint是否运行 [求助]动态生成控件控制另一个动态生成控件 一个关于webbrowser的问题 有谁知道怎样控制windows声音面板上的属性? 自定义控件的属性的问题,标题虽是老问题,但请进来看看! C#中怎么从htm中读取数据? WebService问题 关于打印信息监控的问题,请各位帮忙!!! 我想删除DataGrid中的一行,该怎么做? delphi7---> delphi 2005 的问题
txt文件当然只能自己读写了。
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = e:\\bj.xls;Extended Properties=Excel 8.0" ;
myConn = new OleDbConnection( strCon ) ;
string sql="select * from [Sheet1$]";//默认的,自己看他的工作簿叫什么名字............................
using System.Drawing ;
using System.Collections ;
using System.ComponentModel ;
using System.Windows.Forms ;
using System.Data ;
using System.Data.OleDb ;
public class Form1 : Form
{
private Button button1 ;
private System.Data.DataSet myDataSet ;
private DataGrid DataGrid1 ;
private System.ComponentModel.Container components = null ;
public Form1 ( )
{
//初始化窗体中的各个组件
InitializeComponent ( ) ;
//打开数据链接,得到数据集
GetConnect ( ) ;
}
//清除程序中使用过的资源
protected override void Dispose ( bool disposing )
{
if ( disposing )
{
if ( components != null )
{
components.Dispose ( ) ;
}
}
base.Dispose ( disposing ) ;
}
private void GetConnect ( )
{
//创建一个数据链接
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = c:\\sample.xls;Extended Properties=Excel 8.0" ;
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
string strCom = " SELECT * FROM [Sheet1$] " ;
myConn.Open ( ) ;
//打开数据链接,得到一个数据集
OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ;
//创建一个 DataSet对象
myDataSet = new DataSet ( ) ;
//得到自己的DataSet对象
myCommand.Fill ( myDataSet , "[Sheet1$]" ) ;
//关闭此数据链接
myConn.Close ( ) ;
}
private void InitializeComponent ( )
{
DataGrid1 = new DataGrid ( ) ;
button1 = new Button ( ) ;
SuspendLayout ( ) ;
DataGrid1.Name = "DataGrid1";
DataGrid1.Size = new System.Drawing.Size ( 400 , 200 ) ;
button1.Location = new System.Drawing.Point ( 124 , 240 ) ;
button1.Name = "button1" ;
button1.TabIndex = 1 ;
button1.Text = "读取数据" ;
button1.Size = new System.Drawing.Size (84 , 24 ) ;
button1.Click += new System.EventHandler ( this.button1_Click ) ;
this.AutoScaleBaseSize = new System.Drawing.Size ( 6 , 14 ) ;
this.ClientSize = new System.Drawing.Size ( 400 , 280 ) ;
this.Controls.Add ( button1 ) ;
this.Controls.Add ( DataGrid1 ) ;
this.Name = "Form1" ;
this.Text = "读取Excle表格中的数据,并用DataGrid显示出来!" ;
this.ResumeLayout ( false ) ;
}
private void button1_Click ( object sender , System.EventArgs e )
{
DataGrid1.DataMember= "[Sheet1$]" ;
DataGrid1.DataSource = myDataSet ;
}
static void Main ( )
{
Application.Run ( new Form1 ( ) ) ;
}
}