C# Data.DataSet类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中System.Data.DataSet类的典型用法代码示例。如果您正苦于以下问题：C# System.Data.DataSet类的具体用法？C# System.Data.DataSet怎么用？C# System.Data.DataSet使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

System.Data.DataSet类属于命名空间，在下文中一共展示了System.Data.DataSet类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: TestStreamDataSet

        private static void TestStreamDataSet()
        {
            //Create a sample DataSet
            System.Data.DataSet ds = new System.Data.DataSet();
            System.Data.DataTable table = ds.Tables.Add("Table1");
            table.Columns.Add("Col1", typeof(string));
            table.Columns.Add("Col2", typeof(double));
            table.Rows.Add("Value 1", 59.7);
            table.Rows.Add("Value 2", 59.9);

            byte[] buffer;

            //Serialize the DataSet (where ds is the dataset)
            using (System.IO.MemoryStream stream = new System.IO.MemoryStream())
            {
                DevAge.Data.StreamDataSet.Write(stream, ds, 
                            DevAge.Data.StreamDataSetFormat.Binary);

                buffer = stream.ToArray();
            }

            //Deserialize the DataSet (where 'buffer' is the previous serialized byte[])
            System.Data.DataSet deserializedDs = new System.Data.DataSet();
            using (System.IO.MemoryStream stream = new System.IO.MemoryStream(buffer))
            {
                DevAge.Data.StreamDataSet.Read(stream, deserializedDs, 
                            DevAge.Data.StreamDataSetFormat.Binary, true);
            }

            System.Diagnostics.Debug.Assert(deserializedDs.Tables[0].Rows.Count == 2);
        }

开发者ID:wsrf2009，项目名称:KnxUiEditor，代码行数:31，代码来源:GenericTest.cs

示例2: DataTableToExcel

 /// <summary>
 /// 导出Excel，以旧列名-新列名词典为标头
 /// </summary>
 /// <param name="dt"></param>
 /// <param name="dicCoumnNameMapping"></param>
 public static void DataTableToExcel(System.Data.DataTable dt, Dictionary<string, string> dicCoumnNameMapping, string fileName)
 {
     ExcelHandler eh = new ExcelHandler();
     SheetExcelForm frm = new SheetExcelForm();
     eh.ProcessHandler = frm.AddProcess;
     eh.ProcessErrorHandler = new Action<string>((msg) =>
     {
         MessageBox.Show(msg);
     });
     try
     {
         frm.Show();
         Delay(20);
         var ds = new System.Data.DataSet();
         ds.Tables.Add(dt);
         eh.DataSet2Excel(ds, dicCoumnNameMapping, fileName);
         ds.Tables.Remove(dt);
         ds.Dispose();
     }
     catch (Exception ex)
     {
         MessageBox.Show("导出Excel错误:" + ex.Message);
     }
     finally
     {
         Delay(20);
         frm.Close();
     }
 }

开发者ID:howbigbobo，项目名称:DailyCode，代码行数:34，代码来源:WinFormExcelExporter.cs

示例3: acquireData

        private void acquireData()
        {
            OdbcConnection conn = new OdbcConnection("Driver={SQL Server Native Client 11.0}; server=jfsql2014;database=d3charting;trusted_connection=yes;");
               OdbcCommand cmd = new OdbcCommand("select * from bar_chart;");

               conn.Open();
               cmd.Connection = conn;

               OdbcDataAdapter da = new OdbcDataAdapter();
               System.Data.DataSet ds = new System.Data.DataSet();
               da.SelectCommand = cmd;
               da.Fill(ds);

               JSONDocument = JsonConvert.SerializeObject(ds.Tables[0], Formatting.None);

               cmd = new OdbcCommand("select T.Product, T.[This Year] as TY, F.Forecast FROM bar_chart T JOIN forecast F ON T.Product = F.Product");
               cmd.Connection = conn;
               da = new OdbcDataAdapter();
               ds = new System.Data.DataSet();
               da.SelectCommand = cmd;
               da.Fill(ds);

               ForecastData = JsonConvert.SerializeObject(ds.Tables[0], Formatting.None);

               conn.Close();
        }

