Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Help with FileSystemWatcher
Nathan Sokalski - 8 Apr 2006 8:22 PM - 1 message
I have a directory on my site that I keep a bunch of text files in. The Application keeps the first line of each of these files in an HttpApplicationState variable as a SortedList. When I add or modify one of ...
Score INSERT Statement with Empty Date
glenn - 8 Apr 2006 3:24 PM - 2 messages
Hi folks, I am using an Access database, VB.NET and ADO.NET working with a DataGrid control. MY datagrid table has both a date_sent and a date_ans field.  When I Insert a record in my SQL statement, I insert a date_sent but I need to insert a ...
Score ListBox Problem
thebison - 8 Apr 2006 3:07 PM - 2 messages
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score connection timeout
sam - 8 Apr 2006 1:15 AM - 3 messages
I tend to get the following error: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." I've checked my connections in profiler and noticed my SPID's tend to ...
Score instance of sqlDataReader - is not available to an exteranl method
Web learner - 7 Apr 2006 10:48 PM - 8 messages
I am trying to create a method GetDataFor(string column) becaues I have to repeat the same statements for several columns but I get an error as follows: The name 'dr' does not exist in the current context It seems the dr -the instance of sqlDataReader - is not becoming available to the method. How to make it available? This seems trivial and newbie problem related to OOP, but I am confused. Could you pl. look at the code or point me to some relevant URL. ...
Score OleDbCommandBuilder unexpected behavior
Prodip K Saha - 7 Apr 2006 6:34 PM - 2 messages
Here is my scenario- I have two stored procedures in Sybase with same name with different ownership. Normally, I have only one procedure with dbo ownership but today I have another procedure with non-dbo owner. That's where the problem starts. I am using .Net Framework 1.1 with this app. ...
Score Should Dispose be called on DataTable and DataSet objects?
Chavdar - 7 Apr 2006 5:29 PM - 6 messages
It is my understanding that the DataTable and DataSet objects are "disonnected" (from the database) classes and support IMDB (In Memory Database). The IDisposable interface implemented in DataTable and DataSet is inherited from the MarshalByValue interface which is there to support visual drag&drop ...
Score Efficient data retrieval techniques
Eniac - 7 Apr 2006 3:18 PM - 3 messages
Hiya guys, earlier on today I had a discussion (to avoid calling it an argument ^.^) with my friend. We were discussing about whether there's really one good way to efficiently retrieve data from a database. To sum it up, his opinion was that the only good way to retrieve data ...
Score datarow and aggregate functions
steven scaife - 7 Apr 2006 1:32 PM - 2 messages
I am building a system that pulls a large dataset from the sql backend. I am then applying a row filter to the dataview, i have 5 filters, day, week, month, quarter and year. However i need to total up 2 / 3 of the columns depending on the dataset and ...
Score Problem with database mirroring and ADO.net
Mattrix - 7 Apr 2006 1:28 PM - 4 messages
I have set up mirroring and trying to get it to work from my .NET application. Mirroring seems to work ok. When I do a manual failover the witness is updated properly in the sys.database_mirroring_witnesses table so it seems to be configured ...
Score We are looking for companies that are experts in dotnet and c#
gusse.net - 7 Apr 2006 9:36 AM - 2 messages
Hope it is ok to post here ! We are looking for companies that are experts in dotnet and c# . Most also have good knowledge of database, ado and XML We have a project  where we need about 1-2 people for a period for 3-6 month ...
Score Adding New Row (Getting Back Autonumber/Adding Parent-Child record)
Aziz - 7 Apr 2006 8:33 AM - 5 messages
Newbie queston here. I am using VB .NET 2003, with an Access 2003 Database and Ole connection in VB. Assume I have the following tables: ==ORDERS==                ==ORDER_PRODUCTS== ...
Score Help on SQLAdapter Command ???
serge calderara - 7 Apr 2006 8:20 AM - 4 messages
Dear all, I have a function name GetLabData which call a store procedure . For that function I need to create the Adapter.InsertCommand an DeleteCommand My InsertCommand works fine and build as follow : ======================>   m_SQl_Insert = "insert into External_Data LINE_ID) " ...
Score Weird BindingList - BindingSource problem: Add(New)/Insert/... not called
Pieter - 7 Apr 2006 7:02 AM - 2 messages
Hi, I have a custom List that inherits from BindingList. It has some methods overloaded, like the Add/Insert/etc to add and remove some eventhandlers when adding or removing an item T of the list. The problem happens when: ...
Score manually create UpdateCommand; automatic onenot working for inform
Gentian Hila - 7 Apr 2006 4:54 AM - 2 messages
I am trying to update an Informix database through a datagrid in ASP.NET (Vb.NET) and I am using commandbuilder to  that .NET provides. I am able to get the records and populate the dataset, edit them but ...
Score Relation Grand-parent/Grand-child in a typed DataSet
olrt - 6 Apr 2006 8:56 PM - 3 messages
Hello ! I'm writing a very simple Windows App in C# with Visual Studio 2005. I have a DataSet composed like this : DataTable CLIENT DataTable COMMANDE DataTable ARTICLE Relation FK_CLIENT_COMMANDE : 1 CLIENT to many COMMANDE Relation FK_COMMANDE_ARTICLE : 1 COMMANDE to many ARTICLE ...
Score what to do with a table called 'EVENT' ?
gordonjones - 6 Apr 2006 8:28 PM - 4 messages
I'm writing a VB.NET 2005 app to display some data from an Oracle 10g database that has a table called EVENT. When I generate a DataSet using the Wizard and Designer nothing was working as expected. Then I noticed ...
Score Query against two DataTables
Roy - 6 Apr 2006 8:15 PM - 3 messages
I have two DataTables with a foreign key between them and I can query each DataTable and combine data. Is there an easy way for me to make a query against the two, just like the join query in SQL Server against two tables? ...
Score Reach a MDB-file without Jet client installation
Magnus - 6 Apr 2006 7:54 PM - 2 messages
Hi! I am writing a complex system where a small part will connect to an mdb.file to reach some simple information. The problem is that I don't want to deploy any jet engine. Right now I have a well working Visual Studio 2005, with Dotnet 2.0 Windows ...
Score sql express: multiple computers accessing same database file?
David - 6 Apr 2006 7:06 PM - 3 messages
For sql express, can multiple computers access  same database file on a shared network drive?  This is for a small client with 3-5 computers.  I do not wish to use Express if I am heading into ...
Score Free Sql Express Command/Query Tool?
David - 6 Apr 2006 6:48 PM - 3 messages
Is there a free Command/Query Tool for Sql Express?  I have seen posts for commercial tools but I need a simple tool to allow creation of databases, entry of create commands, stored procedures, and ability to run simple queries.   ...
Score Adding New Row With Relationship
Aziz - 6 Apr 2006 3:42 PM - 5 messages
I am using VB .NET 2003 Assume I have the following tables: ==ORDERS==                ==ORDER_PRODUCTS== OrderID (PK)              OrderProductsID (PK) ...
Score DataSet foreign key update problem
Jamie Oglethorpe - 6 Apr 2006 3:13 PM - 1 message
I have a strongly typed DataSet with a bunch of tables and relationships. The relationships reflect the foreign key relationships in the underlying database. One of the tables is a join table, linking the others; all of them represent one logical entity. ...
Score Outlook related query
peeyush - 6 Apr 2006 1:50 PM - 1 message
I want to access a field of outlook to store some information from my application, can i store it in customerid field, if not which field is available for access. ...
Score Dataset Column reordering
Jeppe Jespersen - 6 Apr 2006 1:44 PM - 1 message
I have designed a dataset in the VS2005 Dataset Designer. It holds a few datatable objects. I would like to change the ordering of the columns within each dataTable. Why, you ask? The dataset is used in a VSTO costumization of an Excel workbook, and data ...
Score Generate DataSet from Xml Schema
Oscar Thornell - 6 Apr 2006 12:09 PM - 1 message
Hi, I am probably incredibly stupid (or just blind)... I have an Xml Schema which I would like to turn into a DataSet in VS.NET 2005. In VS.NET 2003 I could right click and choose "Generate DataSet" but since ...
Score Prevent rowstate change for one column
Carl - 6 Apr 2006 11:21 AM - 4 messages
Hi! I have an DataTable with one extra column that I've added manually, and is not in the database. I use this col for various calculations, and it should never be saved to the db. That works fine, except for one thing: when I ...
Score Microsoft Oracle Data Provider
Derek Brennan - 6 Apr 2006 10:41 AM - 4 messages
Hi, I am currently using the Microsoft Oracle Data Provider (System.Data.OracleClient) to access an Oracle database. Recently we noticed some articles regarding support or distributed transactions. This appears to be specific to an earlier version of the provider (1.0), but we would like ...
Score Profiler Audit Logout Performance
Brian Wotherspoon - 6 Apr 2006 9:46 AM - 1 message
Hi All, I'm running an online transaction processing system using an SQL Server 2000 SP3 database server and an online application server. I seem to be hitting some performace issues I believe be related to connections.  Certainly I've tracked it to a single point in the ...
Score insert value list in paramter
kikde - 6 Apr 2006 6:59 AM - 1 message
Hi, i'm using a sql-select command (commandtyp:text) and the sql-query is build with commands: sql="...  and PROD  in ( :PRDCT_NAME )" Cmd.Parameters.Add(":PRDCT_NAME", OracleType.VarChar, 0, "PRDCT_NAME") Cmd.Parameters.Item(":PRDCT_NAME").Value = _Product _Product contains a value list like "'a','b','c'" ...
Score Specified cast is not valid, when column returns NULL
Web learner - 6 Apr 2006 12:30 AM - 6 messages
while (dr.Read()) //dr is an instance of sqlDataReader {     double minAirTemp = (double)(Single)dr["minAirTemp"];     // minAirTemp is column in SQLExpress table  (data type: real, allows nulls) } The above code works. But when there are NULL, I get the following error ...
Score SQL Server Locks/ProcessID - Is this a problem?
Spam Catcher - 5 Apr 2006 9:24 PM - 3 messages
Hi all, I have a simple application which polls a DB every couple of seconds to retrieve some status information. The app also updates the database from time to time. I would say 85% polling, 15% updates. In SQL Server's Management Screen (Locks/ProcessID) I see ~3 SPIDs related ...
Score SQL UniqueIdentifier - OBJECTGUID error
Bmack500 - 5 Apr 2006 7:24 PM - 3 messages
Thank you in Advance! I'm storing a record for an AD object using the Object GUID and storing it as a UniqueIdentifier in SQL server, like this: svrStruct is a Structure with svrStruct as: Dim oGUID as GUID '***************         Dim objectGUID As Guid ...
Score Data Access Problem
thebison - 5 Apr 2006 2:41 PM - 6 messages
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score DropDownList web control in DataGrid
glenn - 5 Apr 2006 2:26 PM - 1 message
Hi folks, I am getting an error "Object reference not set to an instance of an object". It seems I have everything in place but something is obviously in err.  If you could take a quick peak at my code segments and provide any insight in a ...
Score Storing filepath in database field ??
serge calderara - 5 Apr 2006 2:17 PM - 6 messages
Dear all, I am buidling a ASP 1.1 appliciation. what is the best way to store file path in SQL server database field Do I have to store the Physicalpath or only the file and then retreive the full path name when needed ? ...
Score How to determine when a DataGridView's DataSource is finished being populated
johneevo - 5 Apr 2006 1:46 PM - 3 messages
This would seem to be a fairly simple and straight forward thing to do.  So sorry if this has been answered somewhere already, but I have not been able to find the answer. I am creating a custom DataGridView component and need a way to ...
Score how to: bindingSource.Current <=> DataTable.Row
toja - 5 Apr 2006 8:53 AM - 1 message
What's the best way (proper) to get dataRow when I have bindingsource.Current item. I use : myTableRow= ((MyDataSet.MyTableRow)((DataRowView)(MyBindingSource.Current)).Row) It works, but it doesn't elegantly to me. And in the other way: I have dataRow and i want to find position of this row in my DataSet. I ...
Score How to alert to GridView
ad - 5 Apr 2006 6:38 AM - 1 message
I use a GridView to connection to a TableAdapter by a ObjectDataSource and I add a partial calss to the TableAdapter, and add a new update method like: -----------------------------------------------------------------------    public virtual int Update2(int Pred, ..)         { ...
Score Upload Excel file to a BLOB column. - Need Solution.
Anbu C Joseph - 5 Apr 2006 5:05 AM - 6 messages
I having a problem where in I have to upload the excel document into BLOB db column of a table. I tried and I was able to upload the excel document. when the size of the excel document goes more than 32kb it fails and throws a ...
Score Seemingly random Concurrency violations updating Access database
mfreeman - 5 Apr 2006 3:36 AM - 14 messages
The minimal code (VB.NET 2003) needed to show this problem is shown below. All I do is loop through the records in the table and update them without making any changes.  Out of 600 records, about 40 of them ...
Score Year only data from daily dates
Web learner - 5 Apr 2006 1:33 AM - 3 messages
I have daily data from year 1995 to 2004. The following query SELECT [obsDate] FROM [tblObs] returns 3653 datevalue records for each day. 1995-01-01 00:00:00 1995-01-02 00:00:00 1995-01-03 00:00:00 ...
Score Retrieving a single value from a dataset
MarkAurit - 5 Apr 2006 12:22 AM - 2 messages
Im using a data access layer that pulls everything back as a dataset.  They arent exposing the scalar return. The dataset is  populated with a single value from a database, the max() of a date. How is the fastest way to get a single value from a dataset consisting only ...
Score merging app.config files
zuhx - 4 Apr 2006 11:56 PM - 2 messages
I am trying to access ApplicationSettings defined in one project from another.  However it doesn't seem like I can do this.  I am trying to set the ConnectionString in the app.config of the executable project and be able to reference in all the other projects of the solution. ...
Score query builder and derived table
sutphinwb@nospam.nospam - 4 Apr 2006 11:23 PM - 2 messages
hi does the query builder not handle sub queries (aka derived tables)? the derived table gets added to the table view, but i can't figure out how to set it up properly. thanks bill ...
Score data diagrams, dataset, please help
Michelle - 4 Apr 2006 9:59 PM - 1 message
Hi all (Using VS 2005, vb.net) Ok, I might be missing something *HUGE*, so please excuse me, I'm starting to get a little desperate to understand this now. My confusion is about multiple tables - master/detail in particular. ...
Score The TableAdapter update command is not identical
ad - 4 Apr 2006 9:09 PM - 3 messages
I am using vs2005 to desginer a tableadapter. I have modify the update command in the desginer, but the update command is not identical between the desginer. For example: The original update command is: Update Employee set EmployeeID=@EmployeeID and EmployeeName=@EmployeeName ...
Score What transaction IsolationLevel for?
David Thielen - 4 Apr 2006 8:21 PM - 5 messages
Hi; What IsolationLevel is best for transactions for the following (by sub-row I mean a pk:fk to a second table that has N rows in the second table that "belong" to a row in the first table): 0) A select for a single row and it's 0 - 5 sub-rows. ...
Score Pseudo code for updating Access db using VB and ASP.NET
glenn - 4 Apr 2006 7:39 PM - 2 messages
Hi folks, I have been hunting for a code snippet to update an Access db using VB and ASP.NET.  So far, nothing that helps me.  I am using OleDb libraries. Can anyone provide me with the general steps or calls involved.  Here is ...
Score Help - Timeout when updating 190 million row table
Mori - 4 Apr 2006 7:31 PM - 1 message
I am using a web service as my data access tier and trying to update several (43) related tables in an Oracle data warehouse.  The problem is that one of the tables has over 190 million records.  the field being updated is one of ...
Score Re: Help: Login failed for User ???
Jim Hughes - 4 Apr 2006 7:23 PM - 2 messages
SQL Server operates in WIndows Auth or Mixed, sounds like yours is Windows Auth only. Mixed allows both trusted and userid specific. You don't specify the password for Windows users, the domain credentials that are obtained when the user logs in with their domain username and ...
Score Re: Mixing System.Data.OleDb calls with System.Data.SqlClient calls ??
Jim Hughes - 4 Apr 2006 7:10 PM - 1 message
Not in this scenario. SQLCommand and SQLParameter are specific to Microsoft SQLServer. For Access, you will want to use OleDBCommand and OleDbParameter. You can have a SQLConnection and OleDBConnection in the same class, each connecting to the appropriate database type. ...
Score Dataset Extended Properties (msprop:* in xsd)
Ian - 4 Apr 2006 2:13 PM - 1 message
I found reference to these in several places.  First on MSDN, with little explanation (<[link](VS.80).aspx>) and then with slightly more information (<[link],1895,1844601,00.asp>). ...
Score SqlConnection.open() slow in 2.0
Peter Chapman - 4 Apr 2006 1:58 PM - 4 messages
Hi I have been using the SqlConnection class in version 1.1 for a while with no problems.  I have now converted my code across to version 2.0 and the open is now incredibly slow.  The exact same code takes 20 seconds to open the ...
Score Help: Login failed for User ???
Michael - 4 Apr 2006 1:38 PM - 7 messages
Please Help me. I've got a .Net 2003 program that attaches to a SQL Server machine and I'm getting the above error when a user tries to log in. The SQL server is setup to use Windows Auth. and I have added the new user to the ...
Score Custom ADO.NET Data Provider from MFC legacy DAL?
TC - 4 Apr 2006 1:21 PM - 2 messages
Background: We have a legacy DAL which was written for our MFC applications. It accesses one of two databases depending upon what data the client needs (Oracle or Sybase). It returns a CRecordset derived class to the client, so depending ...
Score Large Datasets
Bernie Hunt - 4 Apr 2006 12:01 PM - 16 messages
Has anyone seen any documentation or white papers with suggestions on how to handle large datasets. My task is to read in 10K records and then step through each one processing it's data. The processing involved fetching 3 other records that match the current, manipulate the data and then write ...
Score Insert all rows from datatable to database
ypul - 4 Apr 2006 10:35 AM - 3 messages
How can Ido this ? I have a datatable/ dataset, which has rows with data in it. I want to bulk insert all rows from the dataset to database table (having same table structure). what is the best way, with out looping through everyrow and inserting into ...
Score UpdateParameters
bill tie - 4 Apr 2006 9:13 AM - 3 messages
I'm exploring Microsoft sample code.  This is a master/detail scenario with two SqlDataSources.  The master table shows Northwind.Customers data.  In the detail table, I can massage a row of data selected from the master table. ...
Score Save data table to binary file?
mtczx232 - 4 Apr 2006 6:55 AM - 7 messages
I have some project that use with DataTable like simple DB. I need a solution for save the DataTable to binary file, with ability to Append only new record. I looking for code that Implement simple providor or save method that ...
Score CommandTimeout, ConnectionTimeout, httpRuntime executionTimeout (ASP.NET 2.0)
Piotrek - 4 Apr 2006 6:43 AM - 1 message
Hi all. I would like to know what is the difference between these two timeouts: - CommandTimeout - ConnectionTimeout I have following setting in my web.config file: <httpRuntime executionTimeout="60"/> Which timeout does it set (command, connection or other)? ...
Score Access ObjectDataSource data from asp.net codebehind
Jeronimo Bertran - 4 Apr 2006 2:25 AM - 6 messages
Hello, I have a web page that uses two ObjectDataSource controls to bind data to a FormView and a grid . In my grid which is bound to ObjectDataSource2, I want to add in the footer information from certain fields from the first ObjectDataSource.  I am ...
Score Binding Checkboxes to MySQL
jwitt - 4 Apr 2006 2:14 AM - 2 messages
Ref: WinXP, MySQL 5.0, C# How to bind a CheckBox to a Boolean column (TINYINT(1)), or to any type of MySQL column for that matter? Thanks, Jim ...
Score Oracle Read/Write
Jim Heavey - 3 Apr 2006 8:52 PM - 1 message
I am having an issue where I have a Data reader which contains the records to process and I loop thru this data reader until all rows are processed.  Within that loop, I have a call to an Oracle stored procedure which, among ...
Score Return a parameter count from a SQL Stored Procedure
goldbond_8 - 3 Apr 2006 8:49 PM - 4 messages
I would like to use ADO.Net to connect to a Stored Procedure in SQL Server and return a count of parameters from it.  I was able to do this using ADO and VB 6 using the following code: ...
Score Will sql express 2005 and Studio 2003 work together?
David - 3 Apr 2006 8:36 PM - 4 messages
Will sql express 2005 and Studio 2003 (.net 1.1) work together?  I can not find a definitive statement on the Microsoft site and need to change a 1.1 app and wish to use the newer 2005 express.  ...
Score <<< Connection Problem with SQL Server + C#.Net on Local Area Network >>>
gndzkdr@gmail.com - 3 Apr 2006 7:12 PM - 2 messages
hi all, i m new on Sql and i have a project related to C# and Sql. i have to do a project which must work on LAN, and there must be only one database file on main computer(Server Computer) and other ...
Score Number Formats
Vayse - 3 Apr 2006 5:23 PM - 8 messages
I want to display numbers with a comma between every 3 digits, with no decimal places. I've tried Const conFORMAT As String = "###,###,###" Me.CashTextBox.Text = Format(drEconomy("Cash"), conFORMAT) Which displays fine in general. For example:  999,817 will come out fine ...
Score DataSet.HasChanges question - get a collection of columns changed?
Andre Ranieri - 3 Apr 2006 4:58 PM - 2 messages
Hello, I'm wondering if it's possible in .NET 1.1 to enumerate a list of individual columns that are changed when a datarow has been flagged as changed.  After I update the row back to the database, I also need the ability to write logging ...
Score DataTable performance
pinhead - 3 Apr 2006 12:52 PM - 5 messages
Just a question on performance. I'm building an .Net2 web application. At present we've got very few users and the web app flies along. All the data access is performed through a DAL and most of the data is ...
Score Insert Statement somtimes works
rickn - 3 Apr 2006 12:28 PM - 2 messages
I'm doing an Insert from ODBC dataset into an OLE access table, the Insert for multiple rows doesn't work, but if I do an Insert using the commented out statement below it works just fine. What is wrong with ...
Score How to connect to Sql Express by ip address?
MagicMax - 3 Apr 2006 10:03 AM - 2 messages
Good day! Is anybody know how to connect to remote Sql Express by IP address from C# program (main question is how to build connection string)? I have to use Ip address instead of server name. I make some tests and ...
Score Article on DataBinding in Windows form using VB.Net
ammulu - 3 Apr 2006 5:42 AM - 1 message
Hi All, See this link http//[link] for Article on DataBinding in Windows form using VB.Net. Regards Bhar ...
Score Serialize a dataset as xml
Arne Garvander - 3 Apr 2006 12:41 AM - 2 messages
How can I serialize a dataset as XML and send it back to the browser? I would like to avoid a web method. ...
Score Hiding child rows in a datagrid
al - 2 Apr 2006 1:13 PM - 3 messages
Hi, Is there any way of hiding child tables/rows in a windows form datagrid. I'm using Vb.net and Visual Studio 2003. thanks in advance alan ...
Next »