public string GetDataSetWithParam(DBInfo dbinfo, string cmdText, string[] paraNames, object[] paraValues) { var ds = CreateDB(dbinfo).GetDataSet(cmdText, paraNames, paraValues); var newds = new Data.DataSet(ds); return(newds.ToString()); }
/// <summary> /// XML转DATASET /// </summary> /// <param name="xml">xml</param> /// <returns>DATASET</returns> public static Data.DataSet FromXML(string xml) { StringReader stream = null; XmlTextReader reader = null; try { Data.DataSet xmlDS = new Data.DataSet(); stream = new StringReader(xml); reader = new XmlTextReader(stream); xmlDS.ReadXml(reader); return(xmlDS); } catch (Exception ex) { throw ex; } finally { if (reader != null) { reader.Close(); } } }
public string GetDataSet(DBInfo dbinfo, string cmdText) { var ds = CreateDB(dbinfo).GetDataSet(cmdText); var newds = new Data.DataSet(ds); return(newds.ToString()); }
/// <summary> /// JSON转DataSet /// </summary> /// <param name="Json">JSON串</param> /// <returns>DataSet</returns> public static Data.DataSet JsonToDataSet(string Json) { try { Data.DataSet ds = new Data.DataSet(); JavaScriptSerializer JSS = new JavaScriptSerializer(); object obj = JSS.DeserializeObject(Json); Dictionary <string, object> datajson = (Dictionary <string, object>)obj; foreach (var item in datajson) { Data.DataTable dt = new Data.DataTable(item.Key); object[] rows = (object[])item.Value; foreach (var row in rows) { Dictionary <string, object> val = (Dictionary <string, object>)row; Data.DataRow dr = dt.NewRow(); foreach (KeyValuePair <string, object> sss in val) { if (!dt.Columns.Contains(sss.Key)) { dt.Columns.Add(sss.Key.ToString()); dr[sss.Key] = sss.Value; } else { dr[sss.Key] = sss.Value; } } dt.Rows.Add(dr); } ds.Tables.Add(dt); } return(ds); } catch { return(null); } }
public static async Task <Statuses> InsertDataAsync(this IHistoryApi api, GoogleApiClient client, Data.DataSet dataSet) { return((await api.InsertData(client, dataSet)).JavaCast <Statuses> ()); }