开发者ID:scardella，项目名称:d3charting，代码行数:26，代码来源:barchart.aspx.cs

示例4: TC_SetDislay

        public void TC_SetDislay(System.Data.DataSet ds)
        {
            checkConntected();

              if (ds.Tables[0].Rows[0]["func_name"].ToString() != "set_speed")
              throw new Exception("only support func_name = set_speed");

              lock (this.currDispLockObj)
              {
              if (currDisplayds == null)
              {

                  this.InvokeOutPutChangeEvent(this, ds.Tables[0].Rows[0]["speed"].ToString());
              }
              else
                  if (currDisplayds.Tables[0].Rows[0]["speed"].ToString() != ds.Tables[0].Rows[0]["speed"].ToString())

                      this.InvokeOutPutChangeEvent(this, ds.Tables[0].Rows[0]["speed"].ToString());

                      currDisplayds = ds;
              Comm.SendPackage pkg = this.m_protocol.GetSendPackage(ds, 0xffff);

              this.Send(pkg);

              }
        }

开发者ID:ufjl0683，项目名称:Center，代码行数:26，代码来源:CSLSTC.cs

示例5: LoadData

        private void LoadData()
        {
            taskDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM events WHERE ID=" + id, connection);
            alertsDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM events_alerts WHERE event_id=" + id, connection);

            dataSet = new System.Data.DataSet();

            var taskCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(taskDataAdapter);
            var alertsCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(alertsDataAdapter);

            taskDataAdapter.Fill(dataSet, "event");
            alertsDataAdapter.Fill(dataSet, "alerts");

            var parentColumn = dataSet.Tables["event"].Columns["ID"];

            {
                var childColumn = dataSet.Tables["alerts"].Columns["event_id"];
                var relation = new System.Data.DataRelation("event_alerts", parentColumn, childColumn);
                dataSet.Relations.Add(relation);
            }

            //var table = dataSet.Tables["event"];
            row = dataSet.Tables["event"].Rows[0];
            dataSet.Tables["event"].RowChanged += table_RowChanged;
            dataSet.Tables["alerts"].RowChanged += table_RowChanged;
            dataSet.Tables["alerts"].RowDeleted += table_RowDeleted;
            dataSet.Tables["alerts"].TableNewRow += table_TableNewRow;

            FillDeadline(row);
            FillTags(id);

            TaskGrid.DataContext = dataSet.Tables["event"].DefaultView;
            AlertsDataGrid.ItemsSource = dataSet.Tables["alerts"].DefaultView;
        }

开发者ID:xeph，项目名称:LOG350.TP3，代码行数:34，代码来源:Events.xaml.cs

示例6: consultaInformacion

        //Procedimiento que consulta información definida por  parámetros del
        //query, retorna un dataset con la información
        public System.Data.DataSet consultaInformacion(String queryToExecute)
        {
            String resultadoOperacion;
            System.Data.DataSet sqlDsConsulta = new System.Data.DataSet(); ;
            resultadoOperacion = "EXITOSO";
            abreConexion();
            try
            {
                //Crea las instancias
                this.sqlCmdConsulta = new SqlCommand();
                this.sqlDaConsulta = new SqlDataAdapter();

                //Construye el comando Select
                sqlCmdConsulta.Connection = cnBaseDatos;
                sqlCmdConsulta.CommandText = queryToExecute;
                sqlCmdConsulta.CommandType = System.Data.CommandType.Text;
                sqlDaConsulta.SelectCommand = sqlCmdConsulta;
                //Carga el DataSet
                this.sqlDaConsulta.Fill(sqlDsConsulta);
            }
            catch (SqlException exc)
            {

                //resultadoOperacion = "Error(" & exc.Number.ToString & "): " & exc.Messag;
            }
            return sqlDsConsulta;
        }

