我对这个类不是很满意,如果你有改进意见请联系我,不胜感激.
主要将对数据库的操作简单封装了一下
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Configuration;
using System.Data.SqlClient;
namespace Addr.Admin.ExecuteSqlCommand
{
?///
????switch(type)
????{
?????case cmdType.ExecuteNonQuery:
??????try
??????{
???????cm.ExecuteNonQuery();
???????cn.Close();
??????}
??????catch(Exception ex)
??????{
???????errorMessage="Error executing 'ExecuteNonQuery'."+ex.Message;
???????successful=false;
??????}
??????break;
?????case cmdType.ExecuteReader:
??????try
??????{
???????SqlDataAdapter da=new SqlDataAdapter(cm.CommandText,cn);
???????DataSet ds=new DataSet();
???????da.Fill(ds,"First");
???????da.Dispose();
???????cn.Close();
???????return ds.Tables["First"];
??????}
??????catch
??????{
???????errorMessage="Error executing 'ExecuteReader'.";
???????successful=false;
??????}
??????break;
?????case cmdType.ExecuteScalar:
??????try
??????{
???????int result=(int)cm.ExecuteScalar();
???????cn.Close();
???????return result;
??????}
??????catch
??????{
???????errorMessage="Error executing 'ExecuteScalar'.'";
???????successful=false;
??????}
??????break;
?????case cmdType.ExecuteDataSet:
??????try
??????{
???????SqlDataAdapter da=new SqlDataAdapter(cm.CommandText,cn);
???????DataSet ds=new DataSet();
???????da.Fill(ds);
???????cn.Close();
???????return ds;
??????}
??????catch
??????{
???????errorMessage="Error executing 'ExecuteDataSet'.";
???????successful=false;
??????}
??????break;
?????case cmdType.ExecuteID:
??????try
??????{
???????string rst="";
???????SqlDataReader dr=cm.ExecuteReader();
???????if(dr.Read())
???????{
????????rst=dr["ID"].ToString();
???????}
???????dr.Close();
???????cn.Close();
???????return rst;
??????}
??????catch
??????{
???????errorMessage="Error executing 'ExecuteID'.";
???????successful=false;
??????}
??????break;
?????default:
??????errorMessage="Error executing unknown sqlcommand.";
??????successful=false;
??????break;
????}
????return successful;
???}
???catch
???{
????successful=false;
????errorMessage="Error opening data connection.";
????return successful;
???}
??}
?}
}
本文地址:http://com.8s8s.com/it/it44030.htm