62,046
社区成员
发帖
与我相关
我的任务
分享
string const SQL_SELECT="select * from liu where u-id=@u_id";
string const string PARM_USER_ID = "@u_id";
OleDbParameter parm = new OleDbParameter (PARM_USER_ID, OleDbType.VarChar, 20);
parm.value=strID;
OleDbCommand cmd = new OleDbCommand();
cmd.Parameters.Add(parm);
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("liuyan.mdb");
using (OleDbConnection conn = new SqlConnection(strConn))
{
Conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = SQL_SELECT;
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "han");
cmd.Parameters.Clear();
}