开发者ID:dar2608，项目名称:PrograVI，代码行数:29，代码来源:clsConexion.cs

示例7: GetParameter

    private System.Data.DataRow GetParameter(string IDParametro, int? IDPortal, int? IDSistema, string IDUsuario)
    {
      // Aca se lee la informacion de la base de datos
      // y se preparan los layers
      string connStr = ValidacionSeguridad.Instance.GetSecurityConnectionString();
      System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connStr);
      conn.Open();

      System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand
        ("SELECT * FROM dbo.SF_VALOR_PARAMETRO(@IDParametro, @IDPortal, @IDSistema, @IDUsuario)", conn);

      System.Data.SqlClient.SqlParameter prm = new System.Data.SqlClient.SqlParameter("@IDParametro", System.Data.SqlDbType.VarChar, 100);
      prm.Value = IDParametro;
      cmd.Parameters.Add(prm);

      prm = new System.Data.SqlClient.SqlParameter("@IDPortal", System.Data.SqlDbType.Int);
      if (IDPortal.HasValue)
      {
        prm.Value = IDPortal.Value;
      }
      else
      {
        prm.Value = null;
      }
      cmd.Parameters.Add(prm);

      prm = new System.Data.SqlClient.SqlParameter("@IDSistema", System.Data.SqlDbType.Int);
      if (IDSistema.HasValue)
      {
        prm.Value = IDSistema.Value;
      }
      else
      {
        prm.Value = null;
      }
      cmd.Parameters.Add(prm);

      prm = new System.Data.SqlClient.SqlParameter("@IDUsuario", System.Data.SqlDbType.VarChar);
      if (IDUsuario != null)
      {
        prm.Value = IDUsuario;
      }
      else
      {
        prm.Value = null;
      }
      cmd.Parameters.Add(prm);

      //     IdParametro, Alcance, ValorTexto, ValorEntero, ValorDecimal, ValorLogico, ValorFechaHora
      cmd.CommandType = System.Data.CommandType.Text;
      System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);

      System.Data.DataSet ds = new System.Data.DataSet();
      da.Fill(ds);

      conn.Close();

      return ds.Tables[0].Rows[0];
      //return resultado;
    }

开发者ID:diegowald，项目名称:intellitrack，代码行数:60，代码来源:UDPHandler.cs

示例8: Process

		internal static void Process (List<string> assemblies, string outputPath)
		{
			List<string> valid_config_files = new List<string> ();
			foreach (string assembly in assemblies) {
				string assemblyConfig = assembly + ".config";
				if (File.Exists (assemblyConfig)) {
					XmlDocument doc = new XmlDocument ();
					try {
						doc.Load (assemblyConfig);
					} catch (XmlException) {
						doc = null;
					}
					if (doc != null)
						valid_config_files.Add (assemblyConfig);
				}
			}
			
			if (valid_config_files.Count == 0)
				return;

			string first_file = valid_config_files [0];
			System.Data.DataSet dataset = new System.Data.DataSet ();
			dataset.ReadXml (first_file);
			valid_config_files.Remove (first_file);
			
			foreach (string config_file in valid_config_files) {
				System.Data.DataSet next_dataset = new System.Data.DataSet ();
				next_dataset.ReadXml (config_file);
				dataset.Merge (next_dataset);
			}
			dataset.WriteXml (outputPath + ".config");
		}

开发者ID:transformersprimeabcxyz，项目名称:cecil-old，代码行数:32，代码来源:ConfigMerger.cs

