OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\;Extended Properties=dBASE IV;");
string sql = "select * from [all] where @cx ";
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = new OleDbCommand(sql, con);
OleDbParameter p1 = new OleDbParameter("@cx", OleDbType.BSTR);
p1.Value = "Name like '%沪%'";
oda.SelectCommand.Parameters.Add(p1);
DataSet ds = new DataSet();
oda.Fill(ds);怎么改呢?
string sql = "select * from [all] where @cx ";
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = new OleDbCommand(sql, con);
OleDbParameter p1 = new OleDbParameter("@cx", OleDbType.BSTR);
p1.Value = "Name like '%沪%'";
oda.SelectCommand.Parameters.Add(p1);
DataSet ds = new DataSet();
oda.Fill(ds);怎么改呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货