摘要：/// <summary> /// count(*)计算 ExecuteScalar /// </summary> /// <returns></returns> public static int sqlScalar() { int a = 0; string conString = "data source=.;database=Codematic;user=sa;password=123"; SqlConnection myConnection = new SqlConnection(conString); string 阅读全文

摘要：/// <summary> /// 事件 SqlTransaction /// </summary> /// <returns></returns> public static int sqlTran() { int i=0; string conString = "data source=.;database=Codematic;user=sa;password=123"; SqlConnection myConnection = new SqlConnection(conString); string strSql1 = 阅读全文

摘要：/// <summary> /// 执行带参数的sql语句。 /// </summary> /// <param name="i"></param> public static void Parameter(int i) { string conString = "data source=.;Database=Codematic;user id=sa;password=123"; SqlConnection myConnection = new SqlConnection(conString); strin 阅读全文

摘要：/// <summary> /// 执行存储过程 /// </summary> /// <param name="i"></param> public static void ParameterSQL(int i) { string conString = "data source=.;Database=Codematic;user id=sa;password=123"; SqlConnection myConnection = new SqlConnection(conString); string s 阅读全文

摘要：/// <summary> /// 执行sql语句 ExecuteNonQuery /// </summary> /// <returns></returns> public static int sql() { string conString = "data source=.;Database=Codematic;user id=sa;password=123"; SqlConnection myConnection = new SqlConnection(conString); string strSql = " 阅读全文