Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Casting/DB Insertion problem
Jeremy - 16 Apr 2005 8:40 PM - 4 messages
I have a problem inserting/extracting a byte array to/from an Sql DB. The byte array has a length of 1040. The field in the DB is of type binary (I have also unsuccessfully tried varbinary). The following example will ...
Score retrive record ID on insert
Russ Green - 16 Apr 2005 3:57 PM - 6 messages
I have a application that connects to an access database.  I need to insert an item into one of the tables and immeditely retrieve the value from the autonumber field so that I can use that value into a record in another ...
Score Making 2 datasets to one
Jens - 16 Apr 2005 8:33 AM - 8 messages
Hi IS there a better way to join 2 datasets into one, than adding rows from datset1 to dataset2 through a loop? thanks in advance. I need this to show the common result in a datagrid. Jens... ...
Score Help with Inherited Control
Poohface - 16 Apr 2005 7:48 AM - 5 messages
I'm trying to create a list box control that replaces the itemData property that we had in VB6. I created and inherited control from the listbox class and was able to add a data property, now the problem is, ...
Score Strongly Typed Data Set InsertCommand not working
mark6139 - 15 Apr 2005 11:12 PM - 4 messages
I have created a strongly typed dataset in C# using "Generate DataSet" from the schema viewer/designer in Visual Studio .Net 2003.  And I'm using this in a Windows Forms application. The database is an Access file. I have created the associated data adapter and added an insert command ...
Score Connection issues
Steve - 15 Apr 2005 7:08 PM - 9 messages
We have an application server which serves as an access point to a database.  Each user connected to the server has their own connection to the database.  Pooling is turned on, but since everyone has a unique Workstation ID, they share with only themselves. ...
Score Could not find installable ISAM
TheOne - 15 Apr 2005 6:15 PM - 4 messages
Hi I am trying to open or to fill in to dataset sample excel file. Got it working couple days ago, but it is giving me error now. It is same error on 2 different machines. Please help. Code......         Dim sList, strConnToExcel As String ...
Score Excel.exe ALive with OldDBconnection when Spreadsheet Already Ope
Neil - 15 Apr 2005 4:38 PM - 2 messages
I am using an oldDBconnection to do a sql insert and update to a spreadsheet. If the Speadsheet is open in excel when the .net program updates the spreadsheet then excel.exe lingers in task manager. Can anyone suggest what is the fix? Code works fine if spreadsheet is not ...
Score .net File Import
LadyRose - 15 Apr 2005 3:13 PM - 6 messages
I am using visual studio with .Net and I am trying to import a text file into a table I have a date in this file ie 01012002 it is imported 1012002, stripping off the leading zero I can't change the import file, that is the way is comes to me, but I need ...
Score Display data updated in a trigger after SqlDataAdapter.Update
Aurin - 15 Apr 2005 2:49 PM - 5 messages
I have a DataGrid bound to a DataTable.  I issue a SqlDataAdapter.Update command to apply the user’s changes to the database.  Everything works just fine.  However, in the database (SQL Server) I have a trigger which updates ...
Score DataViewManager - Apply DataView.RowFilter
tomb - 15 Apr 2005 2:26 PM - 2 messages
How to set the RowFilter property of a DataViewManager (dvm) without to bind every time the dvm to control? If I bind to a DataGrid (G) G.DataSource = dvm; G.DataMember = tablename (that belongs to DataSet) and then I set ds.Tables[tablename].DefaultView.RowFilter = "new filter" ...
Score changing a primary key value
Alan Baljeu - 15 Apr 2005 2:07 PM - 4 messages
I have an SQL table with a 3 column key, PK = (a,b,c).  I read that into a DataTable: SELECT * from MYTABLE where a=1 AND b=2 I edit this in a grid, hiding columns 'a' and 'b'.  During editing, column c values may ...
Score Connection String
Arif Çimen - 15 Apr 2005 1:09 PM - 2 messages
Hi to everyone, I created a Access Database (*.mdb) file. I configured the connection string on the Server Exploer. My problem is that this conncetion string has a path pointing to mdb file. But after installing the application to the target machine, the path in the ...
Score resetting connection to SqlServer
Tony Riv - 15 Apr 2005 9:07 AM - 4 messages
Is there anyway to reset a connection to SqlServer, it seems as though the connection remains on the workstation until it is rebooted. ...
Score Could not find installable ISAM
Jason James - 15 Apr 2005 8:28 AM - 5 messages
Hi all, I am creating an ASP web service and wish to connect to an MS Access 2003 database.  However, when I attempt to access the database I get the following error "Could not find installable ISAM" I found this on a Microsoft web site. ...
Score Sort bug in DataTable.Select with Windows 2003 SP 1
Niall - 15 Apr 2005 6:53 AM - 2 messages
Win2k3 SP1 was recently applied to some of our unit testing machines and we noticed some tests were failing, apparently due to sort order. We believe there is a bug in DataTable.Select(string Filter, string Sort) when the filter contains two subfilters joined with "AND". Our code attempts ...
Score Full Outer Join?
Pascal - 15 Apr 2005 6:07 AM - 4 messages
Hi all, what is the symbol equivalent to FULL OUTER JOIN? I tryed *=* but SQLServer doesn't support it. thanks, Pascal ...
Score Microsoft.ApplicationBlocks.Data
TLWood - 14 Apr 2005 9:01 PM - 5 messages
Hi I am using the v2.0 FillDataset method with a pre-existing typed dataset. 1 or 2 tables seems to work fine, but 3 or more do not fill the pre-existing tables, but add new tables Table2, Table 3 instead. ...
Score Temporary Table
Dino Buljubasic - 14 Apr 2005 7:52 PM - 3 messages
Can somebody help with this problem please. I need to create a temporary table from a table in SQL Server database.  The database table looks like: id    description                                             other ...
Score Microsoft Data Access Application Block beginer help
scott289 - 14 Apr 2005 7:18 PM - 7 messages
I have successfully downloaded the Enterprise Library and the data access block (C#). I am able to compile and run the quickstart application. So I would like to try the DAB in a new project. But I was unable to ...
Score What is the thoughtful process behind it? SqlDataReader.NextResult Method
John Smith - 14 Apr 2005 6:27 PM - 2 messages
I am using .NetFramework 1.1. and SQL2K. I am calling a stored procedure and it has multiple results set and some output parameters. If the output parameter does not meet certain condition, I am quitting the stored procedure (SP) by calling "return" statement which results in SP not ...
Score Adding New Row...
peg - 14 Apr 2005 5:22 PM - 3 messages
I'm new to ado.net/asp.net - After a user fills in a webform I'm trying to add a row to the table with its values..... but after running this code (no errors) and i check my table - nothing is ...
Score Transactions
pdsluk - 14 Apr 2005 4:55 PM - 8 messages
Hi I am new to transactions and I am not sure if this is the correct method, any help would be appreciated. My transaction involves reading data from serveral tables and making two new inserts into other tables. I want to ensure what is read and written stays as ...
Score SQL / .Net Code Generator
Demetri - 14 Apr 2005 3:30 PM - 2 messages
I am writing the business and data components for an application in C#. In addition I having to write against an oracle database. The logic for updating/inserting in the database the values in the bussiness components is getting really tedious and I am looking for an easier way. ...
Score (another) datarelation datagrid question
gabe - 14 Apr 2005 2:54 PM - 2 messages
i have an ad hoc query builder (long story) to faciliate ad hoc heterogenious queries (all kinds of databases - linked servers arent an option) and i would like the end data displayed in a datagrid without the '+' in a manner described  best by "How to Display Child Table Rows as a Column ...
Score Oledb Connection String ?
Mark Gaeth - 14 Apr 2005 10:24 AM - 4 messages
Greetings, I have tried for an answer on another forum with no direct answer. I have my forms that have a connection to an Access db with all the connections created by the wizard. No problems with the operations of the forms in the ...
Score DataGrid -> DataTable mapping problem
RichS - 14 Apr 2005 9:56 AM - 7 messages
Hi, [ Using C# in .Net 1.1 ] I'm trying ( amongst other things ) to create a per-row tooltip that displays all of the columns ( and cell value ) for that row - i need it as there are a large number of columns that will exceed the width of the app and ...
Score Update Command with Parameter....
A_PK - 14 Apr 2005 9:29 AM - 4 messages
Could anyone pls guide me what is wrong with my Update Command         Dim signbyte As Byte()         signbyte = GetByteArray() ' i create this function to return ByteArray         Try ...
Score filtering dataview where child relation does not exist
lars - 14 Apr 2005 7:23 AM - 2 messages
Hi, Theoretically this seems a simple thing but...can anyone help on how to do it? I have two tables and a relationship between them. The parent table is databound to a repeater the Child table is databound to a nested repeater. ...
Score Crystal Report
Hemang Shah - 13 Apr 2005 10:47 PM - 3 messages
CR does have export to excel. However the excel export is not usable, it is all messed up.  Multiple excel row for each line & so on Is there anyway around this one ? Thanks ...
Score How to Rename Access Table:
Thomas H. Lanier - 13 Apr 2005 10:24 PM - 3 messages
Does anyone know how to rename an Access table in VB.Net with OleDb? For instance, this does NOT work: cn = New OleDbConnection(ConnectionString) cn.Open() sql = "ALTER TABLE Test1 RENAME Test2" cmd = New OleDbCommand(sql, cn) cmd.ExecuteNonQuery() Thanks, ...
Score Convertin dbnull to string
40forty - 13 Apr 2005 9:31 PM - 7 messages
Hello, I am trying to insert a new datarow.  Everything works fine except for three columns that have datetime data types.  I keep getting this error message "System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store <> ...
Score Execute command over Sybase Database Server 11.0.3.3
Ricardo Quintanilla - 13 Apr 2005 8:54 PM - 3 messages
From C# i need to execute a SQL command over a Sybase Database Server 11. do i need to buy a special ADO.NET Provider? which ADO.NET Provider? where Can I buy that ADO.NET Provider? besides ADO.NET Provide, do i need another driver or something like that? ...
Score How to pass dataReader object
Mori - 13 Apr 2005 8:52 PM - 6 messages
I am trying to pass a datareader object and then iterate through the reader in a client application.  I get the following exception "Invalid attempt to read when no data is present." Question:  What is the correct way to pass a dataReader? Any Good examples ...
Score Possible to open Access Report
Brad Wood - 13 Apr 2005 7:40 PM - 2 messages
Is it possible to execute an Access report via ADO w/o having to resort to using the Access automation server with COM Interop? ...
Score SqlCommand SQL statement 'stuck'
KevinRug - 13 Apr 2005 7:28 PM - 6 messages
In the code below, I am trying to change the select statment to be "distinct" , ( i have also tried "top 1"), but when the code runs I always get the original query "Select city from doctors". Here is a code extract ...
Score How to look at parameter string
tshad - 13 Apr 2005 6:33 PM - 7 messages
I'm not sure if this is an asp.net or ado.net question. I have been using parameters with my Sql commands and have been getting errors that say there is a problem with my input string, but there is no way ...
Score Deleting from a dataview
Stephen Zachmann - 13 Apr 2005 3:37 PM - 5 messages
Ok... I have a dataset, which I use to populate a dataview I filter the dataview based on user criteria The dataview is bound to a datagrid I want to delete the filtered set of records from the dataset not just the ...
Score List SQL servers on a system
irimiabc - 13 Apr 2005 3:19 PM - 2 messages
Hello! 1. I am trying to list the SQL servers installed on a machine...using .NET? Is it posible to do this? Are the any magic class in .Net designed for such a job? Please help. 2. I am trying to list the ODBC drivers installed on a machine...using .NET? ...
Score disconnected typed dataset
TLWood - 13 Apr 2005 2:22 PM - 21 messages
Hi I am creating a multi-user db app in VB.NET 2003 which accesses a remote SQL Server. The db has many tables related hierarchically. At the start of a session I want to get a selected set of data into a dataset, work with it ...
Score DataAdapter Update Does Nothing
Demetri - 13 Apr 2005 2:18 PM - 8 messages
I am attempting to insert a new row into the database. It is executing without error but when I check the database there are no changes. Is there some step I'm missing? Here is my code: OracleConnection con = new OracleConnection(this.MyConnectionString); ...
Score ADO error "There is already an open DataReader associated with this Connection"
jck via DotNetMonster.com - 13 Apr 2005 1:39 PM - 7 messages
I have been reading somewhat about this error, but I am confused as to why mine is happening. I use a single, static connection from the instantiation of the form in my project.  Against this, I run DataReaders and then close them immediately. ...
Score Making my own strongly typed dataset
JohnDeHope3 - 13 Apr 2005 12:48 PM - 6 messages
I know there are a few ways of having VS2003 make typed dataset. But I want to do it by myself, without having a tool write the code for me. Is there any resource that explains the ins and outs of this? I'm sure the VS2003 ...
Score SQLHelper.ExecuteReader - Connection Close
Baren - 13 Apr 2005 11:32 AM - 7 messages
Hi!, I have all the methods to get datareader defined in a Business Acees Layer and accessing the methods in my codebehind by passing the datareader value ByRef. I am  using SQLHelper Class to execute the storedprocedures. After binding the Datareader to the ASP control, I am closing the datareader,  but ...
Score Oracle Data Providers (Connection Pooling & Transactions)
Prits - 13 Apr 2005 11:29 AM - 6 messages
I want to connect to Oracle 8.1.7 server through my application. I would like to know which .NET data provider will be the best option? Microsoft Oracle Provider or a ODP.NET provided by Oracle. Here server is hosting databases for many other applications and ...
Score Simple asynchronous method
Jon - 13 Apr 2005 10:15 AM - 5 messages
Hello all, Could somone please help! I'm trying to fire an asynchronous method but all the examples I'm finding are pretty complex. The basic thing I need to do is: 1) Do some logic 2) Fire off a method (threading needed?) ...
Score Get worksheets from Excel
Mircea Pleteriu - 13 Apr 2005 9:20 AM - 2 messages
Hi, I use the OleDb objects to connect to an excel file and retrieve data from a specified worsheet. What SELECT statement should I use (if there is an existing one) to retrieve the names of the worksheets in the file? ...
Score Importing Excel data to Access
Totto - 13 Apr 2005 9:19 AM - 8 messages
Hi, What is the best practice when importing Excel data to an access database? Totto ...
Score repost: Registering Provider
Andrzej Kaczmarczyk - 13 Apr 2005 8:25 AM - 4 messages
Sahil, Now you got me *puzzled* I've written already: " but I can also access it with simplier way: Data -> Add New DataSource -> Next -> DataBase -> Next -> New Connection all in Windows XP SP2, Visual Studio 2005 Pro Beta 2 (feb ctp), Visual C#, ...
Score Filling multiple tables
tshad - 13 Apr 2005 1:02 AM - 7 messages
I have about 10 dropdownlists that I need to fill when the page loads. At the moment I am doing the following over and over for each dropdown: ***************************************************************** Sub GetExperience(sender As Object, e As System.EventArgs) Dim emailReader As SqlDataReader ...
Score asp.net using oracle collection types
efinney - 13 Apr 2005 12:45 AM - 2 messages
Hi, Does anyone have an example using asp.net with an oracle database specifically calling stored procedures that return collection types of a user defined type or simple data type? What driver did you use? What hurdles did you have to over come? ...
Score Fix for DataTable.Select bug
Dallara - 12 Apr 2005 11:58 PM - 5 messages
FYI This is about a bug in DataTable.Select, where the wrong rows were returned from this function, which I reported here a time ago and was completely ignored (some guys from US even complained about me referring to "(" and ")" ...
Score Can't Read Excel File (OleDb) w/ ASP.NET Impersonation
cmay - 12 Apr 2005 11:24 PM - 14 messages
Problem: When impersonation is set in the web.config file, I cannot establish an OLEDB connection to the database from my ASP.NET v1.1 application. (Unspecified Error.  Stack trace shows it happens on the ProcessResults method within the OleDB Provider) ...
Score ADO.NET 2.0 Beta 2 - SqlBulkCopy operation timing out in Feb.05 CT
Johnny - 12 Apr 2005 10:58 PM - 2 messages
Hello, For some odd reason, a simple bulk copy operation I am making using the SqlBulkCopy class times out before it is suppose to when I use the Feb. 05 CTP version. I am trying to bulk copy a 10 row DataTable to a SQL 2005 (Oct. 04 ...
Score rowfiltering with two datatables in a dataset using a dataviewmang
Robs - 12 Apr 2005 10:50 PM - 3 messages
I have twotables in a dataset: User and Orders.  The user has certain orders they must work.  It is defined by the fund range. users:    userid int    userName nvarchar(50)    userBeginRangeFund char(4) ...
Score ANN: Using ADO.NET inside SQL Server 2005 with SQLCLR
Pablo Castro [MS] - 12 Apr 2005 10:24 PM - 2 messages
SQL Server 2005 enables the creation of procedures, functions, etc. using managed code. Since you can use managed code, sooner or later you'll want to access some data in the same or a different server, and for that you'll most ...
Score BLOB fields and Microsoft Access
Randel Bjorkquist - 12 Apr 2005 9:14 PM - 15 messages
I'm having a problem pulling out a Microsoft Excel Workbook from a Microsoft Access database.  I know I have the database set up correct, because from withinside of Access I can insert and retreive the files.  What is happening ...
Score DataRelation
Justin Lazanowski - 12 Apr 2005 8:37 PM - 11 messages
I have some data that is disassociated, I am trying to put an ad-hoc relationship into it so that I can get it hierarchical. What I need to do is create a relationship on two fields in a table. Is it ...
Score Connecting with paradox file..
Ricardo Magalhaes - 12 Apr 2005 7:35 PM - 4 messages
Hi, I´m trying to connect with a paradox database from my windows dot net application(vb.net) and web application(asp.net) using odbc driver. vb.net project works fine, but the asp.net it doesn´t. The following code is the ...
Score ORA-03113 error when updating an oracle clob column via a view
John Fluevog - 12 Apr 2005 7:32 PM - 2 messages
I'm getting a ORA-03113 error whenever I try to update an oracle clob column and the length of the value of the OracleCommand parameter is longer than 4000. This happens whether doing an DataAdapter.update method or just ...
Score SqlException: Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'
Evan Camilleri - 12 Apr 2005 5:42 PM - 7 messages
I am accesing an SQL Server through a stored procedure which (this stored procedure) accesses a linked-server (an access database). Fom Win2000/XP PCs I am having no problems. From 98 PCs I am having SqlException: Could not create an instance of OLE DB ...
Score Re: ntext displayed in a data grid
Daniel Fisher(lennybacon) - 12 Apr 2005 4:51 PM - 2 messages
Win or WebForm? Daniel ...
Score ntext displayed in a data grid
HMK - 12 Apr 2005 4:29 PM - 3 messages
I am retrieving a SQL ntext column from a table and inserting it into a datagrid. However, it ignores line breaks so I get large blocks of unformatted text. Is there a way to show the data as it is stored either by ...
Score DataSet Transactions Help
Brian Scott - 12 Apr 2005 3:04 PM - 5 messages
I currently have a defined Datalayer in a C# application which is filled with data on startup. All forms in the system bind the to this dataset data source. The datatables within the dataset have various datarelations setup and as most of the table keys are Identity fields I had to write stored ...
Score Stored procedure / .NET woes
mfos239 - 12 Apr 2005 2:50 PM - 5 messages
I have no idea what is going on here, maybe someone can help me out. I have developed an application for my company's intranet using ASP.net and SQL Server. We have two servers, one hosts the .NET apps and the other runs SQL Server 2000. The application runs without a hitch most of the time, but every morning I experience the same exact problem. One (and only one) page which gets its data using a stored procedure call to SQL Server throws an exception "General Network Error. Check your Network Documentation." It will throw this exception or just return 0 results. ...
Score Merge DataTable Rows into Second DataTable
Matt N - 12 Apr 2005 2:36 PM - 3 messages
All, Can anyone help me understand the best way to copy all rows from an existing DataTable into a second DataTable which also has existing rows. The following code takes 6-7 seconds for 1200 rows in sourceTable and 1 or more rows in ...
Score Help with DATE data type conversion
John Cosmas - 12 Apr 2005 1:28 PM - 5 messages
I've encountered a table that stores dates in Gregorian format so that the dates and time looks like straight integers that cannot be easily discrened as a date or time by just looking at it.  I'm using SQL to query the table ...
Score Database Component Help
Randel Bjorkquist - 12 Apr 2005 12:25 PM - 3 messages
I'm completely lost and need some help to understand how the Visual Studios data components work, deals with database, datsets, datasources, etc...  I'm extremely new to Visual Studio and am having a hard time making the conversion from Borland's C++ Builder to Visual Studio. ...
Score VB.Net and Sage
Duncan - 12 Apr 2005 9:42 AM - 2 messages
Dear friends, I have a client which would like us to post data into SAGE Line 50.  Are there any API or Controls or methods out there that you know off which would help us achieving the task Thanks ...
Score GetOleDbSchemaTable
RichardF - 12 Apr 2005 9:13 AM - 3 messages
Hi, I using OleDbConnection.GetOleDbSchemaTable to read the database schema from an access database. The question is if I do the same operation on a different database provider (for example sql server) will the tables/columns of the schema be the same ? ...
Score Duplicate Connections
DavidM - 12 Apr 2005 4:04 AM - 4 messages
I am using the SQLConnection object to establish a connection a SQL Server 2000 PC running on my local PC. Whenever I open the connection I get two loggins on the SQL Server. Does anyone know what is causing this to happen? ...
Score How to lock the record before editing
Ellis Yu - 12 Apr 2005 3:05 AM - 3 messages
Dear all,         I have a module of application for updating a record from serveral tables and I used optimistic locking at the beginning, but the feedback is user feel frustrated when they knew the records can't be saved since it had ...
Score Getting the SPID for a pooled connection
howard39@nospam.nospam - 12 Apr 2005 1:49 AM - 3 messages
I am using disconnected datasets and ADO.Net. How would I get the SPID for a pooled connection? I would like to log the user name and SPID each time a user performs a database update transaction, and then correlate this with the the transaction ...
Score Extract Unique Values from Database
Prasun - 11 Apr 2005 10:27 PM - 6 messages
Hello: I am trying to extract the unique rows from a child table. Currently I am set the create contraints vaue in the datarelationship to False. Because of this, it will ignore the unique values in the child table. I want to be able ...
Score How to get the element names using a dataset
Mahesh - 11 Apr 2005 7:05 PM - 2 messages
Hi all, I need to get the elementnames and the no of elements froman XSD. I used readXMLSchema method to read the schema, but i am not able to get the element names. here is my schema... <?xml version="1.0" ?> ...
Score File dialog and Data Adapter
Jim - 11 Apr 2005 3:53 PM - 3 messages
Is it possible pass the file name from a File Dialog to the Data Adapter? I need to select an Access database to "open". There are many different access files which have the same data structure. I know I can copy the file to a ...
Score ADO.Net, Transactions, and ASP.Net
Mythran - 11 Apr 2005 3:47 PM - 5 messages
I just want to know the advantages vs disadvantages of using Component Services to handle our web application transactions over creating and passing around a transaction object of our own?  When would you use one over the other, or use one instead of the other? ...
Score Transaction Scope
Vish - 11 Apr 2005 3:09 PM - 6 messages
Hi, I have seen difference approaches in handling transactions on the msdn site. One approach is that you open a connection and then begin the transaction. Next you execute command objects using this connection and after you are done you commit or rollback thereby giving a global scope to the transaction for ...
Score How to insert into multiple tables with one update.
Geir Holme - 11 Apr 2005 1:31 PM - 2 messages
Hi all. When I first heard about VB.NET it should be so easy to update "Mother/child" tables. Just build at datasett with all the tables, do the changes and run .Update. Well, I cant get this to work that easy. Do anyone have some pointers on how ...
Score Locks
Chakra - 11 Apr 2005 12:22 PM - 3 messages
Does ADO.NET support ways of  locking  table, row, database ? Regards, Chak. ...
Score Database Paging
Brian Scott - 11 Apr 2005 11:24 AM - 3 messages
Hi, another question that I hope someone can help me out with. I have started usin Paging with a Windows Form Datagrid in .Net. What I want to know is is there a method to dynamically page the query from the database in the same ...
Score registering provider
Andrzej Kaczmarczyk - 11 Apr 2005 10:23 AM - 6 messages
Hi, if this is not the appropraite list, forigve me and point to the correct one. I have a custom .NET Provider implementation that follows all guidelines. I can connect tot he database, fill dataset, use it in all kind of query ...
Score DataSet Transactions
Brian Scott - 11 Apr 2005 10:02 AM - 3 messages
Hi, I'm looking for some advice. I have developed a system for a client using the DataSet object within a business layer. There are various points in the application were I need to perform a transaction over multiple datatable ...
Score Transactions over 2 databases?
Brian Scott - 11 Apr 2005 8:26 AM - 3 messages
Hi, I was wonderring what was the best method in ADO.Net regarding wrapping a transaction around 2 seperate databases. Is it even possible? Thanks. ...
Score DataView / DataSet / ADO.NET HELP
A_PK - 11 Apr 2005 7:47 AM - 9 messages
Ok I want to filter a dataset into a dataview and be able to reference back to the dataset from the filtered dataview. Example: 100 record dataset filter it to a 5 record dataview loop thought the Dataview and update the original dataset .... if there is a ...
Score Data bound combo box problem
J L - 11 Apr 2005 4:59 AM - 3 messages
I have a combo box with DropDownStyle set to DropDownList. I bind it as follows: cmboOperators.DataSource = opTable cmboOperators.DisplayMember = "OperatorName" cmboOperators.ValueMember = "OperatorID" opTable is a DataTable. I have a button on the form (just for testing) that does this: ...
Score OdcbConnection Open throws InvalidOperationException
John Mairs via .NET 247 - 10 Apr 2005 10:01 PM - 2 messages
(Type your message here) -------------------------------- From: John Mairs Hi Folks, I just found and fixed this problem and I wanted you all it know about it. I'm leaving at details cuz there not important conn = new OdbcConnection setup selectCmd dataAdapter = new OdbcDataAdapter(selectCmd, conn) ...
Score Typed dataset and namespaces
Magne Ryholt - 10 Apr 2005 7:51 PM - 3 messages
I can set the properties Namespace and Prefix on datasets, datatables and datacolumns. I beleive this is handy in my situation (specially for tables and columns), however I cannot find any way to set the namespace and prefix properties in ...
Score access database with asp.net
Stephen Martinelli - 10 Apr 2005 4:55 PM - 7 messages
I have a asp app that works well on local host. The connection string is as follows in the web.config <appSettings> <add key="cs" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\databases\sfleet.mdb"/> ...
Score How to implement UpdateBatch.. with XML DotNet
ian mason - 10 Apr 2005 3:35 PM - 2 messages
How do I implement old ADO recordset.UpdateBatch method when using DotNet XML? The old XML seems to contain enough information to allow the UpdateBatch to work when XML was sent to a middle tier. I have looked at the XMLDataDocument and can load XML and a Schema (*.xsd) - ...
Score For experts: Reproducible bug (with testcase)
Boris - 10 Apr 2005 3:27 PM - 5 messages
I finally managed to create a small testcase to reproduce a bug somewhere in Access, ADO, COM etc. - see my original posting in October 2004: [link] ...
Score New in VS.net
Cemal Karademir - 10 Apr 2005 10:40 AM - 3 messages
Hi, I'm new in programming programming in VS.NET 2003. I have some experience in Embedded Visual Basic and VB.6. In these programming languages i use adoce and adodb to access an MS Access database. But I don't know how to do this ...
Score ListView Troubles
Mr. B - 10 Apr 2005 5:01 AM - 5 messages
VB.net issue here. I've a strange event that I can't seem to figure out... On my Form, I've a TabControl (two Tabs)... On my first tab, I load an Ascii file and dump some info onto my ListView ...
Score For implementing wrap around for a table
Hari - 10 Apr 2005 12:29 AM - 6 messages
Hi, Iam looking a good solution for wrapping around records in the table. The requirement is to keep only last n (eg. 20000) number of records in the table. After inserting the n+1 record the first record need to be removed from the ...
Next » 2 3 4 5 6 7 8 9 10