62,025
社区成员
发帖
与我相关
我的任务
分享
public M_cate GetcateByCID(string cid)
{
M_cate mcate = new M_cate();
OleDbDataReader read=OleDbHelper.ExecuteReader(getcatebycid, pm.parames(new string[] { "CID" }, new object[] { cid }));
if (read.Read())
{
mcate.Description = read["Description"].ToString();
mcate.Tid = read["Description"].ToString();
read.Close();
return mcate;
}
read.Close();
return mcate;
}
public static OleDbDataReader ExecuteReader(string strSQL)
{
OleDbConnection connection = new OleDbConnection(Unity.ConnectionString);
OleDbCommand cmd = new OleDbCommand(strSQL, connection);
try
{
if(connection.State!=ConnectionState.Open)
connection.Open();
OleDbDataReader myReader = cmd.ExecuteReader();
return myReader;
}
catch (System.Data.OleDb.OleDbException e)
{
throw new Exception(e.Message);
}
}
public static int ExecuteNonQuery(string SQLString)
{
int rows = 0;
using (OleDbConnection connection = new OleDbConnection(Unity.ConnectionString))
{
using (OleDbCommand cmd = new OleDbCommand(SQLString, connection))
{
try
{
if (connection.State != ConnectionState.Open)
connection.Open();
rows = cmd.ExecuteNonQuery();
}
catch (System.Data.OleDb.OleDbException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
return rows;
}