这是被调用的一个函数,当searchterm传递了参数,我想把access数据库中book表中的name中的与searchterm类似的项存到datatable中,但是搞了半天还是无用。请高手指教。由于比较菜,请详细一点。谢谢。
public DataTable RetrieveRows(string searchterm)
{
using (OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=E:\\google\\db1.mdb"))
{
DataTable dtReturn = new DataTable();
con.Open();
OleDbCommand obj=new OleDbCommand("SELECT * from book where Name like 'a%' order by Name ",con);
OleDbParameter param = new OleDbParameter();
param.ParameterName = "@searchterm";
searchterm.Trim().Replace("'", "''");
searchterm += "%";
param.Value = searchterm;
obj.Parameters.Add(param);
OleDbDataAdapter adpt = new OleDbDataAdapter(obj); adpt.Fill(dtReturn);
con.Close();
return dtReturn;
}
}
public DataTable RetrieveRows(string searchterm)
{
using (OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=E:\\google\\db1.mdb"))
{
DataTable dtReturn = new DataTable();
con.Open();
OleDbCommand obj=new OleDbCommand("SELECT * from book where Name like 'a%' order by Name ",con);
OleDbParameter param = new OleDbParameter();
param.ParameterName = "@searchterm";
searchterm.Trim().Replace("'", "''");
searchterm += "%";
param.Value = searchterm;
obj.Parameters.Add(param);
OleDbDataAdapter adpt = new OleDbDataAdapter(obj); adpt.Fill(dtReturn);
con.Close();
return dtReturn;
}
}
解决方案 »
- 高手请进!.NET 操作xml
- 这几天很迷茫,很郁闷不知道怎么才能提起神来真正的做件事情
- 关于 FreeTextBox 为什么每次doPostback后,文本框会自动接收焦点?
- 我想用 asp.net + C# 实现以下功能,请问是否能实现?我需要学习什么相关知识?
- 如何在web.config文件中配置限制对某一目录的访问?
- 一段图片处理代码PHP代码转C#代码
- EXCEL数据导入到SQl问题
- 有分来送:怎样获取HTML代码
- 一个参数传递的问题?
- 怎样判断SqlCommand.Parameters["输出参数"]是否有返值或空?
- 如何将asp.net动态网页 弄成 html 格式的 ?
- 有用过FCKeditor(.net)的高手进来!!
要是SQL直接查询下面这些有什么用
OleDbParameter param = new OleDbParameter();
param.ParameterName = "@searchterm";
searchterm.Trim().Replace("'", "''");
searchterm += "%";
param.Value = searchterm;
obj.Parameters.Add(param);
{
DataTable dtReturn = new DataTable();
con.Open();
OleDbCommand obj=new OleDbCommand("SELECT * from book where Name like 'a%' order by Name ",con);
OleDbParameter param = new OleDbParameter();
OleDbDataAdapter adpt = new OleDbDataAdapter(obj);
adpt.Fill(dtReturn);
con.Close();
return dtReturn;
}