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; }
相关资源:一个递归调用的存储过程