本文整理汇总了C#中System.Data.Common.DbDataAdapter类的典型用法代码示例。如果您正苦于以下问题:C# DbDataAdapter类的具体用法?C# DbDataAdapter怎么用?C# DbDataAdapter使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DbDataAdapter类属于System.Data.Common命名空间,在下文中一共展示了DbDataAdapter类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CloneFrom
private void CloneFrom(DbDataAdapter from)
{
IDbDataAdapter adapter = from._IDbDataAdapter;
this._IDbDataAdapter.SelectCommand = this.CloneCommand(adapter.SelectCommand);
this._IDbDataAdapter.InsertCommand = this.CloneCommand(adapter.InsertCommand);
this._IDbDataAdapter.UpdateCommand = this.CloneCommand(adapter.UpdateCommand);
this._IDbDataAdapter.DeleteCommand = this.CloneCommand(adapter.DeleteCommand);
}
示例2: HookupRowUpdateEvents
// Called just before the Save() is truly executed
override protected void HookupRowUpdateEvents(DbDataAdapter adapter)
{
// We only bother hooking up the event if we have an AutoKey
if (this.GetAutoKeyColumn().Length > 0)
{
OleDbDataAdapter da = adapter as OleDbDataAdapter;
da.RowUpdated += new OleDbRowUpdatedEventHandler(OnRowUpdated);
}
}
示例3: TableMapForm
internal TableMapForm(DbDataAdapter dbAdapter)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
this.dbAdapter = dbAdapter;
}
示例4: FonteDeDadosOld
/// <summary>
///
/// </summary>
/// <param name="fonteDeDados">Tipo entre Excel, SQLServer ou arquivo TXT.</param>
/// <param name="Local">Esse atributo representa o endereço do servidor do banco de dados, o local de grvação do arquivo Excel ou txt.</param>
/// <param name="Arquivo">Esse atributo representa o nome do Banco de dados em caso de um SGDB,o nome da planilha Excel ou o nome do arquivo TXT.</param>
/// <param name="Login">Login para SQLServer.</param>
/// <param name="Senha">Senha para o SQLServer.</param>
public FonteDeDadosOld(TipoFonteDados fonteDeDados, string Local, string Arquivo, string Login, string Senha)
{
try
{
_local = Local;
_arquivo = Arquivo;
_login = Login;
_senha = Senha;
_tipoFonteDados = fonteDeDados;
if (_tipoFonteDados == TipoFonteDados.SQLServer)
{
_stringConexao = "Data Source=" + _local + ";Initial Catalog=" + _arquivo + ";User Id=" + _login + ";Password=" + _senha;
_conexao = new SqlConnection();
_comando = new SqlCommand();
_adaptador = new SqlDataAdapter();
}
if (_tipoFonteDados == TipoFonteDados.Excel)
{
_stringConexao = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + _local + "\\" + _arquivo;
if (_primeiraLinhaCabecalho)
{
_stringConexao += ";Extended Properties='Excel 8.0; HDR=YES'";
}
else
{
_stringConexao += ";Extended Properties='Excel 8.0; HDR=NO'";
}
_conexao = new OleDbConnection(_stringConexao);
_comando = new OleDbCommand();
_adaptador = new OleDbDataAdapter();
}
if (_tipoFonteDados == TipoFonteDados.TXT)
{
ConectaArquivoTXT();
}
}
catch (Exception ex)
{
//clsUtil.Gravalog("IsicLibrary.dll", "clsBancoDeDados.clsBancoDeDados()", Environment.StackTrace.ToString(), ex.Message);
throw ex;
}
}
示例5: OleDb
/// <summary>
/// Excel 或Access 檔存放位置(虛擬路徑)
/// </summary>
/// <param name="ConnectString">連結字串</param>
public OleDb(ConnectionString ConnectString)
{
constring = ConnectString;
string connstr =
string.Format("{0}{1}",
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=",
System.Web.HttpContext.Current.Server.MapPath(ConnectString.ConString));
Connection = new OleDbConnection(connstr);
adapter = new OleDbDataAdapter();
}
示例6: CreateFile
protected void CreateFile(string database, string tableName, IDbCommand cmd, DbDataAdapter da)
{
cmd.CommandText = string.Format(TableInfoSQL, database.ToLower(), tableName.ToLower());
DataTable dt = new DataTable();
da.Fill(dt);
cmd.CommandText = string.Format(TableCommentSQL, database.ToLower(), tableName.ToLower());
string tableComments = (cmd.ExecuteScalar() ?? string.Empty).ToString();
CreateFile(tableName.ToUpper(), tableComments, dt);
}
示例7: DataSource
public DataSource(
string name, DataProvider provider, string connectionString,
string commandDir, string commandFileMask)
{
_name = name;
_provider = provider;
_connectionString = connectionString;
_commandFactory = new DataCommandFactory(this, commandDir, commandFileMask);
_templateConnection = (IDbConnection)Activator.CreateInstance(_provider.ConnectionObjectType);
_templateCommand = (IDbCommand)Activator.CreateInstance(_provider.CommandObjectType);
_templateDataAdapter = (DbDataAdapter)Activator.CreateInstance(_provider.DataAdapterObjectType);
}
示例8: Builder
public DbCommandBuilder Builder(DbDataAdapter adapter)
{
switch (provider)
{
case "System.Data.SqlClient":
return new SqlCommandBuilder ((SqlDataAdapter)adapter);
case "MySql.Data.MySqlClient":
return new MySqlCommandBuilder ((MySqlDataAdapter)adapter);
default:
throw new NotSupportedException ("The provider "+provider+" is not supported in this library.");
}
}
示例9: GetData
public DataSet GetData(DbDataAdapter adapter, string CommandText, CommandType cmdType, DbParameter[] parameters = null)
{
DataSet ds = new DataSet();
_cmd.CommandText = CommandText;
_cmd.CommandType = cmdType;
if (parameters != null && parameters.Count() > 0)
{
_cmd.Parameters.AddRange(parameters);
}
adapter.SelectCommand = _cmd;
adapter.Fill(ds);
return ds;
}
示例10: DBCAD
public DBCAD(string sDBKey, string sTable, string sColum)
{
this.sDbKey = sDBKey;
this.sTable = sTable;
this.sColum = sColum;
this.adaProxy = this.CrearAdaptador(this.sTable, this.sColum);
}
示例11: button1_Click
private void button1_Click(object sender, EventArgs e)
{
try
{
Adapter = DbProvider.GetDataAdapter("SELECT subject1, subject2, subject3, subject4, subject5 FROM Subjects WHERE (Faculty_ID='" + Faculty_ID.ToString()+ "'AND Spec_ID='" + Spec_ID.ToString() + "'AND SesionNo='" + int.Parse(textBox1.Text).ToString() + "')", ORM.DB_University.connection);
Table = new DataTable();
Adapter.Fill(Table);
if (Table.Rows.Count == 0)
{
throw new Exception("Invalid SesionNo");
}
for (int i = 0; i < 5; i++)
dataGridView1.Columns[i].HeaderText = Table.Rows[0][i].ToString().Trim();
Adapter = DbProvider.GetDataAdapter("SELECT Mark1, Mark2, Mark3, Mark4, Mark5 FROM Marks WHERE (Student_ID='" + Stud_ID.ToString() + "' AND SesionNo='" + int.Parse(textBox1.Text).ToString() + "')", ORM.DB_University.connection);
Table = new DataTable();
Adapter.Fill(Table);
if (Table.Rows.Count == 0)
{
for (int i = 0; i < 5; i++)
dataGridView1[i, 0].Value = "";
MessageBox.Show("0 rows");
return;
}
for (int i = 0; i < 5; i++)
dataGridView1[i, 0].Value = Table.Rows[0][i].ToString().Trim();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
示例12: button1_Click
private void button1_Click(object sender, EventArgs e)
{
try
{
string[] df = comboBox1.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string fid = df[df.Count() - 1].Trim();
df = comboBox2.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string sid = df[df.Count() - 1].Trim();
Adapter = DbProvider.GetDataAdapter("SELECT subject1, subject2, subject3, subject4, subject5 FROM Subjects WHERE (Faculty_ID='" + fid + "'AND Spec_ID='" + sid + "'AND SesionNo='" + int.Parse(textBox1.Text).ToString() + "')", ORM.DB_University.connection);
Table = new DataTable();
Adapter.Fill(Table);
if (Table.Rows.Count == 0)
{
for (int i = 0; i < 5; i++)
dataGridView1[i, 0].Value = "";
MessageBox.Show("0 rows");
return;
}
for (int i = 0; i < 5; i++)
dataGridView1[i, 0].Value = Table.Rows[0][i].ToString().Trim();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
示例13: DataAccessLayer
protected DataAccessLayer(string connectionString)
{
CommandTimeout = 120;
Com = null;
Adapter = null;
Constr = connectionString;
}
示例14: Initialize
protected void Initialize (string databaseName, string querySelectRowString)
{
string providerName = GetProviderNameByDBName(databaseName);
string connectionString = GetConnectionStringByDBName(databaseName);
// Create the DbProviderFactory and DbConnection.
factory = DbProviderFactories.GetFactory(providerName);
connection = factory.CreateConnection();
connection.ConnectionString = connectionString;
// Create the DbCommand.
DbCommand SelectTableCommand = factory.CreateCommand();
SelectTableCommand.CommandText = querySelectRowString;
SelectTableCommand.Connection = connection;
adapter = factory.CreateDataAdapter();
adapter.SelectCommand = SelectTableCommand;
// Create the DbCommandBuilder.
builder = factory.CreateCommandBuilder();
builder.DataAdapter = adapter;
adapter.ContinueUpdateOnError = true;
}
示例15: TableInform
public TableInform( string tableName )
{
try
{
dataAdapter = TableInform.dbProviderFactory.CreateDataAdapter();
command = TableInform.dbProviderFactory.CreateCommand();
command.Connection = TableInform.Connection;
DbCommandBuilder commandBuilder = TableInform.dbProviderFactory.CreateCommandBuilder();
commandBuilder.ConflictOption = ConflictOption.OverwriteChanges;
commandBuilder.DataAdapter = dataAdapter;
dataTable = new DataTable();
dataTable.TableName = tableName;
command.CommandText = "Select * from " + Table.TableName;
dataAdapter.SelectCommand = command;
dataAdapter.InsertCommand = commandBuilder.GetInsertCommand();
dataAdapter.UpdateCommand = commandBuilder.GetUpdateCommand();
dataAdapter.DeleteCommand = commandBuilder.GetDeleteCommand();
dataAdapter.Fill( dataTable );
}
catch ( Exception ex )
{ }
}