示例9: EmployeeDataSet

 protected EmployeeDataSet(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) : 
         base(info, context, false) {
     if ((this.IsBinarySerialized(info, context) == true)) {
         this.InitVars(false);
         System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
         this.Tables.CollectionChanged += schemaChangedHandler1;
         this.Relations.CollectionChanged += schemaChangedHandler1;
         return;
     }
     string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
     if ((this.DetermineSchemaSerializationMode(info, context) == System.Data.SchemaSerializationMode.IncludeSchema)) {
         System.Data.DataSet ds = new System.Data.DataSet();
         ds.ReadXmlSchema(new System.Xml.XmlTextReader(new System.IO.StringReader(strSchema)));
         if ((ds.Tables["employee"] != null)) {
             base.Tables.Add(new employeeDataTable(ds.Tables["employee"]));
         }
         this.DataSetName = ds.DataSetName;
         this.Prefix = ds.Prefix;
         this.Namespace = ds.Namespace;
         this.Locale = ds.Locale;
         this.CaseSensitive = ds.CaseSensitive;
         this.EnforceConstraints = ds.EnforceConstraints;
         this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
         this.InitVars();
     }
     else {
         this.ReadXmlSchema(new System.Xml.XmlTextReader(new System.IO.StringReader(strSchema)));
     }
     this.GetSerializationData(info, context);
     System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
     base.Tables.CollectionChanged += schemaChangedHandler;
     this.Relations.CollectionChanged += schemaChangedHandler;
 }

开发者ID:antklim，项目名称:consumables，代码行数:33，代码来源:EmployeeDataSet.Designer.cs

示例10: listar

        public List<Combustivel> listar()
        {
            List<Combustivel> lista = new List<Combustivel>();
            System.Data.DataSet ds = new System.Data.DataSet();
            Int32 x = 0;

            try
            {
                SqlDataReader reader;
                command.Connection = MsSQL.getConexao();
                command.Connection.Open();
                vsql.Append("SELECT ID, DESCRICAO FROM COMBUSTIVEL ");
                vsql.Append("ORDER BY DESCRICAO ");
                command.CommandText = vsql.ToString();
                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    lista.Add(new Combustivel());
                    lista[x].ID = Convert.ToInt32(reader["ID"]);
                    lista[x].Descricao = reader["DESCRICAO"].ToString();
                    x++;
                }
                return lista;
            }
            catch (Exception e)
            {
                throw new Exception("Erro ao montar a lista de Tipo de combustível. " + e.Message);
            }
            finally
            {
                command.Connection.Close();
            }
        }

开发者ID:chmcorbo，项目名称:App.NET，代码行数:33，代码来源:DAOCombustivel.cs

示例11: GetDataBySql

 public static System.Data.DataTable GetDataBySql(string sql)
 {
     SqlConnection con = new SqlConnection(StrCon); con.Open();
     SqlDataAdapter da = new SqlDataAdapter(sql, StrCon); System.Data.DataSet ds = new System.Data.DataSet();
     da.Fill(ds); con.Dispose(); con.Close();
     return ds.Tables[0];
 }

开发者ID:mrk29vn，项目名称:vna-accounting，代码行数:7，代码来源:Connection.cs

示例12: GetAllRecordsFromXML

 public void GetAllRecordsFromXML()
 {
     System.Data.DataSet ds = new System.Data.DataSet();
     ds.ReadXml(Server.MapPath("Login.xml"));
     GridView1.DataSource = ds;
     GridView1.DataBind();
 }

开发者ID:pkgod7，项目名称:windowsphone-sprmalaysia，代码行数:7，代码来源:Login.aspx.cs

示例13: SelectFromXLS

        /// <summary>
        /// 执行查询
        /// </summary>
        /// <param name="ServerFileName">xls文件路径</param>
        /// <param name="SelectSQL">查询SQL语句</param>
        /// <returns>DataSet</returns>
        public static System.Data.DataSet SelectFromXLS(string ServerFileName, string SelectSQL)
        {

            string connStr = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + ServerFileName + "';Extended Properties=Excel 8.0";
            OleDbConnection conn = new OleDbConnection(connStr);
            OleDbDataAdapter da = null;
            System.Data.DataSet ds = new System.Data.DataSet();
            try
            {
                conn.Open();
                da = new OleDbDataAdapter(SelectSQL, conn);
                da.Fill(ds, "SelectResult");
            }
            catch (Exception e)
            {
                conn.Close();
                throw e;
            }
            finally
            {
                conn.Close();
            }
            return ds;

        }

