操作sqlserver数据库方法
using System; using System.Data; using System.Data.SqlClient; using System.Collections.Generic; using System.Text; using Microsoft.ApplicationBlocks.Data; //sqlhelper类
namespace LED.Data {
///
/// </summary>
public class test
{
public void MemberInfoBatchSh(int mem_id) {
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = mem_id;
SqlHelper.ExecuteNonQuery(DBconnection, CommandType.StoredProcedure, "存储过程名称", parameters);}
}
}