本文整理汇总了C#中System.Data.DataSet.Load方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.Load方法的具体用法?C# DataSet.Load怎么用?C# DataSet.Load使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.Load方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: baseUpdate
protected DataSet.DSParameter baseUpdate(DataSet.DSParameter ds, string tableName)
{
if (_is_Single_Transaction)
{
try
{
_base.BeginTransaction();
_base.SetConnection();
_db = _base.GetDatabase();
ds.Load(_base.Update(ds), LoadOption.OverwriteChanges, tableName);
_base.CommitTransaction();
}
catch (Exception exp)
{
_base.RollBackTransaction();
throw exp;
}
finally
{
}
return ds;
}
_base.SetConnection();
_db = _base.GetDatabase();
ds.Load(_base.Update(ds), LoadOption.OverwriteChanges, tableName);
return ds;
}
示例2: InitializeGrid
private void InitializeGrid( )
{
CommonUtils.ConexionBD.AbrirConexion( );
string sqlProductData = "SELECT Producto.ProductoId, Producto.Imagen, Producto.Nombre, Producto.Descripcion, Producto.Tipo, " +
"Categoria.Tipo AS [Categoria], Producto.Tamano AS Tamaño, Producto.PrecioVenta AS [Precio de Venta], Producto.RecetaId, Producto.Mostrar AS [Visible] From Producto, Categoria "+
"WHERE Producto.CategoriaId=Categoria.CategoriaId";
string sqlProductCombo = "SELECT Producto.Nombre, Producto_Producto.ComboId FROM Producto INNER JOIN Producto_Producto ON Producto.ProductoId = Producto_Producto.ProductoId";
try
{
SqlCommand cmdProduct = new SqlCommand( sqlProductData , CommonUtils.ConexionBD.Conexion );
SqlCommand cmdCombo = new SqlCommand( sqlProductCombo , CommonUtils.ConexionBD.Conexion );
DataSet dataSet = new DataSet( );
dataSet.Load( cmdProduct.ExecuteReader( ) , LoadOption.OverwriteChanges , "Producto" );
dataSet.Load( cmdCombo.ExecuteReader( ) , LoadOption.OverwriteChanges , "Combo" );
dataSet.Relations.Add( "Combo" ,
dataSet.Tables[ "Producto" ].Columns[ "ProductoId" ] ,
dataSet.Tables[ "Combo" ].Columns[ "ComboId" ] , false );
gridProductos.DataSource = dataSet.Tables[ "Producto" ];
ColumnView view = this.gridProductos.MainView as ColumnView;
view.Columns.Add( );
view.ActiveFilterEnabled = true;
DevExpress.XtraEditors.Repository.RepositoryItemPictureEdit rPic = new DevExpress.XtraEditors.Repository.RepositoryItemPictureEdit( );
rPic.NullText = "No Image";
rPic.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;
view.Columns[ 1 ].ColumnEdit = rPic;
view.Columns[ 1 ].GetBestWidth( );
view.Columns[ 8 ].Visible = false;
view.Columns[9].Visible = true;
this.gridProductos.RepositoryItems.Add( view.Columns[ 1 ].ColumnEdit );
MessageBarValue = dataSet.Tables[ "Producto" ].Rows.Count.ToString( ) + " Items";
}
catch ( Exception ex )
{
log.Error( ex.Message , ex );
MessageBarValue = "No se pudieron listar los productos. Hubo un error: " + ex.Message;
}
finally
{
barItem.Caption = MessageBarValue;
}
CommonUtils.ConexionBD.CerrarConexion( );
}
示例3: ExportData
/// <summary>
/// Exports the Gallery Server Pro data in the current database to an XML-formatted string.
/// </summary>
/// <param name="exportMembershipData">if set to <c>true</c> export membership data.</param>
/// <param name="exportGalleryData">if set to <c>true</c> export gallery data.</param>
/// <returns>Returns an XML-formatted string containing the gallery data.</returns>
internal static string ExportData(bool exportMembershipData, bool exportGalleryData)
{
using (DataSet ds = new DataSet("GalleryServerData"))
{
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
using (System.IO.Stream stream = asm.GetManifestResourceStream("GalleryServerPro.Data.SqlCe.GalleryServerProSchema.xml"))
{
ds.ReadXmlSchema(stream);
}
using (SqlCeConnection cn = Util.GetDbConnectionForGallery())
{
using (SqlCeCommand cmd = cn.CreateCommand())
{
cn.Open();
if (exportMembershipData)
{
foreach (string tableName in _schemaMembershipTableNames)
{
cmd.CommandText = String.Concat(@"SELECT * FROM ", tableName, ";");
ds.Load(cmd.ExecuteReader(), LoadOption.OverwriteChanges, tableName);
}
}
if (exportGalleryData)
{
foreach (string tableName in _galleryTableNames)
{
cmd.CommandText = String.Concat(@"SELECT * FROM ", tableName, ";");
ds.Load(cmd.ExecuteReader(), LoadOption.OverwriteChanges, tableName);
}
}
// We always want to get the schema into the dataset, even when we're not getting the rest of the gallery data.
cmd.CommandText = @"SELECT SettingValue AS SchemaVersion FROM gs_AppSetting WHERE SettingName='DataSchemaVersion';";
ds.Load(cmd.ExecuteReader(), LoadOption.OverwriteChanges, "gs_SchemaVersion");
using (System.IO.StringWriter sw = new System.IO.StringWriter(CultureInfo.InvariantCulture))
{
ds.WriteXml(sw, XmlWriteMode.WriteSchema);
//ds.WriteXmlSchema(@"D:\gsp_schema.xml"); // Use to create new schema file after a database change
return sw.ToString();
}
}
}
}
}
示例4: InitializeGrid
private void InitializeGrid( )
{
CommonUtils.ConexionBD.AbrirConexion( );
string sqlUsuarios = "SELECT UsuarioId, Nombre, Apellidos, Login, Password, Telefono, PrivilegiosXML " +
"From UsuariosSistema ";
try
{
SqlCommand cmdProduct = new SqlCommand( sqlUsuarios , CommonUtils.ConexionBD.Conexion );
DataSet dataSet = new DataSet( );
dataSet.Load( cmdProduct.ExecuteReader( ) , LoadOption.OverwriteChanges , "Usuarios" );
gridControlUsuarios.DataSource = dataSet.Tables[ "Usuarios" ];
MessageBarValue = dataSet.Tables[ "Usuarios" ].Rows.Count.ToString( ) + " Usuarios";
}
catch ( Exception ex )
{
log.Error( ex.Message , ex );
MessageBarValue = "No se pudieron listar los productos. Hubo un error: " + ex.Message;
}
finally
{
barItem.Caption = MessageBarValue;
}
CommonUtils.ConexionBD.CerrarConexion( );
}
示例5: ExecuteDatasetTEST
public static DataSet ExecuteDatasetTEST(string strConnection, string commandText)
{
if (strConnection == null) throw new ArgumentNullException("connection");
// Create a command and prepare it for execution
DbConnection conn = new TAdoDbxInterBaseConnection();
conn.ConnectionString = strConnection;
DataSet dsReturnin = new DataSet();
DataTable dt = new DataTable();
string sql = commandText;
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
DbDataReader myreader = cmd.ExecuteReader();
dsReturnin.Tables.Add(dt);
dsReturnin.Load(myreader, LoadOption.PreserveChanges, dsReturnin.Tables[0]);
myreader.Close();
conn.Close();
conn.Dispose();
return dsReturnin;
}
示例6: InitDataSource
private void InitDataSource( )
{
CommonUtils.ConexionBD.AbrirConexion( );
ChartTitle chartTitle = new ChartTitle( );
chartTitle.Text = "Productos por tipo";
chartControl.Titles.Add( chartTitle );
//chartControl.SeriesTemplate.ValueDataMembersSerializable = "Tipo";
string sql = "SELECT Categoria.Tipo, COUNT(Categoria.Tipo) AS Amount FROM Categoria INNER JOIN Producto ON Categoria.CategoriaId = Producto.CategoriaId " +
"GROUP BY Categoria.Tipo HAVING (Categoria.Tipo = Categoria.Tipo)";
//DataTable table = CommonUtils.ConexionBD.EjecutarConsulta( sql );
SqlCommand cmdProduct = new SqlCommand( sql , CommonUtils.ConexionBD.Conexion );
DataSet dataSet = new DataSet( );
dataSet.Load( cmdProduct.ExecuteReader( ) , LoadOption.OverwriteChanges , "Producto" );
BindingSource bs = new BindingSource( );
bs.DataSource = dataSet.Tables[ 0 ];
chartControl.DataSource = bs;
chartControl.SeriesDataMember = "Tipo";
chartControl.SeriesTemplate.ArgumentDataMember = "Amount";
//chartControl.SeriesTemplate.ValueDataMembersSerializable = "Amount";
chartControl.SeriesTemplate.ValueDataMembers.AddRange( new string[ ] { "Amount" } );
CommonUtils.ConexionBD.CerrarConexion( );
}
示例7: ReportAssaysResult
public static DataSet ReportAssaysResult()
{
DataSet ds = new DataSet("ReportResult");
using (new TransactionScope(TransactionScopeOption.Suppress))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
//////Get Curves
cmd.CommandText = "[X_SP_GetAssaysByWorkflow]";
//cmd.CommandText = "[dbo].[X_SP_GetAssays]";
cmd.CommandType = CommandType.StoredProcedure;
var parm1 = cmd.CreateParameter();
parm1.ParameterName = "@assay_group_projectid";
parm1.DbType = DbType.Guid;
parm1.Value = new Guid("31B4CCEC-A72C-4F30-A13A-32B48762FDD9");
//cmd.Parameters.Add(parm1);
try
{
//Let's actually run the queries
cmd.Connection.Open();
cmd.CommandTimeout = 600; //10 mins
var reader = cmd.ExecuteReader();
ds.Load(reader, LoadOption.OverwriteChanges, "t");
}
finally
{
cmd.Connection.Close();
}
return ds;
}
}
示例8: SelectQuery
/// <summary>Executes a SQL Stored Procedure with 1 parameter, and returns a DataSet.</summary>
/// <param name="StoredProcName">The actual name of the Stored Procedure on the SQL Server</param>
/// <param name="ParamValue">The Valure being passed to the Stored Procedure.</param>
/// <param name="ParamName">The actual name of the Paramter in the Stored Procedure.</param>
/// <returns>DataSet</returns>
public DataSet SelectQuery(string StoredProcName, object ParamValue, string ParamName)
{
SqlConnection conn = null;
SqlDataReader rdr = null;
DataSet ds1 = new DataSet();
// create and open a connection object
//conn = new SqlConnection(@"Data Source=NEWDUCK\SQLEXPRESSR2;Initial Catalog=ARC_ORG;Integrated Security=True");
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Home_ARC_ORGConnectionString"].ToString());
conn.Open();
// 1. create a command object identifying
// the stored procedure
SqlCommand cmd = new SqlCommand(StoredProcName, conn);
// 2. set the command object so it knows
// to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter(ParamName, ParamValue));
// execute the command
//SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//adapter.Fill(ds1);
// iterate through results, printing each to console
rdr = cmd.ExecuteReader();
ds1.Load(rdr, LoadOption.OverwriteChanges, "eNewLetter");
//while (rdr.Read())
//{
//}
conn.Close();
return ds1;
}
示例9: ExecuteQuery
public DataTable ExecuteQuery(string query, string dataTableName, SqlParameter[] parameters)
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = query;
command.CommandTimeout = commandExecutionTimeout;
command.CommandType = CommandType.Text;
if (parameters != null)
{
command.Parameters.AddRange(parameters);
}
using (var reader = command.ExecuteReader())
{
var dataSet = new DataSet();
var table = new DataTable(dataTableName);
dataSet.Tables.Add(table);
dataSet.Load(reader, LoadOption.OverwriteChanges, table);
return table;
}
}
}
}
示例10: ExportData
/// <summary>
/// Exports the data from the SQL Server database to <paramref name="filePath"/>.
/// </summary>
/// <param name="filePath">The file name (including the path) to which to write.</param>
/// <param name="exportMembershipData">if set to <c>true</c> export membership data.</param>
/// <param name="exportGalleryData">if set to <c>true</c> export gallery data.</param>
internal static void ExportData(string filePath, bool exportMembershipData, bool exportGalleryData)
{
DataSet ds = new DataSet("GalleryServerData");
System.Reflection.Assembly asm = System.Reflection.Assembly.GetExecutingAssembly();
using (System.IO.Stream stream = asm.GetManifestResourceStream("GalleryServerPro.Data.SqlServer.GalleryServerProSchema.xml"))
{
ds.ReadXmlSchema(stream);
}
using (SqlConnection cn = SqlDataProvider.GetDbConnection())
{
if (cn.State == ConnectionState.Closed)
cn.Open();
if (exportMembershipData)
{
string[] aspnet_TableNames = new string[] { "aspnet_Applications", "aspnet_Membership", "aspnet_Profile", "aspnet_Roles", "aspnet_Users", "aspnet_UsersInRoles" };
using (SqlCommand cmd = new SqlCommand(Util.GetSqlName("gs_ExportMembership"), cn))
{
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader dr = cmd.ExecuteReader())
{
ds.Load(dr, LoadOption.OverwriteChanges, aspnet_TableNames);
}
}
}
if (exportGalleryData)
{
string[] gs_TableNames = new string[] { "gs_Album", "gs_Gallery", "gs_MediaObject", "gs_MediaObjectMetadata", "gs_Role", "gs_Role_Album", "gs_AppError", "gs_SchemaVersion" };
using (SqlCommand cmd = new SqlCommand(Util.GetSqlName("gs_ExportGalleryData"), cn))
{
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader dr = cmd.ExecuteReader())
{
ds.Load(dr, LoadOption.OverwriteChanges, gs_TableNames);
}
}
ds.WriteXml(filePath, XmlWriteMode.WriteSchema);
//ds.WriteXmlSchema(filePath);
}
}
}
示例11: baseUpdate
protected DataSet.DS baseUpdate(DataSet.DS ds, string tableName)
{
_base.SetConnection();
_db = _base.GetDatabase();
ds.Load(_base.Update(ds), LoadOption.OverwriteChanges, tableName);
return ds;
}
示例12: Excel2Access
/// <summary>
/// Excel导入Access
/// </summary>
public void Excel2Access(string[] filenames)
{
try
{
for (int j = 0; j < filenames.Length; j++)
{
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = filenames[j];
connectStringBuilder.Provider = "Microsoft.Jet.Oledb.4.0";
connectStringBuilder.Add("Extended Properties", "Excel 8.0");
using (OleDbConnection cn = new OleDbConnection(connectStringBuilder.ConnectionString))
{
DataSet ds = new DataSet();
string sql = string.Format("select * from [{0}$]", sheetName);
OleDbCommand cmdLiming = new OleDbCommand(sql, cn);
cn.Open();
using (OleDbDataReader dr = cmdLiming.ExecuteReader())
{
ds.Load(dr, LoadOption.OverwriteChanges, new string[] { sheetName });
DataTable dt = ds.Tables[sheetName];
if (dt.Rows.Count > 0)
{
for (int i = 4; i < dt.Rows.Count; i++)
{
//写入数据库数据
if (!(dt.Rows[i][0].ToString() == "" || string.IsNullOrEmpty(dt.Rows[i][0].ToString())))
{
string MySql = "insert into TB_Car (PlateNumber,Color,Brand,UseYear,MotorcyleType) values('" + dt.Rows[i][1].ToString() + "','" +
dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" +
dt.Rows[i][4].ToString() + "','" + dt.Rows[i][5].ToString() + "')";
AccessHelper.SQLExecute(MySql);
}
}
MessageBox.Show("数据导入成功!");
CarBLL carBLL = new CarBLL();
DataTable carList = carBLL.FindAll_infos(getblacklistsql);
dgvCarList.DataSource = carList;
}
else
{
MessageBox.Show("请检查你的Excel中是否存在数据");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
示例13: DataSetFromSql
public static DataSet DataSetFromSql(string sql, params string[] tableNames)
{
var dataSet = new DataSet();
using (var reader = DataReaderFromSql(sql))
dataSet.Load(reader, LoadOption.OverwriteChanges, tableNames);
return dataSet;
}
示例14: Excel2Access
/// <summary>
/// Excel导入Access
/// </summary>
public void Excel2Access(string[] filenames)
{
try
{
for (int j = 0; j < filenames.Length; j++)
{
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = filenames[j];
connectStringBuilder.Provider = "Microsoft.Jet.Oledb.4.0";
connectStringBuilder.Add("Extended Properties", "Excel 8.0");
using (OleDbConnection cn = new OleDbConnection(connectStringBuilder.ConnectionString))
{
DataSet ds = new DataSet();
string sql = string.Format("select * from [{0}$]", sheetName);
OleDbCommand cmdLiming = new OleDbCommand(sql, cn);
cn.Open();
using (OleDbDataReader dr = cmdLiming.ExecuteReader())
{
ds.Load(dr, LoadOption.OverwriteChanges, new string[] { sheetName });
DataTable dt = ds.Tables[sheetName];
if (dt.Rows.Count > 0)
{
for (int i = 4; i < dt.Rows.Count; i++)
{
//写入数据库数据
if (!(dt.Rows[i][0].ToString() == "" || string.IsNullOrEmpty(dt.Rows[i][0].ToString())))
{
string MySql = "insert into TB_BlacakList (User_ChineseName,User_EnglishName,Department_ChineseName,Department_EnglishName,Job,Sex,Birthdy,Identification_Type,Identification_Number,Employer,TELEPHONE) values('" + dt.Rows[i][1].ToString() + "','" + dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" + dt.Rows[i][4].ToString() + "','" + dt.Rows[i][5].ToString() + "','" + dt.Rows[i][6].ToString() + "','" + dt.Rows[i][7].ToString() + "','" + dt.Rows[i][8].ToString() + "','" + dt.Rows[i][9].ToString() + "','" + dt.Rows[i][10].ToString() + "','" + dt.Rows[i][11].ToString() + "')";
AccessHelper.SQLExecute(MySql);
}
}
MessageBox.Show("数据导入成功!");
string getblacklistsql = "select ID ,User_ChineseName as 中文,User_EnglishName as 英文,Department_ChineseName as 单位名称中文,Department_EnglishName as 单位名称英文,Job as 职务,Sex as 性别,Birthdy as 出生日期,Identification_Type as 身份证件类型,Identification_Number as 身份证件号码,Employer as 工作单位,TELEPHONE as 联系方式 from TB_BlacakList ";
DriverListBLL driverListBll = new DriverListBLL();
DataTable dtDriverList = driverListBll.FindAll_infos(getblacklistsql);
dgvBlackList.DataSource = dtDriverList;
dgvBlackList.Rows[0].Selected = false;
}
else
{
MessageBox.Show("请检查你的Excel中是否存在数据");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
示例15: baseGetList
protected System.Data.DataSet baseGetList()
{
System.Data.DataSet ds = new System.Data.DataSet();
_base.SetConnection();
//_db = _base.GetDatabase();
ds.Tables.Add(_listTable);
ds.Load(_base.GetList(), LoadOption.OverwriteChanges, _listTable);
return ds;
}