开发者ID:HP-Richard，项目名称:https---github.com-litianbao-GoldenCat，代码行数:31，代码来源:Util_XLS.cs

示例14: TC_SetDislay

        public void TC_SetDislay(System.Data.DataSet ds)
        {
            checkConntected();

              string oldDispStr = "";
              if (ds.Tables[0].Rows[0]["func_name"].ToString() != "set_ctl_sign")
              throw new Exception("only support func_name = set_ctl_sign");

              if (this.currDisplayds == null )

              {
              lock (currDispLockObj)
              currDisplayds = ds;

              Comm.SendPackage pkg = this.m_protocol.GetSendPackage(ds, 0xffff);
              this.Send(pkg);

             this.InvokeOutPutChangeEvent(this, this.GetCurrentDisplayDecs());
              return;
              }
              else
             oldDispStr = this.GetCurrentDisplayDecs();

              lock(currDispLockObj)
              currDisplayds = ds;
              if (oldDispStr != this.GetCurrentDisplayDecs())
              {
              Comm.SendPackage pkg = this.m_protocol.GetSendPackage(ds, 0xffff);
              this.Send(pkg);
              this.InvokeOutPutChangeEvent(this, this.GetCurrentDisplayDecs());
              }
        }

开发者ID:ufjl0683，项目名称:Center，代码行数:32，代码来源:LCSTC.cs

示例15: Demonstrate

        public static void Demonstrate()
        {
            var myInt = 100;
            myInt.DisplayDefiningAssembly();

            var ds = new System.Data.DataSet();
            ds.DisplayDefiningAssembly();
        }

开发者ID:eswise，项目名称:Training，代码行数:8，代码来源:04_ExtensionMethods.cs

示例16: FullDataSet

 protected FullDataSet(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) : 
         base(info, context, false) {
     if ((this.IsBinarySerialized(info, context) == true)) {
         this.InitVars(false);
         System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
         this.Tables.CollectionChanged += schemaChangedHandler1;
         this.Relations.CollectionChanged += schemaChangedHandler1;
         return;
     }
     string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
     if ((this.DetermineSchemaSerializationMode(info, context) == System.Data.SchemaSerializationMode.IncludeSchema)) {
         System.Data.DataSet ds = new System.Data.DataSet();
         ds.ReadXmlSchema(new System.Xml.XmlTextReader(new System.IO.StringReader(strSchema)));
         if ((ds.Tables["Product"] != null)) {
             base.Tables.Add(new ProductDataTable(ds.Tables["Product"]));
         }
         if ((ds.Tables["Country"] != null)) {
             base.Tables.Add(new CountryDataTable(ds.Tables["Country"]));
         }
         if ((ds.Tables["FarmGroup"] != null)) {
             base.Tables.Add(new FarmGroupDataTable(ds.Tables["FarmGroup"]));
         }
         if ((ds.Tables["FarmGroupLevel2"] != null)) {
             base.Tables.Add(new FarmGroupLevel2DataTable(ds.Tables["FarmGroupLevel2"]));
         }
         if ((ds.Tables["Manufacturer"] != null)) {
             base.Tables.Add(new ManufacturerDataTable(ds.Tables["Manufacturer"]));
         }
         if ((ds.Tables["Packing"] != null)) {
             base.Tables.Add(new PackingDataTable(ds.Tables["Packing"]));
         }
         if ((ds.Tables["StorageCondition"] != null)) {
             base.Tables.Add(new StorageConditionDataTable(ds.Tables["StorageCondition"]));
         }
         if ((ds.Tables["Unit"] != null)) {
             base.Tables.Add(new UnitDataTable(ds.Tables["Unit"]));
         }
         if ((ds.Tables["Substance"] != null)) {
             base.Tables.Add(new SubstanceDataTable(ds.Tables["Substance"]));
         }
         this.DataSetName = ds.DataSetName;
         this.Prefix = ds.Prefix;
         this.Namespace = ds.Namespace;
         this.Locale = ds.Locale;
         this.CaseSensitive = ds.CaseSensitive;
         this.EnforceConstraints = ds.EnforceConstraints;
         this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
         this.InitVars();
     }
     else {
         this.ReadXmlSchema(new System.Xml.XmlTextReader(new System.IO.StringReader(strSchema)));
         this.InitExpressions();
     }
     this.GetSerializationData(info, context);
     System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
     base.Tables.CollectionChanged += schemaChangedHandler;
     this.Relations.CollectionChanged += schemaChangedHandler;
 }

