public class SqlHelper
...{
ExecuteNonQuery的两个重载#region ExecuteNonQuery的两个重载
public static int ExecuteNonQuery(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
conn.Open();
int rowNum = comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();
return rowNum;
}
public static int ExecuteNonQuery(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
for (int i = 0; i < commandParameters.Length; i++)
comm.Parameters.Add(commandParameters[i]);
conn.Open();
int rowNum = comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();
return rowNum;
}
#endregion
ExecuteScalar的两个重载#region ExecuteScalar的两个重载
public static object ExecuteScalar(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
conn.Open();
object firstObj = comm.ExecuteScalar();
comm.Dispose();
conn.Close();
return firstObj;
}
public static object ExecuteScalar(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
for (int i = 0; i < commandParameters.Length; i++)
comm.Parameters.Add(commandParameters[i]);
conn.Open();
object firstObj = comm.ExecuteScalar();
comm.Dispose();
conn.Close();
return firstObj;
}
#endregion
ExecuteReader的两个重载#region ExecuteReader的两个重载
public static SqlDataReader ExecuteReader(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
conn.Open();
SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);
return reader;
}
public static SqlDataReader ExecuteReader(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
for (int i = 0; i < commandParameters.Length; i++)
comm.Parameters.Add(commandParameters[i]);
conn.Open();
SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);
return reader;
}
#endregion
SqlDataSetAdapter的两个重载#region SqlDataSetAdapter的两个重载
public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
for (int i = 0; i < commandParameters.Length; i++)
comm.Parameters.Add(commandParameters[i]);
SqlDataAdapter sda = new SqlDataAdapter(comm);
DataSet ds = new DataSet();
sda.Fill(ds);
return ds;
}
public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;
SqlDataAdapter sda = new SqlDataAdapter(comm);
DataSet ds = new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
}
<script type="text/JavaScript"> var yahoo_pid="un_23652_769_19_287"; var yahoo_bordercolor="ffffff"; var yahoo_titlecolor="e20106"; var yahoo_descolor="000000"; var yahoo_linkcolor="006600"; var yahoo_titlebgcolor="FFFFFF"; var yahoo_desbgcolor="FFFFFF"; var yahoo_width=600; var yahoo_height=60; var yahoo_isbanner=1; var yahoo_displink=1; var yahoo_adsnum=3; var yahoo_simple=0; var yahoo_iniframe=1; </script> <script src="http://cm.p4p.cn.yahoo.com/inf.js" type="text/javascript"></script>