ADO.net 的操作

//执行sql返回结果。

static  string connstr =“server=.; databass= 数据库名, uid =sa, pwd =sasa”;

SqlConnection conn = new sqlconnecton (connstr ); 

conn.open();

SqlCommand  c0m =new sqlcommand(sql语句.conn);

int  re = com。ExecuteNonQuery（）；

conn。close（）；

-----------------------------------

//获取datatable

Sqlconnection conn= new sqlconnection(connstr);

sqlconn.gpen();

SqlDataAdapter sda = new sqldataadapter (sql ,conn);

DataSet ds= new DataSet ();

sda.fill(ds);

conn.close();

return ds.tables[0];

---------------------------------------------------------------------

  /// <summary>
        /// 接收一个sql语句返回第一行第一列的值
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static string getonce(string sql)
        {
            SqlConnection conn = GetConnection();
            SqlCommand com = new SqlCommand(sql,conn);
            
            string w =Convert.ToString(com.ExecuteScalar());
            conn.Close();
            return w;
      
        }

--------------------事物的处理-----------------------------------------------------------------

       protected void Button1_Click(object sender, EventArgs e)
        {
            
            con = new SqlConnection(conn);
            con.Open();
            //启动一个事务。
            SqlTransaction myTran = con.BeginTransaction();

            SqlCommand myCom = new SqlCommand();
            myCom.Connection = con;
            myCom.Transaction = myTran;
            try
            {
                myCom.CommandText = "insert into fenye(value) values('zz')";//这条没有插入数据库
                myCom.ExecuteNonQuery();
                myCom.CommandText = "insert into fenye2(value) values('zz2')";
                myCom.ExecuteNonQuery();
                myTran.Commit();
                Response.Write("成功执行！1");
            }
            catch (Exception Ex)
            {
                myTran.Rollback();
                //创建并且返回异常的错误信息
                Response.Write(Ex.ToString());
                Response.Write("写入数据库失败");
            }
            finally
            {
                con.Close();
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            using (TransactionScope tsCope = new TransactionScope())
            {
                using (con = new SqlConnection(conn))
                {
                    SqlCommand cmd = new SqlCommand("insert into fenye(value) values('zz')", con);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
                using (con = new SqlConnection(conn))
                {
                    SqlCommand cmd = new SqlCommand("insert into fenye2(value) values('zz2')", con);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
                Response.Write("执行成功！2");
                tsCope.Complete();
            }
        }
    }
}

----........................................................................

        //执行sql返回结果。
        /// <summary>
        /// 连接字符串
        /// </summary>
        static string connstr = "server=192.168.3.77;database=STTX_CHUN_TEXT; uid =sa; pwd =123";

        /// <summary>
        /// 获取数据库表
        /// </summary>
        /// <param name="strSql">一条sql的语句</param>
        /// <returns></returns>
        public static DataTable GetDataTable(string strSql)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlDataAdapter sda = new SqlDataAdapter(strSql, conn))
                {
                    using (DataSet ds = new DataSet())
                    {
                        sda.Fill(ds);
                        return ds.Tables[0];
                    }
                }
            }
        }

        /// <summary>
        /// 执行一条sql一句返回受影响的行数
        /// </summary>
        /// <param name="strSql">sql</param>
        /// <returns></returns>
        public static int GetExecuteNonQuery(string strSql)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlCommand com = new SqlCommand(strSql, conn))
                {
                    return com.ExecuteNonQuery();
                }
            }
        }

        /// <summary>
        /// 获取查询到的第一行第一列的数据
        /// </summary>
        /// <param name="strSql"></param>
        /// <returns></returns>
        public static string Getvalue(string strSql)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlCommand com = new SqlCommand(strSql, conn))
                {
                    return com.ExecuteScalar().ToString();
                }
            }
        }

        /// <summary>
        /// 进行数据库事务的操作
        /// </summary>
        /// <param name="strArray">一个sql语句的数组</param>
        /// <returns></returns>
        public static int EXQ_BeginTransaction(string[] strArray)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlCommand com = new SqlCommand())
                {
                    //开启事务
                    SqlTransaction myTran = conn.BeginTransaction();
                    com.Connection = conn;
                    com.Transaction = myTran;
                    try
                    {
                        //循环执行数据库
                        for (int i = 0; i < strArray.Length; i++)
                        {
                            com.CommandText = strArray[i];
                            com.ExecuteNonQuery();
                        }
                        myTran.Commit();//提交事务
                        return 1;
                    }
                    catch (Exception e)
                    {
                        myTran.Rollback();//回滚事务
                        return 0;
                    }
                }
            }
        }

-------------------------------------------------------

   //数据的链接语句
       // static  string connstr ="server=.; databass= 数据库名, uid =sa, pwd =123456";

        static string connstr = ConfigurationSettings.AppSettings["connectionstring"];

  <appSettings>
    <add key="connectionstring" value="server=.;Database=Mark; uid =sa; pwd =123"/>

 </appSettings>

  public static void Write(Exception strException)
        {
            string path = @"d:\my.txt";
            using (FileStream fs = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write))
            {
                using (StreamWriter sw = new StreamWriter(fs))
                {
                    sw.WriteLine("---"+DateTime .Now+"-----");
                    sw.WriteLine( strException);
                }
            }

        }

-----------------------------------

执行存储过程