开发者ID:vpjulia，项目名称:Salvia，代码行数:58，代码来源:FullDataSet.Designer.cs

示例17: GetDataTable

 public static System.Data.DataTable GetDataTable(string sql, System.Data.SqlClient.SqlConnection conn)
 {
     System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(sql, conn);
     adp.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey;
     System.Data.DataSet ds = new System.Data.DataSet();
     adp.Fill(ds);
     System.Data.DataTable tbl = ds.Tables[0];
     return tbl;
 }

开发者ID:viticm，项目名称:pap2，代码行数:9，代码来源:Helper.cs

示例18: NorthwindDataSet

 protected NorthwindDataSet(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) : 
         base(info, context) {
     if ((this.IsBinarySerialized(info, context) == true)) {
         this.InitVars(false);
         System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
         this.Tables.CollectionChanged += schemaChangedHandler1;
         this.Relations.CollectionChanged += schemaChangedHandler1;
         return;
     }
     string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
     if ((strSchema != null)) {
         System.Data.DataSet ds = new System.Data.DataSet();
         ds.ReadXmlSchema(new System.Xml.XmlTextReader(new System.IO.StringReader(strSchema)));
         if ((ds.Tables["Products"] != null)) {
             base.Tables.Add(new ProductsDataTable(ds.Tables["Products"]));
         }
         if ((ds.Tables["Orders"] != null)) {
             base.Tables.Add(new OrdersDataTable(ds.Tables["Orders"]));
         }
         if ((ds.Tables["Suppliers"] != null)) {
             base.Tables.Add(new SuppliersDataTable(ds.Tables["Suppliers"]));
         }
         if ((ds.Tables["Shippers"] != null)) {
             base.Tables.Add(new ShippersDataTable(ds.Tables["Shippers"]));
         }
         if ((ds.Tables["Customers"] != null)) {
             base.Tables.Add(new CustomersDataTable(ds.Tables["Customers"]));
         }
         if ((ds.Tables["Categories"] != null)) {
             base.Tables.Add(new CategoriesDataTable(ds.Tables["Categories"]));
         }
         if ((ds.Tables["Order Details"] != null)) {
             base.Tables.Add(new Order_DetailsDataTable(ds.Tables["Order Details"]));
         }
         if ((ds.Tables["Employees"] != null)) {
             base.Tables.Add(new EmployeesDataTable(ds.Tables["Employees"]));
         }
         this.DataSetName = ds.DataSetName;
         this.Prefix = ds.Prefix;
         this.Namespace = ds.Namespace;
         this.Locale = ds.Locale;
         this.CaseSensitive = ds.CaseSensitive;
         this.EnforceConstraints = ds.EnforceConstraints;
         this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
         this.InitVars();
     }
     else {
         this.BeginInit();
         this.InitClass();
         this.EndInit();
     }
     this.GetSerializationData(info, context);
     System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
     base.Tables.CollectionChanged += schemaChangedHandler;
     this.Relations.CollectionChanged += schemaChangedHandler;
 }

