Aps.net c#基础技能日志

来源：互联网发布：淘宝运营处理什么意思编辑：程序博客网时间：2024/06/06 16:32

C#中最基础的莫过于连接数据库及数据的读取记录数据连接

public class SqlConnect
    {
        //产生string类型的数据
        public static string ExecuteToString(string SqlStr)
        {
            string Str="";
            SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
            SqlCommand myCommand = new SqlCommand(SqlStr, myConnection);
            myConnection.Open();
            Str=Convert.ToString(myCommand.ExecuteScalar());
            myConnection.Close();
            return Str;
        }
        //产生DataView类型的数据
        public static DataView ExecuteToDataView(string SqlStr)
        {
            SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
            SqlDataAdapter myCommand = new SqlDataAdapter(SqlStr, myConnection);
            myConnection.Open();
            DataSet ds = new DataSet();
            myCommand.Fill(ds, "*");
            DataView Dv = ds.Tables["*"].DefaultView;
            myConnection.Close();
            return Dv;

        }
        //产生Int类型的数据
        public static int ExecuteToInt(string SqlStr)
        {
            int Str;
            SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
            SqlCommand myCommand = new SqlCommand(SqlStr, myConnection);
            myConnection.Open();
            Str = Convert.ToInt32(myCommand.ExecuteScalar());
            myConnection.Close();
            return Str;
        }
        //操作不产生数据
        public static void ExecuteNonQuery(string SqlStr)
        {
            int Str;
            SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString());
            SqlCommand myCommand = new SqlCommand(SqlStr, myConnection);
            myConnection.Open();
            Str = Convert.ToInt32(myCommand.ExecuteNonQuery());
            myConnection.Close();

        }
    }