困扰了挺久,求助。不知道哪儿出现问题了。c#连接excel,sheet名为table。
sql语句如下,
sql = "select * from [table$A:G] where ‘性别’ in (" + state + ")";
sql = sql + "and ‘名字’ in (" + tbxName.Text.ToString() + ")";
sql = sql + " and ‘年龄’ > " + tbxYearMin.Text.ToString() + " and ‘年龄’ < " + tbxYearMax.Text.ToString();
sql = sql+ " and ‘身高’ > "+ tbxHighMin.Text.ToString() + " and ‘身高’ < " + tbxHighMax.Text.ToString();
获得dataset语句:
ds = DataSetRead(sql, "table");
public static DataSet DataSetRead(string sql, string sheetName)
{
using (OleDbConnection OleConn = new OleDbConnection(OleConnectionString))
{
DataSet ds = new DataSet();
OleConn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql, OleConnectionString);
da.Fill(ds, sheetName);
return ds;
} }
da.Fill(ds, sheetName)有错误:至少一个参数没有被指定值。谢谢大家!
sql语句如下,
sql = "select * from [table$A:G] where ‘性别’ in (" + state + ")";
sql = sql + "and ‘名字’ in (" + tbxName.Text.ToString() + ")";
sql = sql + " and ‘年龄’ > " + tbxYearMin.Text.ToString() + " and ‘年龄’ < " + tbxYearMax.Text.ToString();
sql = sql+ " and ‘身高’ > "+ tbxHighMin.Text.ToString() + " and ‘身高’ < " + tbxHighMax.Text.ToString();
获得dataset语句:
ds = DataSetRead(sql, "table");
public static DataSet DataSetRead(string sql, string sheetName)
{
using (OleDbConnection OleConn = new OleDbConnection(OleConnectionString))
{
DataSet ds = new DataSet();
OleConn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql, OleConnectionString);
da.Fill(ds, sheetName);
return ds;
} }
da.Fill(ds, sheetName)有错误:至少一个参数没有被指定值。谢谢大家!
解决方案 »
- 用storyboard做控件的移动,必须结合Canvas吗?
- 怎样在GridView1最后一行显示对上面所有行的列求和的结果
- 关于参数ref和out的作用。
- 调用苹果手机播放器代码。。。。。在线等
- 我准备学多线程了,请大家推荐一本关于C#多线程比较通俗易懂的书(最好是网上可以下)或是比较正规和成功的网上教程。
- C#2005 TreeView的一些问题
- 急!!!求sql查询重复数据语句!在线等!
- 对于不同的客户端发出的Socket请求,服务器怎么区分是哪个的请求啊?
- 在ICSharpCode.SharpZipLib.dll这个包里可不可以对zip包进行"增删改查"?
- 请问怎样在C#程序中打开WORD文档??
- Object类型的小数转换问题
- C#:嵌入的语句不能是声明或标记语句
行2:sql = sql + "and ‘名字’ in (" + tbxName.Text.ToString() + ")";and前少了个空格??? sql = sql + " and ‘名字’ in (" + tbxName.Text.ToString() + ")";
select * from [table$A:G] where '性别' in ('F','M') and '名字' in ('Dav','Chery') and '年龄' > '20' and '年龄' < '100' and '身高' > '1.6' and '身高' < '2.0';
但是EXCEL表里这几列不管我换成什么单元格格式:数值或文本或常规,都查询不出结果。即使是简单的select * from [table$A:G] where '性别' in ('F','M');也不可以。是什么原因呢,多谢指教!