以下为实例调用过程:::::
#region 获取存储过程参数列表
/// <summary>/// 获取存储过程参数列表
/// </summary>
/// <param name="storePName">存储过程名称</param>
/// <returns></returns>
public static DataTable GetStoreParasm(string storePName)
{
string sql = " select a.name from syscolumns a left join sysobjects b on a.id = b.id where left(a.name,1) = '@' and b.name='"+storePName+"'";
SqlCommand cmd = new SqlCommand(sql, new SqlConnection(connect.connstr));
cmd.Connection.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds.Tables[0];
}
#endregion
。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
//加载字段到checkboxlist
DataTable dtStoreParas = DataOp.GetStoreParasm(e.Node.Name); //调用
for (int m = 0; m < dtStoreParas.Rows.Count; m++)
{
chklColumn.Items.Add(dtStoreParas.Rows[m]["name"].ToString(), true);
}