10.17

 

今天通一上午的学习，和下午的复习，让我们学会了一些新的知识。比如：

创建实例和前几天的知识,

比如：

public class Class1
    {
                public static readonly string cnnstring = ConfigurationManager.ConnectionStrings["cnnstring"].ConnectionString;
                public static object ExecuteScalar(string sqlText, params SqlParameter[] paramss)
        {
            using (SqlConnection sqlCnn = new SqlConnection(cnnstring))
            {
                using (SqlCommand sqlCmm = sqlCnn.CreateCommand())
                {
                    sqlCmm.CommandText = sqlText;
                    fillParameter(paramss, sqlCmm);
                    sqlCnn.Open();
                    return sqlCmm.ExecuteScalar();
                }
            }
        }

                private static void fillParameter(SqlParameter[] paramss, SqlCommand sqlCmm)
        {
            foreach (SqlParameter param in paramss)
            {
                sqlCmm.Parameters.Add(param);
            }
        }
                public static DataTable ExecuteTable(string sqlText, params SqlParameter[] paramss)
        {
            using (SqlConnection sqlcnn = new SqlConnection(cnnstring))
            {
                using (SqlCommand sqlCmm = sqlcnn.CreateCommand())
                {
                    sqlCmm.CommandText = sqlText;
                    fillParameter(paramss, sqlCmm);
                    sqlcnn.Open();
                    using (SqlDataReader reader = sqlCmm.ExecuteReader())
                    {
                        DataTable dt = new DataTable();
                        dt.Load(reader);
                        return dt;
                    }
                }
            }
        }
                public static int ExecuteNonQuery(string sqlText, params SqlParameter[] paramss)
        {
            using (SqlConnection sqlCnn = new SqlConnection(cnnstring))
            {
                using (SqlCommand sqlCmm = sqlCnn.CreateCommand())
                {
                    sqlCmm.CommandText = sqlText;
                    fillParameter(paramss, sqlCmm);
                    sqlCnn.Open();
                    return sqlCmm.ExecuteNonQuery();
                }
            }
        }

        internal static int ExecuteNonQuery(string sql, SqlParameter sqlParameter)
        {
            throw new NotImplementedException();
        }
    }

可以做实例。