SQLHelper公共类,最好标准版
View Code
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Data; public class SQlHelper { public static string connecting ="Data Source= ;User ID= ;PWD= ;Initial Catalog= ";////将自己的数据库填好 public static int ExcuteNonQuery(string cmdText,params SqlParameter [] parameter) { using (SqlConnection conn = new SqlConnection(connecting)) { conn.Open(); using (SqlCommand cmd=conn.CreateCommand ()) { cmd.CommandText = cmdText; cmd.Parameters.AddRange(parameter ); return cmd.ExecuteNonQuery(); } } } public static DataTable ExcuteDataTable(string cmdText,params SqlParameter [] parameters) { using (SqlConnection conn = new SqlConnection(connecting)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = cmdText; cmd.Parameters.AddRange(parameters ); using (SqlDataAdapter adapter = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); adapter.Fill(dt); return dt; } } } } }
目前我所使用的发现就这两个就可以都用了,等再有了新的添加 ,我会继续给加上的。