ado一部分程序.doc

using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace ADODemo2 { public class SQLHelper { /// summary /// 用来获取连接字符串 /// /summary public string MyConstr { get { //return Data Source=PC201301221117;Initial Catalog=ADODB; User ID=sa;Pwd=sasa; return System.Configuration.ConfigurationManager.ConnectionStrings[MyconnString].ConnectionString.ToString(); } } /// summary /// 创建于数据库连接。 /// /summary /// returns连接的状态/returns public string CreateSQLConnection() { SqlConnection myCon = new SqlConnection(MyConstr); myCon.Open(); string s = myCon.State.ToString(); return s; } /// summary /// 基于sql命令的数据库操作 /// /summary /// param name=sql insert delete update /param /// returns执行结构int/returns public int ExecuteSQLReturnInt(string sql) { SqlConnection con1 = new SqlConnection(MyConstr); //打开连接状态。 try { if (con1.State == ConnectionState.Closed || con1.State == ConnectionState.Broken) { con1.Open(); } //SqlCommand cmd = new SqlCommand(); //cmd.Connection = con1; //cmd.CommandText = sql; SqlCommand cmd = new SqlCommand(sql, con1); int i = cmd.ExecuteNonQuery(); return i; } catch { return 0; } finally { con1.Close(); } } /// summary /// 基于带参数的sql命令的数据库操作。 /// /summary /// param name=sqlsql 命令/param /// param name=pars参数数组/param /// returns执行后的结构 int/returns