开发者ID:BackupTheBerlios，项目名称:mbunit-svn，代码行数:56，代码来源:NorthwindDataSet.Designer.cs

示例19: MyDataSet

 private System.Data.DataSet MyDataSet()
 {
     System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(str_con);
     con.Open();
     da_1 = new System.Data.SqlClient.SqlDataAdapter(SQL_string, con);
     System.Data.DataSet data_set = new System.Data.DataSet();
     da_1.Fill(data_set, "Test");
     con.Close();
     return data_set;
 }

开发者ID:AmirjohnSanhinov，项目名称:StarKampf，代码行数:10，代码来源:DBCon.cs

示例20: GetBatchData

        private string GetBatchData()
        {
            var assembly = System.Reflection.Assembly.GetExecutingAssembly();
            string resourceName = "Processors.BBPS.CreditCard.Data.BatchData.xml";

            using (System.IO.Stream strm = assembly.GetManifestResourceStream(resourceName))
            {

                System.Data.DataSet orginalBatch = new System.Data.DataSet();
                System.Data.DataSet refund = new System.Data.DataSet();

                refund.Tables.Add(new System.Data.DataTable());

                var x = orginalBatch.ReadXml(strm);

                var dr = orginalBatch.Tables[0].CreateDataReader();
                refund.Tables[0].Columns.Add(new System.Data.DataColumn("transactionid"));
                refund.Tables[0].Columns.Add(new System.Data.DataColumn("referenceTransactionid"));
                refund.Tables[0].Columns.Add(new System.Data.DataColumn("amount"));

                while (dr.Read())
                {
                    var drow = refund.Tables[0].NewRow();
                    string refTrxId, amount;

                    refTrxId = dr.GetString(0);
                    amount = dr.GetString(6);

                    drow.ItemArray = new String[] { Guid.NewGuid().ToString(), refTrxId, amount };

                    refund.Tables[0].Rows.Add(drow);

                }

                using (System.IO.StringWriter sw = new System.IO.StringWriter(new System.Text.StringBuilder()))
                {
                    List<string> columns = new List<string>();

                    foreach (System.Data.DataColumn d in refund.Tables[0].Columns)
                    {
                        columns.Add(d.ColumnName);
                    }

                    sw.WriteLine(string.Join(",", columns.ToArray()));

                    foreach (System.Data.DataRow _dr in refund.Tables[0].Rows)
                    {
                        sw.WriteLine(string.Join(",", _dr.ItemArray));
                    }

                    return sw.GetStringBuilder().ToString();
                }

            }
        }

开发者ID:shovelheadfxe，项目名称:DevLab，代码行数:55，代码来源:Batch.cs

注：本文中的System.Data.DataSet类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# Data.DataTable类代码示例发布时间：2022-05-24

C# Data.DataRowAction类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19177|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9987|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8325|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8695|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8638|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9655|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8622|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7998|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8652|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7535|2022-11-06

客服电话

电子邮件

C# Data.DataSet类代码示例

示例1: TestStreamDataSet

示例2: DataTableToExcel

示例3: acquireData

示例4: TC_SetDislay

示例5: LoadData

示例6: consultaInformacion

示例7: GetParameter

示例8: Process

示例9: EmployeeDataSet

示例10: listar

示例11: GetDataBySql

示例12: GetAllRecordsFromXML

示例13: SelectFromXLS

示例14: TC_SetDislay

示例15: Demonstrate

示例16: FullDataSet

示例17: GetDataTable

示例18: NorthwindDataSet

示例19: MyDataSet

示例20: GetBatchData

请发表评论

全部评论

上一篇：

下一篇：

CVE-2022-22047

krishnaik06/Machine-Learning-in-90-days

armancodv/building-energy-model-matlab:

美元符号为什么是“$”

FGRibreau/import-tweets-to-mastodon: How

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053