======新手上路:求,一个简单的类(数据库打开,读取,异常处理)然后调用class使用的例子========== 新手上路:求,一个简单的类(数据库打开,读取,异常处理)然后调用class使用的例子分是少了点.但希望大虾门能给点提示.谢谢. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 using System;using System.Data;using System.Data.SqlClient;namespace qminoa.DA{ public class ResiveModule { private SqlDataAdapter csCommand; private SqlConnection conn; public ResiveModule() { csCommand = new SqlDataAdapter(); csCommand.SelectCommand =new SqlCommand(); conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]); } public DataSet FillPerson(int DepartID) { SqlCommand command = csCommand.SelectCommand; command.CommandText = "Msg_GetEmpByDep"; command.CommandType = CommandType.StoredProcedure; SqlParameter para = new SqlParameter("@DepartID",SqlDbType.Int); para.Value = DepartID; command.Parameters.Add(para); command.Connection = conn; DataSet data = new DataSet(); csCommand.Fill(data,"person"); return data; } }}调用的时候:qminoa.DA.ResiveModule demo=new qminoa.DA.ResiveModule();demo.FillPerson(int.Parse(Session["UserID"].ToString())); public class DBCommon { private static string ErrorMessage=""; //private static OracleConnection conn=null; public static OracleConnection GetConnection() { //if(conn==null) OracleConnection conn=new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]); return conn; } public static string GetLastError() { return DBCommon.ErrorMessage; } public static bool ExecSql(string sql) { try { OracleConnection con=DBCommon.GetConnection(); OracleCommand cmd=new OracleCommand(sql,con); if(con.State!=ConnectionState.Open) con.Open(); cmd.ExecuteNonQuery(); con.Close(); return true; } catch(Exception e) { DBCommon.ErrorMessage=e.Message; // DBCommon.ErrorMessage=sql; return false; } } public static DataSet ExecSqlDS(string sql) { try { OracleConnection con=DBCommon.GetConnection(); //OracleCommand cmd=new OracleCommand(sql,con); OracleDataAdapter da=new OracleDataAdapter(sql,con); DataSet ds=new DataSet(); con.Open(); da.Fill(ds); con.Close(); return ds; } catch(Exception e) { DBCommon.ErrorMessage=e.Message; return null; } } 排版出现问题。 ListBox1.SelectedItem 为NULL WindowForm 的打印问题 [求助]贴1个文件上传的源代码,请高手改下实现下载功能.在线等改出来就散分 数据库不能更新问题 学习asp.net 关于新浪微博API服务器端是.json文件 新手请教! 那位大哥帮我推荐几本书关于asp.net 这样写为什么不对,应该如何写? 在MSDN的TreeView里面找不到createTreeNode这个函数,这个函数是什么函数? ASP.NET首次运行要多少时间?
using System.Data;
using System.Data.SqlClient;
namespace qminoa.DA
{
public class ResiveModule
{
private SqlDataAdapter csCommand;
private SqlConnection conn; public ResiveModule()
{
csCommand = new SqlDataAdapter();
csCommand.SelectCommand =new SqlCommand();
conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
} public DataSet FillPerson(int DepartID)
{
SqlCommand command = csCommand.SelectCommand;
command.CommandText = "Msg_GetEmpByDep";
command.CommandType = CommandType.StoredProcedure;
SqlParameter para = new SqlParameter("@DepartID",SqlDbType.Int);
para.Value = DepartID;
command.Parameters.Add(para);
command.Connection = conn;
DataSet data = new DataSet();
csCommand.Fill(data,"person");
return data;
}
}
}
调用的时候:
qminoa.DA.ResiveModule demo=new qminoa.DA.ResiveModule();
demo.FillPerson(int.Parse(Session["UserID"].ToString()));
{
private static string ErrorMessage="";
//private static OracleConnection conn=null; public static OracleConnection GetConnection()
{
//if(conn==null)
OracleConnection conn=new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
return conn;
} public static string GetLastError()
{
return DBCommon.ErrorMessage;
} public static bool ExecSql(string sql)
{
try
{
OracleConnection con=DBCommon.GetConnection();
OracleCommand cmd=new OracleCommand(sql,con);
if(con.State!=ConnectionState.Open) con.Open();
cmd.ExecuteNonQuery();
con.Close();
return true;
}
catch(Exception e)
{
DBCommon.ErrorMessage=e.Message;
// DBCommon.ErrorMessage=sql;
return false;
}
} public static DataSet ExecSqlDS(string sql)
{
try
{
OracleConnection con=DBCommon.GetConnection();
//OracleCommand cmd=new OracleCommand(sql,con);
OracleDataAdapter da=new OracleDataAdapter(sql,con);
DataSet ds=new DataSet();
con.Open();
da.Fill(ds);
con.Close();
return ds;
}
catch(Exception e)
{
DBCommon.ErrorMessage=e.Message;
return null;
}
}