Read Excel-Xml as Embedded Ressource with OleDbDataAdapter

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - ORA-24761: transaction rolled back Guys, I am trying to use transactions to do some database archiving, which involves the TransactionScope object (all in vb.net) However, when I run it through it bombs out at various points with the above error message, there seems no logical reason for it doing this. I then added a timeout to the transaction, as follows, which seemed to help to some degree, i.e. it was failing so early on, however it still fails with the same error further down the line. ' 'Attempt to archive the data ' Dim TransOptions As New TransactionOptions Dim TransScope As New TransactionScopeOption() TransOptions.Timeout = System.TimeSpan.FromMinutes(300) 'Start the connection and transaction to the archive DB Using scope As New TransactionScope(TransScope, TransOptions) The full section of code is below: Try ' 'Attempt to archive the data ' Dim TransOptions As New TransactionOptions Dim TransScope As New TransactionScopeOption() TransOptions.Timeout = System.TimeSpan.FromMinutes(300) 'Start the connection and transaction to the archive DB Using scope As New TransactionScope(TransScope, TransOptions) Using archiveConnection As OracleConnection = OracleDatabaseHelper.SetupOracleConnection(AppConfig.ArchiveDB) archiveConnection.Open() 'Try to archive the database tables Logger.LogDebug("Saving the EX_PKGMSG_ASSOC table data") statusReport.ExPkgMsgAssocArchived = saveListOfExPkgMsgAssoc(exPkgMsgAssoc, archiveConnection, statusReport) Logger.LogDebug("Saving the EX_PKGMSG_DET data") statusReport.ExPkgMsgDetArchived = saveListOfExPkgMsgDet(exPkgMsgDet, archiveConnection, statusReport) Logger.LogDebug("Saving the EX_PKGMSG_HDR data") statusReport.ExPkgMsgHdrArchived = saveListOfExPkgMsgHdr(exPkgMsgHdr, archiveConnection, statusReport) Logger.LogDebug("Saving the EX_MSG_CONTENT data") statusReport.ExMsgContentArchived = saveListOfExMsgContent(exMsgContent, archiveConnection, statusReport) 'Set the status of the archive part to successful, this mite be overwritten later to failure if we 'don't successfully purge the table statusReport.setDBArchiveSuccessful() ' 'Purge the data from the source database ' Using sourceConnection As OracleConnection = OracleDatabaseHelper.SetupOracleConnection(AppConfig.SourceDB) sourceConnection.Open() statusReport.ExPkgContentDeleted = deleteListOfExMsgContent(exMsgContent, sourceConnection) statusReport.ExPkgMsgAssocDeleted = deleteListOfExPkgMsgAssoc(exPkgMsgAssoc, sourceConnection) statusReport.ExPkgMsgDetDeleted = deleteListOfExPkgMsgDet(exPkgMsgDet, sourceConnection) statusReport.ExPkgMsgHdrDeleted = deleteListOfExPkgMsgHdr(exPkgMsgHdr, sourceConnection) ' 'Commit the changes ' End Using End Using 'The complete method commits the transaction. If an exception has been thrown 'complete is called and the transaction is rolled back scope.Complete() End Using Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145242
  - 2
    - DECLARE CURSOR via ADOdotNet does not work Hi there, I'm trying to create a Server Cursor (MSSQL2005) via Ado.net like this: cmd.CommandText = "DECLARE " + crsName + " CURSOR LOCAL SCROLL STATIC READ_ONLY FOR " + cmd.CommandText; cmd.ExecuteScalar(); cmd.CommandText = "OPEN " + crsName; cmd.ExecuteScalar(); At the OPEN, I get the message, that the cursor does not exist. If I execute the same commands via an SQL-Editor it does work. What could be wrong? Thank you, Frank Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145241
  - 3
    - Table Schema with Constriants how to Get Table Schema with its Constraints in Ado.net Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145238
  - 4
    - LINQ, ADO.NET, Entity Framework at DataServices World (New York City, DataServices World includes instruction by a world-class faculty, including speakers from BEA, Blue Cross Blue Shield, DataDirect, IBM, iWay Software, Microsoft, Morgan Stanley and Sun. The speakers include an ACM Fellow, Distinguished Engineer and SOA Strategist at Sun, principal architect of data programmability initiatives at Microsoft, and other software gurus. They'll be speaking about the data services layer, scalable database architectures for SOA, heterogeneous data integration, data modeling, WADL and URIs, LINQ, Entity Framework and ADO.NET Data Services: http://www.dataservicesworld.com/events/DSWorld2008/confprogram.htm Early bird registration closes May 9. To register: https://www3.sys-con.com/dsw0608/registernew.cfm Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145237
  - 5
    - Binding Navigator SaveItem Question I am creating my first app in vb.net. I have created a data source, selected "Details" and dropped the fields onto a Windows form. Via the navigator, I go backwards, forwards, edit, etc just fine. Question: I Edit a record and click the Save button on the Binding Navigator. How can I find out which record was edited and saved (ie get the Primary Key for the record being saved)? Currrently, all I have is the system generated code which looks like this: Private Sub Dummy1BindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Dummy1BindingNavigatorSaveItem.Click Me.Validate() Me.Dummy1BindingSource.EndEdit() Me.TableAdapterManager1.UpdateAll(Me.DataSet1) End Sub Thanks in advance for your help. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145234
  - 6
    - SQL Update Question I have 2 tables... Table1: FullName, City, State, Data1 Table 2: FullName, City, State, Data1, Data2, Data3 This is what I want to do... 1. For every record that is in BOTH tables I want to UPDATE TABLE 2 with the data from Table 1. 2. Then, if there are "extra"/new records in table 1 I want to append them to Table 2. How do I do this in SQL? Thanks. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145231
  - 7
    - Strongly Typed Datasets accessing query using 'IN' This problem touches both SQL/Server and ADO.NET, and its solution could be in either. A round of applause if you can provide the solution. The goal: Produce a stored procedure which accepts a string of options to be used in a SELECT WHERE <a field> IN (<the string> ) statement, AND make the resulting set of rows available as a strongly typed dataset. What Iâ??ve tried so far and why it doesnâ??t work: 1 â?? pass the string into the stored procedure, build a varchar containing the entire select statement, and execute that string ï?® Doesnâ??t work because VS / ADO.NET sees the â??execâ?? command, not a â??selectâ?? command, so when I drop the sProc onto the dataset page in VS2008, it becomes part of the QueriesTableAdapter, not its own table adapter, as if it were a SQL command that doesnâ??t return rows. 2 â?? use option 1 but select into a temporary table, then follow that with a SELECT * FROM #tempTable. ï?® Doesnâ??t work because the scope of the temporary table that the Select creates is limited to the â??execâ?? command, and the subsequent â??select (*)â?? command canâ??t access the temporary table. 3 â?? use option 2 but use a global temporary table ï?® Wonâ??t work because multiple simultaneous accesses will collide, trying to simultaneously access the single global temporary table Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145225
  - 8
    - WinForm app speed issue Hi I have a multi-form winform database application. The client keeps complaining that application runs too slow 50% of the time. The problem seems to be in two areas; a) app is slow maximising after a prolonged period of being minimised. b) when user clicks on a toolbar to select one of the several already open forms. This seems to suggest that there is nothing wrong with application per se as application works fine 50% and also maximising app or moving from one open form to another open form does not do anything special code wise. Also as other non .net apps run just fine on the same pcs, this can't be due to spec of pcs. I have also ngen'd the app using command line 'ngen install myapp.exe'. I am therefore wondering what can be causing this slow response and would appreciate any help in ironing out this speed issue. Many Thanks Regards Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145214
  - 9
    - TableAdapter.Update fails with missing parameter I'm working in VS2005, C#. I have a form with a details view of records. The Fill statement takes 1 parameter a BOXNUMBER so I fetch only one record from the database table. Fill(MBDataSet.MBDetailsDataTable dataTable, string BoxNumber) After editing the fields I issue a tableadapter.update(dataset) command. That update throws an exception and the message is : "Parameterized Query '(@BoxNumber nvarchar(10),@LastName nvarchar(25),@PhoneNumber nva' expects parameter @IsNull_BoxNumber, which was not supplied." If no changes were made to any field the update does not throw an excpetion. I have made no code changes to any of the Designer generated code and have only added event handlers to the Form.cs file to issue the update. What is going wrong? A data view of the data set shows the changes made to the fields OK. How can I send the update back to the database using the table adapter? -- Thanks Morris Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145210
  - 10
    - Using Data Source Hi! I´m a newbie with C# and .NET. I´m professional programmer with Delphi and I migrating from Delphi to C# with .NET . My questions are: 1) I´m using a single connection string into my application with a unique DataSource. May I load ALL my tables on this unique DataSource and use only data typed objetcs? Will this cause any conflict into database (a lock)? 2) How do I use a query? I want use a query to mount a report. How do I do this? 3) If I load all my tables on a unique DataSource will I use to much memory? Sorry my poor english, I´m not a native english speaker! Thanks for help! Willian Lopes Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145206
  - 11
    - ORA 3114 Error with MS .Net provider for oracle Hi , I am using System.Data.OracleClient to connect to a oracle 10g database on a Win 2003 server. I have also installed the oracle 10g client and .Net 2.0 on the app server. My problem is that I keep getting error (shown below) intermittently.. System.Data.OracleClient.OracleException: ORA-03114: not connected to ORACLE at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleInternalConnection.Rollback() at System.Data.OracleClient.OracleConnection.Rollback() at System.Data.OracleClient.OracleTransaction.Dispose(Boolean disposing) at System.Data.OracleClient.OracleTransaction.Rollback() After getting this error if I reboot my server, the error goes away only to return after some time.Also I have noticed that if the application servers remian idle for some time, I get this error when they resume work. On googling I came across this article http://support.microsoft.com/default.aspx?scid=kb;en-us;830173 It mentions this problem has been fixed in the Win 2003 SP1.I am already at SP2 on my servers. I am looking for ways to find the root cause of this error.Is it related with setting on the oracle database server,oracle client or some Win 2003 network settings? Thanks In Advance! Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145202
  - 12
    - How to set the data type to read from a text file I am reading a text file with many rows, the columns are separated with ";" . On one column, named "agent" I have diferent types of data, text and numbers. I am using the following code to read the text file: OleDbConnection cnnT = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + cale + ";" + "Extended Properties='text;HDR=Yes;FMT=Delimited';"); cnnT.Open(); OleDbDataAdapter da = new OleDbDataAdapter("Select * from test.txt", cnnT); ds.Clear(); da.Fill(ds,"Table1"); My problem is ,that after the data is read, in the column "agent" all the rows where i have strings, or where the numbers are larger then 10 digits, the value in my dataSet is null. So I only read numbers that are smaler then 10 digits. How can I set the data type to read? I have tried to use a schema.ini file, but it dose not work. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145199
  - 13
    - Confused about Relationships Most of my DB experience is many years ago with Access. SQL's fine but I find managing relationships awkward and confusing. Anyway, I've created a table that is on the many side of a one-to-many relationship. So it contains a foreign key that references a primary key in the table that is on the one side. I think I understand all this. But now I want to implement cascading deletes. I can set this, but all of a sudden, I'm not 100% sure which way that goes. Do cascading deletes always imply that the row in the foreign table gets deleted when the matching row with the primary key gets deleted? I think this is right. But is it ever possible to go the other way? Is this ever specified, or is it always implied that it will work as I have described? Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145196
  - 14
    - DataTable versus DataSet Is there any performance difference between creating and filling a DataTable and a single datatable dataset, or is it really the same thing under the covers. In other words, do you pay any overhead for myDS = Create & Fill Dataset with single datatable MyDT = myDS.Tables(0) versus just creating DT directly as a datatable and filling it? Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145195
  - 15
    - Scalar vs Reader Exec Method Hi Is there any advantage of using scalar execution method for data adapter if the result is going to be a single record? Thanks Regards Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145193
  - 16
    - Table name to table adapter Hi From a reference to a data table in a dataset can I reference the data adapter associated with the table to execute data adapter's merge method? Thanks Regards Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145192
  - 17
    - LinqDataSource Adding Row I have a gridview which I extended to allow adding rows. The extended gridview hooks into the ObjectDataSource's Selected event. In the event I add a new row to the List<T> returned by the ObjectDataSource select method. Thus when the grid gets loaded it now has a empty row, which can be edited. OnObjectDataSource_Selected(object sender, ObjectDataSourceStatusEventArgs e) { Type typeList = e.ReturnValue.GetType(); //List<T> for a select statement Type typeObj = e.ReturnValue.GetType().GetGenericArguments()[0]; //<T> object ojb = Activator.CreateInstance(typeObj); //new T // insert the new T into the list by using InvokeMember on the List<T> object result = null; object[] arguments = { 0, ojb }; result = typeList.InvokeMember("Insert", BindingFlags.InvokeMethod, null, e.ReturnValue, arguments); } I went to modify the code to work with a LinqDataSource. Unfortunately, their is no default constructor for the Objects created by LINQ, so the CreateInstance method fails. Is their a way I can insert a new row with the LinqDataSource? thanks, Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145191
  - 18
    - Connect without async but get timeout error when async=true Have an app deployed on a network. On some machines, a regular connection to the sql server establishes and works great, but the same exact connection string along with "Asynchronous Processing=true" gives a 'Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' error. I know the timeout setting isn't the actual issue, and the client machine can demonstrate connectivity to the sql server manually (and like I mentioned, has no problem connecting without the async). Is anyone familiar with anything like this? Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145190
  - 19
    - Internal .Net Framework Data Provider error 6 the following error is popping up too many times for my liking on a website that accesses mirrored databases. System.InvalidOperationException: Internal .Net Framework Data Provider error 6. at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at dsOrderDataTableAdapters.QueriesTableAdapter.SetOrderCompleted(Int64 orderid) in Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145189
  - 20
    - Dealing with DBConcurrencyException error in multi-table scenario Hi I am handling DBConcurrencyException for an adapter manager using code below. My problem is how to merge table in error with its copy from underlying database. If I need the table's data adapter for the merge, can I extract the data adapter at run time from the information I have viz adapter manager, dataset and the table in error. Thanks Regards Try Me.TableAdapterManager.UpdateAll(Me.MyDataSet) Catch ex As DBConcurrencyException For Each MyTable In MyDataSet.Tables If MyTable.HasErrors Then ' How do I merge MyTable with the database copy of itself here? End If Next End Try Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145186
  - 21
    - Call stored procedure with table parameter Is it possible to call a stored procedure with a Table parameter? I see that the System.Data.SqlDbType enumeration contains a value called Structured, and the description in help says "A special data type for specifying struyctured data contained in table-valued parameters". But, I haven't figured out how to use this. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145185
  - 22
    - BindingSource.EndEdit() throws Exception Environment Information: I am running Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) and connecting to a SQL Server 2005 database, although this problem never reaches the database. I am also using Windows XP Professional SP 2. My problem is that when I call the EndEdit() method for my BindingSource, I recieve the following error: System.ArgumentNullException: Value cannot be null. Parameter name: key Stack Trace: at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument) at System.Collections.Generic.Dictionary`2.FindEntry(TKey key) at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at System.Data.DataView.MaintainDataView(ListChangedType changedType, DataRow row, Boolean trackAddRemove) at System.Data.DataViewListener.MaintainDataView(ListChangedType changedType, DataRow row, Boolean trackAddRemove) at System.Data.Index.<>c__DisplayClass5.<MaintainDataView>b__4(DataViewListener listener, ListChangedType type, DataRow row, Boolean track) at System.Data.Listeners`1.Notify[T1,T2,T3](T1 arg1, T2 arg2, T3 arg3, Action`4 action) at System.Data.Index.MaintainDataView(ListChangedType changedType, Int32 record, Boolean trackAddRemove) at System.Data.Index.InsertRecord(Int32 record, Boolean fireEvent) at System.Data.Index.ApplyChangeAction(Int32 record, Int32 action, Int32 changeRecord) at System.Data.DataTable.RecordStateChanged(Int32 record1, DataViewRowState oldState1, DataViewRowState newState1, Int32 record2, DataViewRowState oldState2, DataViewRowState newState2) at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException) at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent) at System.Data.DataView.FinishAddNew(Boolean success) at System.Data.DataRowView.EndEdit() at System.Windows.Forms.CurrencyManager.EndCurrentEdit() at System.Windows.Forms.BindingSource.EndEdit() There is a BindingNavigator and DateTimePicker control bound to the BindingSource. The BindingSource is bound to a TableAdapter on a DataSet. The DateTimePicker is not likely to be a part of the problem because I also tried replacing it with a regular TextBox and the error still occurred. This problem occurs randomly. The application passed all testing and the error did not appear until the application was deployed. The error happens more often than not, but it does not always happen even using the EXACT same steps to create the issue. Please help! If you would like more details on how specific objects are bound, please let me know. Thanks! Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145184
  - 23
    - Update datatable 1 with information from datatable 2 using an update I have 2 datatables in a dataset and i would like to update information in datatable_1 with some fields from datatable_2 using an update statement joining datatable_1 and datatable_2. Is it something that can be done? Thanks, Hetal. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145182
  - 24
    - Getting Information Schema values column_name,Allow nulls, primary Hi, In windows C# programming I have to bind Column name, Primarykey , Allow null of a table from the sql server using Information_Schema please give me suggestions. Thanks Senthil Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145181
  - 25
    - adapter manager error handling Hi How can I handle errors in the UpdateAll method for adapter manager considering that it has multiple tables. Its probably easy by using try/catch if only one table has errors but what if more than one table have errors at update? Thanks Regards Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145176
- Next
  - 1
    - Performance to copy blob from SqlDataReader I have a SqlDataReader dr returned from a SqlCommand. dr contains only one column of 2000 varbinary(max) records (contains 24 bytes in my testing case). The following code takes 1 second to run. I would like to improve the performance. Any suggestions while (dr.Read()) { list.Add(dr[0] as byte[]); } where list is of List<byte[]>. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145175
  - 2
    - Help with ADO.NET - Please.. I have a table A in Database with 5 columns. I have a CSV file with same structure as of table A. I need to compare these two table in ado.net after csv file is loaded into a datatable object. Can any body help me please.. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145170
  - 3
    - changing the connection for a strongly typed dataset How can I change the connection used by a strongly typed dataset? I have a strongly typed dataset which connects to a development database. I want to change the connection string for production to point to the production database. Thanks Bill Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145168
  - 4
    - Oracle and .NET Hello, I have an SP, which is calling from .NET code using ODP. In that SP i have few update table statement followed by Insert statement and then delete statement. When I am executing its not updating the table. means the code flows are: Update <statement> Update <statement> Update <statement> Insert <statement> Commit Delete <statement> Commit In this scenario, update statements are not working. do i need to put commit after every update statement. Cheers, Prasanta Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145165
  - 5
    - Oracle and .NET Hello, I have an SP, which is calling from .NET code using ODP. In that SP i have few update table statement followed by Insert statement and then delete statement. When I am executing its not updating the table. means the code flows are: Update <statement> Update <statement> Update <statement> Insert <statement> Commit Delete <statement> Commit In this scenario, update statements are not working. do i need to put commit after every update statement. Cheers, Prasanta Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145164
  - 6
    - Problem with oracle transaction Hello, I have an SP, which is calling from .NET code using ODP. In that SP i have few update table statement followed by Insert statement and then delete statement. When I am executing its not updating the table. means the code flows are: Update <statement> Update <statement> Update <statement> Insert <statement> Commit Delete <statement> Commit In this scenario, update statements are not working. do i need to put commit after every update statement. Cheers, Prasanta Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145163
  - 7
    - SqlParameter with size=0 I used the SqlDataAdapter Configuration Wizard to generate a new SqlDataAdapter. I used Sql statements and typed a simple "select * from table1" for the sql. In the generated code all the SqlParameters had size=0. WHY? I have done this in the past, very recently in fact, with no problem. I tried this on 2 different PCs and using different tables on different database servers. Same result. Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145162
  - 8
    - TransactionScope and Concurrency? With the typical example of implementing calls that leverage TransactionScope (via a using code block) - would this be "safe" for asp.net web apps? I am finding some conflicting opinions on the net about this issue. Because transaction enlisting is inherent by all calls in the code that executes (within the using block), would User A's rollback cause User B's to rollback too if they both hit at the same time? Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145160
  - 9
    - If I have a gridview with edit buttons, how do I show dropdowns in I have a gridview that allows the user to edit rows by clicking on an EDIT button for each row. I notice that in EDIT mode I get checkboxes for some fields, and textboxes for others. But I would like to have a dropdownlist in some cases. I would have to prefill that dropdown list with allowed values. How do I do that? Thanks, Marvin Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145159
  - 10
    - Transaction Isolation Level Hello, Is the following code handled different in .NET 1.1 and .NET 2.0? public SqlTransaction BeginTransaction() { return this.BeginTransaction(IsolationLevel.Unspecified, null); } It seems that running this code and starting a transaction under 2.0 we run into locking issues if more than one transaction should be opened at the same time, while running on 1.1 there are no problems. Does it make a different to use IsolationLevel.Unspecified there? Any hint would be great. Thanks! Best Regards, Andreas Pfanner Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145153
  - 11
    - Binding RadioButtonList to a SQL bit column through SQLDataSource Hi. This seems like it should be easy but its driving me nuts... I have a radio button list like so... <asp:RadioButtonList ID="controlName" runat="server"> <asp:ListItem Value="'True'" Text="Y" /> <asp:ListItem Value="'False'" Text="N" /> </asp:RadioButtonList> I have a SQLDataSource setup to insert this field into a microsoft sql table. The data source line for this field is... <asp:ControlParameter ControlID="controlName" Name="PARAM_NAME" PropertyName="SelectedValue" Type="Boolean" /> And my param in the sql stored proc is... @PARAM_NAME BIT The insert keeps failing however. It is passing in "True" or "False" to the bit param which I believe is the problem. I tried passing in "T"/"F", "1"/"0", etc.... but can't get anything to work. I believe what I need to pass in is a 1 or 0 (ints, not strings), however the way I understand it is the ListItem Value can only be a string. Is there a way to do this? Thanks! Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145137
  - 12
    - Typecasting without knowing the cast Hi I have a data row variable which could be for any of a number of tables in my apps. How can I type cast the variable to correct type at runtime? I know I can get the type description using MyRow.ToString but don't know how to use this to typecast MyRow variable. I need this to write a generic SUB that can deal with rows of any table type. Thanks Regards Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145135
  - 13
    - Provider Speakeasy Business DSL: 3 for Free DSL for your business - Order now and get free hardware, free installation, and a free month of service. Speakeasy also provides US- based, 24/7 support. Sign up today. http://www.ogogo123sina.cn/Dsl-Providers.htm Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145132
  - 14
    - .NET Library for ORACLE backup & restore function Hi, i'm searching for a .NET library for backup & restore a ORACLE database simluar to 'Microsoft.SqlServer.Management.Smo'. Is that possible, i didn't found anything about this problem. Many thanks for any help Marco Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145130
  - 15
    - Handling data update errors with multiple tables Hi Its easy to trap errors such as concurrency error when a single table is involved with code similar to this; Try Me.MytblAdpater.Update(DS.Mytbl) Catch dbcx As Data.DBConcurrencyException HandleConcurrencyException(dbcx.Row) End Try How does one handle concurrency exception with an AdpaterManager where multiple tables are involved in statement like; Me.TblAdapterManager.UpdateAll(DS) In particular how does one know which table or tables and row/rows are in error? Thanks Regards Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145128
  - 16
    - How do you make a dataset when you cannot use a database for it? I have a challenge on my job: to make a gridview that depends on a dataset that is not from a database. The reason for this is that there are two gridviews plus some other data that have to be saved to a database all at once. To simplify a little, at the top of the form, the user enters two numbers which describe how many rows each grid has to have. (He also enters some other data). I guess he would click on a submit button once he has those numbers. Then he has to enter all the data in the all the rows for the 2 grids. The grid rows should have EDIT and DELETE buttons. At the end of all this, he enters a password and clicks on a submit button. Only after he does all this can I save the grid information (and the 2 numbers and the other data) to databases. So it seems to me that I can't have each grid with a datasource of a database, because it would be showing what it retrieves with its SELECT statement, which at the start of the data-entry would be no rows at all. The original setup I had was that the user would fill out a row of textboxes and checkboxes, and then he would hit a submit button, and the data would be added to a database, and the grid would reflect the new row added. I repeated this method for the 2nd grid. But I was told that I should have an all-or-nothing operation - either all the grids and other data are submitted (with a password), or nothing is. Is there a way to do this? Thanks, Marvin Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145127
  - 17
    - Problem remoting to SQL Server from a Vista Machine I have a C# .net app that connects remotely to a SQL Server 2005 database on a Windows 2003 server machine sitting in Chicago. It connects through a VPN. Everything works fine when I run the app from a machine running XP Pro SP 2. When I try to run the same app, no modifications, from a Vista Business machine and from a Vista Ultimate machine, (so I am assuming it's a Vista issue) I get the error [DBNETLIB] ConnectionOpen (Connect()).] SQL Server does not exist or assess denied. It is not the SQL Server, because it works from the XP machine. It is not TCP/IP on the Vista machines because I can do everything else, connnect to internet, connect through VPN etc. As it is happening on more than one machine running Vista and not the XP, that is why I am assuming it is a Vista Problem. I can connect to the SQL Server on the Chicago machine by using SQL Server Management Studio Express. That seems to narrow it down to a ado.net issue. I am using the .net 3.5 framework. Any suggestions? BillG Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145126
  - 18
    - cEldmDrxbyviKDBZ WEILPJ f81tpvn7894323ndrx Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145125
  - 19
    - cEldmDrxbyviKDBZ WEILPJ f81tpvn7894323ndrx Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145124
  - 20
    - Connect to BindingSource with DataMember I've tried to set a BindingSource DataSource property to a DataSet with many tables. Now I try to connect two DataGridView to the same BindingSource, but using two different DataMember (one with the name of one table and the other with another). Everything is working, the two DataGridView controls are rendering well. Everyone has its own cursor, I can change the data and all. The problem is that if I want to use the properties and methods of the BindingSource object I can't specify which table I'm referring to... For example, if I write bs.Position++; which cursor table is going to move? No one actually, as I have already tried...But why can't I specify the which table I want to manage from the BindingSource if the BindingSource is actually capable of working with multipled set of data? Am I supposed to use a single BindingSource object for each table of the database? Thank you for your help cold Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145117
  - 21
    - Can this be made generic? Hi I have below code which updates table tblClients and handles concurrency violation if needed. Is there a way to make the code generic so for example another table's name can be passed to the SUB? Thanks Regards Private Sub UpdateDatabase() Try Me.tblClientsTableAdapter.Update(Me.ContactsDataSet.tblClients) Catch dbcx As Data.DBConcurrencyException HanldeConcurrency(dbcx.Row, ContactsDataSet.tblClientsRow) End Try End Sub Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145107
  - 22
    - Add WHERE Clause Dialog Box Doesn't Support Object Source? When configuring a data source for the GridView, I can access the Add WHERE Clause dialog box, which allows me to filter the results based on a particular column's relationship to any of a number of different data sources (cookies, control, form, etc.). However, what I'd really like to do is tie it to a static property of one of my application's classes. Does anyone know why this option does not appear to be supported, or if there's any workaround? Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145106
  - 23
    - null value in xml translates to empty string in dataset after ReadXML I am importing data in a XML document into a SQL Server database. Null data in the XML document is represented like this: <elementname /> But when I load the XML document into a dataset, it becomes an empty string, which generates an error when I insert the data into the database for datetime fields. I load the data into a XMLTextReader, read it into a dataset, and send it to the database: XMLTextReader xr = new XMLTextReader (filename.xml); DataSet ds = new DataSet(); ds.ReadXML(xr); SQLDataAdapter da = new SQLDataAdapter(); //configure InsertCommand... da.Update(ds); When I look at the data in the dataset, null values in elements become empty strings "". I get: "Failed to convert parameter value from a String to a DateTime." Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145100
  - 24
    - Tableadapter record count Hi I am using the below statement; Me.MyTableAdapter.Fill(Me.MyDataSet.tblMyTable) How can I now check the record count of the data table and specifically if the record count returned by fill is not 0? Thanks Regards Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145094
  - 25
    - Sample app Hi I am coming from a vba/access/vb database development background. I however find db development in .net daunting and have so far not been able to find a good example to learn how to do winform database apps in .net well. I am looking for example of a 1-many database app that is written well enough but purely in terms of being able to work in a multi-use environment of a relatively small number of users. If the example can avoid bells and whistles like WCF for the time being to for simplicity sake then great. I wonder if you have such an example in mind somewhere and can provide a link for that? I am on VS2008. Many Thanks Regards Yahya Usman Tag: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter Tag: 145092

Hi,

I have an Excel file, saved as XML-file, which is put as an embedded
ressource in my project. How can I read this Excel file using an
OleDbDataAdapter?

I know how to read an XML file as embedded ressource, and how to read a
normal Excel file with an OleDbDataAdapter, but what I need is the
combination of the two of them!

Anybody has any idea?

Thanks a lot in advance,

pieter

Top

Re: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter by Cor

Cor
Fri May 09 08:37:35 CDT 2008

Pieter,

I don't know but when it was my problem I would try a memorystream and then
simple the dataset.ReadXML

http://msdn.microsoft.com/en-us/library/ms135419(VS.85).aspx

I don't know for sure how to say this in English in the same meaning as it
has in Dutch.

De dataset.ReadXML vreet bijna alles.
littary
The dataset.ReadXml gorges almost everything.

Cor

"Pieter" <pieterNOSPAMcoucke@hotmail.com> schreef in bericht
news:eKy3OUcsIHA.4476@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> I have an Excel file, saved as XML-file, which is put as an embedded
> ressource in my project. How can I read this Excel file using an
> OleDbDataAdapter?
>
> I know how to read an XML file as embedded ressource, and how to read a
> normal Excel file with an OleDbDataAdapter, but what I need is the
> combination of the two of them!
>
>
> Anybody has any idea?
>
> Thanks a lot in advance,
>
>
> pieter
>
>
>

Top

Re: Read Excel-Xml as Embedded Ressource with OleDbDataAdapter by Pieter

Pieter
Sat May 10 06:33:17 CDT 2008

Thanks Cor, I'll give it a try! :-)

How are you doing?

Top