帮忙封装一个带参数的类
<p ><strong>fengdie</strong> 发表于 2009-9-5 11:08</p>
<h3>帮忙封装一个带参数的类</h3>经常需要查询写一下代码：请问要怎么封装呢？
DataBase db = new DataBase();
OleDbConnection Conn = db.GetConn();
OleDbCommand Cmd = new OleDbCommand("select * from where UserName=@UserName and PassWord=@PassWord", Conn);
Cmd.Parameters.Add("@UserName", OleDbType.VarChar, 20).Value = UserName.Text.Trim();
Cmd.Parameters.Add("@PassWord", OleDbType.VarChar, 20).Value = PassWord.Text.Trim();
OleDbDataReader dr = Cmd.ExecuteReader();<p ><strong>luby</strong> 发表于 2009-9-15 17:36</p>
public class Db
{
public OdbcDataReader ReturnDr(string name,string password)
{
DataBase db = new DataBase();
OleDbConnection Conn = db.GetConn();
OleDbCommand Cmd = new OleDbCommand("select * from where UserName=@UserName and PassWord=@PassWord", Conn);
Cmd.Parameters.Add("@UserName", OleDbType.VarChar, 20).Value = UserName.Text.Trim();
Cmd.Parameters.Add("@PassWord", OleDbType.VarChar, 20).Value = PassWord.Text.Trim();
OleDbDataReader dr = Cmd.ExecuteReader();
return dr;
}
}
这样不就行了？ new一下，直接输入参数返回结果。
页:
[1]