using System;
using System.Data;
using System.Data.OleDb;namespace Weboy.GuestBook.Data
{
public class MyDb
{
private OleDbConnection con=null;
private OleDbCommand com=null;
private OleDbDataAdapter da=null;
private int intScalar=0;
private DataSet ds=new DataSet();
//OK
public MyDb(string conStr)
{
con=new OleDbConnection(conStr);
}
//OK
public DataSet MySelect(string sqlStr,string tableName)
{
da = new OleDbDataAdapter(sqlStr,con);
da.Fill(ds,tableName);
return ds;
}
//OK
public void MyInsert(string sqlStr)
{
con.Open();
com = new OleDbCommand(sqlStr,con);
com.ExecuteNonQuery();
con.Close();
}
//OK
public void MyUpdate(string sqlStr)
{
con.Open();
com = new OleDbCommand(sqlStr,con);
com.ExecuteNonQuery();
con.Close();
} //OK
public int MyScalar(string sqlStr)
{
con.Open();
try
{
com = new OleDbCommand(sqlStr,con);
intScalar=(int)com.ExecuteScalar();
con.Close();
return intScalar;
}
catch(Exception e)
{
con.Close();
return 0;
}
}
//OK
public void MyClose()
{
con.Close();
}
}
}
using System.Data;
using System.Data.OleDb;namespace Weboy.GuestBook.Data
{
public class MyDb
{
private OleDbConnection con=null;
private OleDbCommand com=null;
private OleDbDataAdapter da=null;
private int intScalar=0;
private DataSet ds=new DataSet();
//OK
public MyDb(string conStr)
{
con=new OleDbConnection(conStr);
}
//OK
public DataSet MySelect(string sqlStr,string tableName)
{
da = new OleDbDataAdapter(sqlStr,con);
da.Fill(ds,tableName);
return ds;
}
//OK
public void MyInsert(string sqlStr)
{
con.Open();
com = new OleDbCommand(sqlStr,con);
com.ExecuteNonQuery();
con.Close();
}
//OK
public void MyUpdate(string sqlStr)
{
con.Open();
com = new OleDbCommand(sqlStr,con);
com.ExecuteNonQuery();
con.Close();
} //OK
public int MyScalar(string sqlStr)
{
con.Open();
try
{
com = new OleDbCommand(sqlStr,con);
intScalar=(int)com.ExecuteScalar();
con.Close();
return intScalar;
}
catch(Exception e)
{
con.Close();
return 0;
}
}
//OK
public void MyClose()
{
con.Close();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货