执行一个存储过程的方法

xiaoxiao2026-08-19  27

 

 public DataSet CreateDataSet(string sqlString)        {            SqlConnection con = CreateConnection();            SqlDataAdapter sdp = new SqlDataAdapter();            sdp.SelectCommand = new SqlCommand();            sdp.SelectCommand.Connection = con;            sdp.SelectCommand.CommandType = CommandType.StoredProcedure;            sdp.SelectCommand.CommandText = "Pr_RunSql";            sdp.SelectCommand.Parameters.Add("@sql", sqlString);            con.Open();            DataSet ds = new DataSet();            sdp.Fill(ds);            con.Close();            return ds;        }

相关资源:一个递归调用的存储过程
转载请注明原文地址: https://www.6miu.com/read-5051486.html

最新回复(0)