Aps.net c#基础技能日志

最新推荐文章于 2024-10-10 12:01:53 发布

rocktears

最新推荐文章于 2024-10-10 12:01:53 发布

阅读量432

点赞数

文章标签： c# string dataset 数据库 class

本文链接：https://blog.csdn.net/rocktears/article/details/2839177

版权

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();

        }
    }