string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=m3.mdb";//使连接到数据库
string comandstring = "select DateTime,L_MESSAGE from Sheet1 where L_MESSAGE in(select L_MESSAGE from Sheet1)";
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(comandstring, connectionstring);//public OleDbDataAdapter(string selectCommandText选择语句, string selectConnectionString连接字符串);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
string comandstring = "select DateTime,L_MESSAGE from Sheet1 where L_MESSAGE in(select L_MESSAGE from Sheet1)";
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(comandstring, connectionstring);//public OleDbDataAdapter(string selectCommandText选择语句, string selectConnectionString连接字符串);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
解决方案 »
- XmlDocument.load()缺少根元素
- 高手请进,一个很困惑的问题!!!
- 紧急求助:如何将16进制数0x0转换为字符串"00000000"啊?
- c#如何dele all foxpro数据库
- 如何在一个事件中得到调用它的控件????
- 关于使用XML建立音乐播放器的播放列表问题
- 如何用C#实现PE文件文本的十六进制显示
- !--------------求一段简单的代码!----------!
- 翻了整个msdn都没看到,SqlDataReader怎样读当前记录的上一条记录???
- 公共构造方法是什么意思啊?
- 求SqlConnection,SqlCommand,SqlDataReader和SqlParameter的用法总结
- 如何传递的问题?
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(comandstring, connectionstring);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=m3.mdb";//使连接到数据库
string comandstring = "select DateTime,L_MESSAGE from Sheet1 where L_MESSAGE in(select L_MESSAGE from Sheet1)";//加上这个
OleDbConnection oconn=new OleDbConnection(connectionstring);OleDbDataAdapter dataAdapter = new OleDbDataAdapter(comandstring, oconn);DataSet ds = new DataSet();
dataAdapter.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
但是这段话放在这里就显示运行错误了::至少一个参数没有指定值
很奇怪,我试了,单独运行可以,但是放在一下这里就不行。
private void 连接数据库ToolStripMenuItem_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "excel文件(*.xls)|*.xls|所有文件(*.*)|*.*"; //设置筛选器
openFileDialog1.Title = "请选择要导入的excel表格";
if (DialogResult.OK == openFileDialog1.ShowDialog(this))
{
string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=m3.mdb";//使连接到数据库
string comandstring = "select DateTime,L_MESSAGE from Sheet1 where L_MESSAGE in(select L_MESSAGE from Sheet1)";
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(comandstring, connectionstring);//public OleDbDataAdapter(string selectCommandText选择语句, string selectConnectionString连接字符串);
DataSet myDataSet = new DataSet();
dataAdapter.Fill(myDataSet);
this.dataGridView1.DataSource = myDataSet.Tables[0];
}
}