1610tmt
22-12-2010, 22:08
public static DataSet ExQuery(string SqlQuery, CommandType commandType, params object[] pars)
{
OleDbConnection con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source=VANTUAN;Initial Catalog=QLKTX;Integrated Security=True");
con.Open();
OleDbCommand com = new OleDbCommand(SqlQuery, con);
com.CommandType = commandType;
for (int i = 0; i < pars.Length; i++)
{
OleDbParameter par = new OleDbParameter(pars[i].ToString(), pars[i + 1]);
com.Parameters.Add(par);
}
OleDbDataAdapter da = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
mình chạy thì nó báo lỗi con.OPen(); ai bít chỉ dùm nha, t2 nộp dùi
ah quên mình xài 3 tầng, ai co bài thì cho minh xin nhé. thank
email: changtraibanggia8008
{
OleDbConnection con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source=VANTUAN;Initial Catalog=QLKTX;Integrated Security=True");
con.Open();
OleDbCommand com = new OleDbCommand(SqlQuery, con);
com.CommandType = commandType;
for (int i = 0; i < pars.Length; i++)
{
OleDbParameter par = new OleDbParameter(pars[i].ToString(), pars[i + 1]);
com.Parameters.Add(par);
}
OleDbDataAdapter da = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
mình chạy thì nó báo lỗi con.OPen(); ai bít chỉ dùm nha, t2 nộp dùi
ah quên mình xài 3 tầng, ai co bài thì cho minh xin nhé. thank
email: changtraibanggia8008