本文整理汇总了C#中IDbDataAdapter.Update方法的典型用法代码示例。如果您正苦于以下问题:C# IDbDataAdapter.Update方法的具体用法?C# IDbDataAdapter.Update怎么用?C# IDbDataAdapter.Update使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDbDataAdapter
的用法示例。
在下文中一共展示了IDbDataAdapter.Update方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ExecuteBatchUpdate
public object ExecuteBatchUpdate(ConfigSettings configuration, DataSet ds)
{
Connection(configuration);
((IDbCommand)configuration.DBCommand).Connection = GenericConnection;
switch (configuration.DataStore)
{
case DataProviderType.Sql: GenericDataAdapter = new SqlDataAdapter((SqlCommand)configuration.DBCommand); break;
case DataProviderType.OleDb: GenericDataAdapter = new OleDbDataAdapter((OleDbCommand)configuration.DBCommand); break;
case DataProviderType.Odbc: GenericDataAdapter = new OdbcDataAdapter((OdbcCommand)configuration.DBCommand); break;
}
GenericDataAdapter.UpdateCommand = (IDbCommand)configuration.DBCommand;
int i = GenericDataAdapter.Update(ds);
GenericConnection.Close();
GenericConnection.Dispose();
return (object)i;
}
示例2: DoInDataAdapter
public object DoInDataAdapter(IDbDataAdapter dataAdapter)
{
dataAdapter.SelectCommand.CommandType = selectCommandType;
dataAdapter.SelectCommand.CommandText = selectSql;
ParameterUtils.CopyParameters(dataAdapter.SelectCommand, selectParameters);
foreach (DataTableMapping dataTableMapping in mappingCollection)
{
dataAdapter.TableMappings.Add(((ICloneable)dataTableMapping).Clone());
}
if (dataAdapterSetter != null)
{
dataAdapterSetter.SetValues(dataAdapter);
}
//TODO consider refactoring to put this inside IDbMetadata
PropertyInfo selectCommandProperty = commandBuilder.GetType().GetProperty("DataAdapter",
BindingFlags.DeclaredOnly |
BindingFlags.GetProperty |
BindingFlags.Public |
BindingFlags.Instance
);
selectCommandProperty.SetValue(commandBuilder, dataAdapter, null);
ParameterUtils.CopyParameters(selectParameters, dataAdapter.SelectCommand);
if (containsDataSet)
{
return dataAdapter.Update(dataSet);
}
else
{
//TODO should query metadata to see if supports filling dataTable directly.
if (dataAdapter is DbDataAdapter)
{
return ((DbDataAdapter)dataAdapter).Update(dataTable);
}
else
{
//TODO could create DataSet and extract DataTable... for now just throw
throw new DataException("Provider does not support filling DataTable directly");
}
}
}