/// <summary>
/// 执行数据库查询操作,返回DataSet类型的结果集
/// </summary>
/// <param name="connectionString">数据库连接字符串</param>
/// <param name="cmdType">命令的类型</param>
/// <param name="cmdText">SqlServer存储过程名称或PL/SQL命令</param>
/// <param name="cmdParms">命令参数集合</param>
/// <returns>当前查询操作返回的DataSet类型的结果集</returns>
public static DataSet ExecuteDataSet(CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)
{
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString);
DataSet ds = null;
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
ds = new DataSet();
adapter.Fill(ds);
cmd.Parameters.Clear();
}
catch
{
throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
return ds;
}
var id=5;
string selectChild = string.Format("select * from V_U8WW_Child where moid='{0}'", id);
DataSet dataSet = SqlHelper.ExecuteDataSet(CommandType.Text, selectChild);
//子表
List<object> jsonlist = new List<object>();
foreach (DataRow item in dataSet.Tables[0].Rows)
{
Dictionary<string, string> zibiao = new Dictionary<string, string>();
string chbm = item["cInvCode"].ToString();//存货编码
zibiao.Add("chbm", "测试编码123");
}
string s = JsonConvert.SerializeObject(zibiao);//转成json字符串
C# Dictionary转字符串及dataSet循环取值
最新推荐文章于 2024-09-06 09:50:42 发布