1,178
社区成员
发帖
与我相关
我的任务
分享
public SqlConnection GetConnection()
{
string strConn = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection myCon = new SqlConnection(strConn);
return myCon;
}
/// <summary>
///返回所有相应的dataset
public DataSet TractAcceptDocsDataSet(string Accepid, string CROLE, string UserName)
{
SqlConnection myCon = GetConnection();
SqlCommand myCmd = new SqlCommand("P_GetDocs", myCon);
myCmd.CommandType = CommandType.StoredProcedure;
//添加参数
SqlParameter acceptid = new SqlParameter("@acceptid", SqlDbType.VarChar, 50);
acceptid.Value = Accepid;
myCmd.Parameters.Add(acceptid);
//执行过程
myCon.Open();
try
{
myCmd.ExecuteNonQuery();
}
catch
{
myCmd.Dispose();
myCon.Close();
}
SqlDataAdapter da = new SqlDataAdapter(myCmd);
DataSet ds = new DataSet();
da.Fill(ds, "P_GetDocs");
return ds;
}