Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Datagrid and moving to a specific record
steven scaife - 2 Sep 2006 9:08 PM - 2 messages
I have a problem in a site i am developing.  I have a search page that when results are found are bound to a datagrid.  The datagrid displays the product code and the product name.  The product code is a hyperlink to another page ...
Score GetGuid from OracleDataReader
sjoshi - 1 Sep 2006 6:36 PM - 3 messages
Hi All It seems I can't use this to get Guid from OracleDataReader int iOid = oRdr.GetOrdinal("OID"); while(oRdr.Read()) { // Guid theOid = oRdr.GetGuid(iOid); //This fails in Oracle Guid theOid = GetGuidFromRAW(oRdr.GetValue(iOid)); } I have to use this kludge instead: ...
Score 1 Gig DataSet Limit Regardless of available physical memory?
ifitwaseasyidbebored - 1 Sep 2006 4:28 PM - 13 messages
Can someone tell me if there is a limit to the memory size of a dataset running under framework 1.1 please? The file size would normally be around 250-300MB but it baloons by 3-4 times as it is in a dataset - this is fine, I understand this. ...
Score Export/Import XML Files
Mike - 1 Sep 2006 3:58 PM - 1 message
I am trying to export data from multiple tables in SQL Server to an XML file so I can then import it to another database. It seems to be working fine for exporting, but I am having trouble importing the file. Can someone show me ...
Score Exporting/Importing XML Files
Mike - 1 Sep 2006 3:34 PM - 1 message
I am trying to export data from multiple tables in SQL Server to an XML file so I can then import it to another database. It seems to be working fine for exporting, but I am having trouble importing the file. Can someone show me where I am going wrong. Even though I say the export is working, I am including it below in case there is something in there that needs to be changed. Also, the code I am including is VERY rough right now and will ...
Score How to pass GUID as OracleParameter
sjoshi - 1 Sep 2006 3:13 PM - 1 message
Hello all I'm passing a GUID as an Oracle Parameter using this : sqlParm = new OracleParameter(); sqlParm.ParameterName = prm.ParamName; sqlParm.OracleDbType = OracleDbType.RAW sqlParm.Direction = prm.ParamDirection; sqlParm.Size = 16; sqlParm.Value = ((Guid)prm.ParamValue).ToByteArray(); cmd.Parameters.Add(sqlParm) ...
Score DataReader and Master-Detail
Christian Schmidt - 1 Sep 2006 2:42 PM - 12 messages
Hi all, I need to work through a master and its details table. My first attempt was to open a DataReader on the master and for each record get a new DataReader on the detail, restricted to the foreign key. But this is ...
Score Packet Size in Connection String
Phenglai - 1 Sep 2006 2:03 PM - 1 message
Hello everyone, I have a question about the Packet Size option in the Connection string. The default is 8192 and I see people using 4096 as well. My question is, doesn't that seem a little high if you are going over an ...
Score MaxPoolSize - Recommendations
hrabia - 1 Sep 2006 12:10 PM - 5 messages
I'm testing now a third part web application (ASP.NET 2.0, MS SQL Server 2005) that seems to work properly but creates up to 400 (sic!) connections for average 80 concurrent users. The application is pretty straightforward: login, some grids with data and that’s it. In my opinion (I’m an experienced ...
Score Bug with DataColumn.AutoIncrementSeed
AxelHecker - 1 Sep 2006 11:42 AM - 2 messages
Hi! I think I found a bug with DataColumn.AutoIncrementSeed. I tried to communicate it via the Microsoft Feedback center, but after about half an hour of trying to get through the feedback process without webforms breaking down, I gave up. ...
Score DataSet and Cascading Question
Gary Howlett - 1 Sep 2006 11:03 AM - 1 message
Hi, Im using c#, VS 20005 and SQL 2005 I have a DataSet with 3 ralated tables Cases->Clients->Addresses I have in my SQL server 2005 a diagram with relations that say Cascade updates and deletes. In my strongly typed data set ive also added the 3 ...
Score Creating a database on the fly
Adrian - 1 Sep 2006 8:57 AM - 2 messages
I have an application using SqlServer2005 Express (The user will have installed SqlServer2005 Express, and have entered the name under which the database has been installed as a parameter.) How can I code the required database being created in his ...
Score Mit ADO.NET auf cdb Files zugreifen
Norbert_Pürringer - 1 Sep 2006 8:14 AM - 2 messages
Hallo Leute! Gibt es eine Möglichkeit, mit ADO.NET auf cdb Files zuzugreifen, die sich auf einem Windows Mobile 5 System befinden? Gruß, Norbert ...
Score BindingNavigator and DataGridView synchronization
herbert - 1 Sep 2006 7:53 AM - 1 message
1. The BindingNavigator and DataGridView generated by drag&Drop databinding is misterious to me. Eg when starting the code and loading an empty DB table, you get an empty row. If you do not select it and press the DeleteItem button in ...
Score Send Mail Problem
Max - 1 Sep 2006 7:36 AM - 1 message
hi I used mailmessage object to send the mail, my smtp server don't require authentication, when i try to send the mail it shows error. following is the code to send mail. Dim mymail As New MailMessage         Dim smtp As SmtpMail ...
Score Reverse the Day and Month position in DateTime structure?
pedestrian via DotNetMonster.com - 1 Sep 2006 5:38 AM - 6 messages
I'm programming ADO.NET WinForm app. I retrieve data from database, save it to DataTable(s) and show it to user. My country use the date format : Day/Month/Year. I intend to show the user the Date field in the ...
Score DataBase Refresh
stix - 1 Sep 2006 5:04 AM - 2 messages
I have a stored procedure in which I basically copy the schema from one table into a temporary table. Select * into dbo.myNewTable from dbo.myoldtable where 1 = 0 The problem is that when I goto alter that table to add the Primary key to ...
Score Data binding combo box to a datagrid
John Harcourt - 1 Sep 2006 1:17 AM - 4 messages
I have a dataset with two data tables. I created a data relation object to join the two tables by a common field. On a Windows form, I set up the data binding to a combo box for the first table. This is the "master". I set up the data binding for ...
Score Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no
scott mcfadden - 31 Aug 2006 11:08 PM - 2 messages
We use ADO.NET / SQLProvider against SQL2000 for our web application.  We have started to see more and more of these errors: Exception Type: System.Data.SqlClient.SqlException Errors: System.Data.SqlClient.SqlErrorCollection Class: 10 LineNumber: 0 Message: Timeout expired. The timeout period elapsed prior to completion of ...
Score performance tableadapter access update
John - 31 Aug 2006 7:05 PM - 4 messages
Hi I am working with an access database with more than 25000 records (adresses). In vb .net  i use the tableadapter and it takes a long time to read all the records (with access it doesnt take much time). ...
Score Why can't I create a DataGridView whose datasource has > 1 table
Juan Dent - 31 Aug 2006 6:11 PM - 4 messages
Hi, I am working inside the DataSet designer. I have 2 tables related by one relation and FK. Both tables have been configured to be updatable (insert,update,delete methods generated). All this is nice. Yet, I need to display a join of these tables selecting ...
Score AcceptRejectRule - what does it really do?
Juan Dent - 31 Aug 2006 5:59 PM - 2 messages
Hi, How does  AcceptRejectRule differ from Update rule and Delete rule? ...
Score NewRow, RowState, and Detached with a CommandBuilder
Andy - 31 Aug 2006 5:09 PM - 2 messages
Hi folks, I'm using the ADO.NET 1.1 framework and have this ADO.NET dataset I want to use to add and/or update records on the physical SQLServer table it came from.  I am using an ADO.NET commandBuilder to ...
Score How to refresh datatable from datasource
alfred.sehmueller - 31 Aug 2006 4:43 PM - 6 messages
Hello, in a network-winforms-application based on a access database I've got the following problem: user A starts software user B starts software user A deletes row in db user B changes data application of user B makes an update dataadapter.update(datatable). ...
Score ADOCE Connection with OLEDBConnection
Norbert_Pürringer - 31 Aug 2006 2:49 PM - 1 message
Hello! Is it possible to use an OLEDBConnection object to connect to a Pocket PC access database (ADOCE.Connection)? Does someone has a code sample for me? Regards, Norbert ...
Score Setting a breakpoint in sql server 2000 stored procedure from VS2005
Adrian Parker - 31 Aug 2006 2:23 PM - 8 messages
Using.. Visual Studio 2005 Team Edition for Software Developers SQL Server 2000 sp4 (on same machine) Net.Framework 2.0 Windows XP (up to date with all patches) Problem.. I'm trying to debug a stored procedure from within visual studio but when I ...
Score DataSet schema validation
andrew - 31 Aug 2006 1:49 PM - 1 message
What is validated when you load data into a DataSet that is associated with a schema?  When I load in data I get errors if I try to put data of the wrong type in a row item... but I don't get an error when I add multiple rows to a ...
Score .NET2.0: Microsoft, you got something very wrong in data validation..
mcw8 - 31 Aug 2006 12:51 PM - 5 messages
Even Microsoft's own data-validation walkthrough article ([link]) recommends attaching a handler to the RowChanging event of the DataTable The problem is, that when editing a row, the RowChanging is raised ...
Score Sorting
Adrian - 31 Aug 2006 10:05 AM - 9 messages
When I sort a number I get a lexicographical sort 1 11 112 1 12 How can I code a sort that will produce a proper numerical order? Adrian. ...
Score Visual Studio 2005 and Access database mystery
surfrat_ - 31 Aug 2006 9:26 AM - 19 messages
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft page "How to: Connect to Data in an Access Database" ...
Score Data Access Layer and Business Logic Layer in ASP.NET 2.0
asad - 31 Aug 2006 7:16 AM - 2 messages
Hi friends, how ru all, I have a question about creating Data Access Layer and Business Logic Layer using ASP.NET 2.0 and VB.NET, which is the best way, and what is that best and optimized solution for creating DAL and BLL. ...
Score Connecting to Oracle Database.
LineVoltageHalogen - 30 Aug 2006 6:49 PM - 3 messages
Greetings All, I am writing a small test app in C# .Net 2.0 that needs to connect to an Oracle 10g database.  I need to use Microsoft's data provide System.Data.OracleClient to connect to the database and I need ...
Score Help with Output Parameter Statement
Stephen Lynch - 30 Aug 2006 6:09 PM - 6 messages
All: I am running a stored procedure via code but need help with the sytax for the output parameter as mine is wrong, Sorry, but I am just learning. Here's my incorrect section, more is listed below:                 OleDbParameter parameterContributionID = new ...
Score why ever use structs vrs. classes?
Juan Dent - 30 Aug 2006 5:58 PM - 5 messages
Hi, I have a hard time recalling what was the basic rationales for using structs instead of classes in a C# program. Could anyone point out the reasons? ...
Score ADODB and .Net
rclowser - 30 Aug 2006 4:27 PM - 3 messages
I developed a .Net website for Windows 2k3, but the webhosting team doesn't have a 2k3 environment ready to go. So I want to still push my .Net site, so I'm attempting to get the site to run on W2k that is already set up. I'm ...
Score UDL in ADO.NET
Anders Eriksson - 30 Aug 2006 12:23 PM - 6 messages
Hello! In ADO the preferred[1] way of specifying the connection string was using an .UDL file. What is the preferred way to do this in ADO.NET? // Anders ...
Score Closing a connection returned from separate class
Ross - 30 Aug 2006 11:08 AM - 4 messages
Hi I have a solution - just a test one - where  there are two projects.  One is a simple windows form with a text box called txtClient & a command button. The command button eventually calls a SP that has a parameter @ClientName. ...
Score Question about SqlCommand.Parameters.Add() method.
pedestrian via DotNetMonster.com - 30 Aug 2006 7:44 AM - 6 messages
I'm currently programming an ADO.NET application for SQL server. I notice that the SqlCommand.Paraterers.Add() method require 4 parameters which are parameterName, SqlDbType, Size, and SourceCOlumn. The question is with Size parameter: What is the corrent Size value for SqlDbType.Int, SqlDbType.Money and ...
Score ADO.Net vs Sybase
pimbos - 30 Aug 2006 7:06 AM - 1 message
I am trying to make a consoletool for executing commands. This is de code I use for reading the result Result = mDnIsqlProcessor.ExecuteReader(SqlCommandRow); do { while (Result.Read()) { // Show Header aRow = new StringBuilder(); for (counter= 0; counter< Result.FieldCount; counter++) ...
Score Concurrency violation at update
John - 30 Aug 2006 6:50 AM - 13 messages
Hi I had a working vs 2003 application with access backend. I added a couple fields in a table in access db and then to allow user to have access to these fields via app I did the following; 1. Regenerated the data adapter sqls by running the data adapter wizard and ...
Score System.Tranasctions Question
KA Kueh - 30 Aug 2006 3:10 AM - 1 message
Dear all, I have a question with regards to Informix-Net Client SDK. Does informix support the new system.transaction from the framework 2.0. Thanks. regards, Kueh. ...
Score Inserting records from a DataSet into a second table
Gordon - 30 Aug 2006 2:30 AM - 2 messages
Hi; This has me confused. I have a dataset which was populated from one database. Can I insert this dataset's rows into a different database table using the same dataAdapter or would I have to create a second adapter? ...
Score SQL Parser
Joe - 29 Aug 2006 11:18 PM - 5 messages
Are there any decent parsers around that can parse SQL? I'm looking for something that can validate the syntax and also allow access to the columns and tables from the select and where clauses? Thanks for any help, Joe ...
Score CLR2 VS2005: HowTo add a duplicate key to DataTable
PGC - 29 Aug 2006 8:23 PM - 1 message
Hi, For example; Table1 contains UniqID    Int not null (PK) ACode    string not null, BCode    string not null, CCode    string not null In the DataSet designer, can I make a composite duplicate key of ACode + ...
Score HELP: can't stop using Named Pipes!
Matt C. - 29 Aug 2006 5:07 PM - 2 messages
I have deployed a test application (VS 2005) to several workstations.  They need to make a connection to our SQL Server 2000 server.  Most work fine.  On one workstation, we keep getting the error: "An error has occurred while establishing a connection to the server.  ...
Score CommittableTransaction leaves open transactions on server?
Patrik Rosquist - 29 Aug 2006 3:45 PM - 2 messages
System.Transactions: TransactionScope and CommittableTransactions leave open transactions on server. I'm having problems with commited or rolled back transactions leaving open transactions on the database server. The problem is on our web site using .Net 2.0, Windows 2003 server, SQL ...
Score .NET 2.0: ParentBindingSource.EndEdit() causes relation to ChildBindingSource to fail
mcw8 - 29 Aug 2006 3:27 PM - 1 message
keywords: BindingSource master detail parent child datarelation related data endedit problem disappear vanish lost I've hit a problem working with related data and typed DataSets. *I have 2 tables called (for want of better names) Parent and Child *The two tables are related with a DataRelation+FK on Parent.ParentID = ...
Score Name change, can't find origin of error
jamesn - 29 Aug 2006 3:00 PM - 9 messages
I've recently made a name change on a few database tables.  I thought I got all the name changes done in the front end reference.  However, this one eludes me.  I've checked all the classes listed in the error ...
Score DataTable.Select problem in ASP.NET 2.0
manoj241176 - 29 Aug 2006 12:48 PM - 2 messages
Hi,   I am having problem with DataTable.Select() method. I am using ASP.NET 2.0. I have DataSet which reads data from XML file using DataSet.ReadXML(). Now this dataset has various datatable, created by XML file. I am taking one of ...
Score RE: Data Adaptor error VB.Net 2003 SQL 2005 - SOLVED
DaveG - 29 Aug 2006 11:35 AM - 1 message
Some while ago I posted with the problem that when I drag a table or use the Wizard VB.Net 2003 does not create all the required components for the data adaptor to function correctly. Update, Insert & Delete statements were not created. ...
Score OleDbException: Could not update; currently locked
Luke Neumann - 29 Aug 2006 9:41 AM - 6 messages
Hello, I have a standalone windows application that uses MS Jet 4.0 to read and write from MS Access database. Rather randomly, I keep getting this exception: System.Data.OleDb.OleDbException: Could not update; currently locked. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 ...
Score What is wrong?
Adrian - 29 Aug 2006 8:00 AM - 5 messages
In the line marked *** "one" etc are not allowed. Please tell me why and what I should do to make this code work. Many thanks. Adrian. try { while (carry_on == true) {         string one = binR.ReadString(); ...
Score Oracle newbie questions
David Thielen - 28 Aug 2006 11:12 PM - 5 messages
Hi; I know SqlServer well but Oracle is new to me. I have a couple of questions as I get started: 1) Is there a sample somewhere of how to connect to OracleExpress on a remote computer and do a simple select. In other words the bare minimum to ...
Score DAO, SQL Server 2005, and VB6
Marcus - 28 Aug 2006 8:26 PM - 9 messages
I have some legacy VB6 code that uses DAO (Microsoft DAO 3.6) to access an access 2000 database. In this app, Access is used soley for data storage - there is no UI component. I have converted the database to ...
Score DataMember property 'ContractID' cannot be found on the DataSource
Bart - 28 Aug 2006 8:09 PM - 8 messages
Hi, I get above error when I use the find function on a bindingsource control. The datasource member of the bindingsource  is another bindingsource control, where the datamember is a relational member of the datasource The field I'm searching on is absolut in the table behind, I can browse to ...
Score Enterprise Library June 2006
rockdale.green - 28 Aug 2006 4:50 PM - 2 messages
hi, I just downloaded Microsoft Enterprise Library June 2006 and try to integrate it into my asp.net application. As i am going to connect to mySQL database, I need to include the source code in my project so that ...
Score Looping through data adapter
John - 28 Aug 2006 4:11 PM - 4 messages
Hi I have a data adapter bound to a table. How can I loop through the table via and access each record's column values on the way? Thanks Regards ...
Score Books You Like
Dave T - 28 Aug 2006 2:51 PM - 4 messages
Do you all like any books ... particularly VB 2005, VS 2005, WinForms, ADO.net?  There are so many, I can't see the forest for the trees! ...
Score Question about testing for returned values
Chicagoboy27 - 28 Aug 2006 2:13 PM - 10 messages
Sorry if this is a basic question but I was wondering how to test the data being read back from a database. I am using a datareader currently and am not sure if that is the best route.  In classic asp it went ...
Score is it possible to call an oracle function in .net
reju - 28 Aug 2006 10:23 AM - 2 messages
I have to use either sql server or oracle databse in my application. The front end application in vb.net. ...
Score tableadapters, where is my concurrency exception?
troy@makaro.com - 28 Aug 2006 6:11 AM - 22 messages
Hi, I wrote a very simple program to test concurrency with sql server 2005. I used the VS 2005 dataset designer wizard to create my dataset and and tableadapter. When I ran the program, I used the debugger to stop the code before the ...
Score Manipulating data between data adapters
John - 28 Aug 2006 4:31 AM - 4 messages
Hi I have two data adapters bound to two separate tables. How can I; 1. Loop through all records one by one in one of them while reading column values, and 2. Insert a record from data adapter A into data adapter B ...
Score Do People Us Bound Web Controls?
Jonathan Wood - 28 Aug 2006 12:51 AM - 3 messages
I was just curious if most people were using data-bound Web controls to display data rather than just display the info via code. I recall that old Visual Basic used to have bound controls but they weren't very good and no self-respecting programming made much use of this. I hear ...
Score No Trusted SQL Server Connection
Jonathan Wood - 27 Aug 2006 10:36 PM - 4 messages
I'm a programmer but not a database administrator and really don't want to be either. After a fair amount of reading and many problems related to SQL and related stuff, I finally figured out how to create a database in Visual Studio and ...
Score Best Way To Handle Data Relations
corey.burnett - 27 Aug 2006 7:33 PM - 5 messages
I am writing an ASP.NET application that uses SalesForce data as the back end.  SalesForce has a web service that exposes the data in their system.  Unfortunately the ways that you can select data are very rudimentary.  There is no way to do a join between tables in SalesForce ...
Score Problems Setting Up Database
Jonathan Wood - 27 Aug 2006 6:01 PM - 3 messages
I seem to be having errors creating and accessing an SQL database. Unfortunatley, I am brand new to SQL setup and administration issues so this really is not my area of expertise. I know I had to install some type of IIS component to run databases from ...
Score accessing mysql
Shiplu - 27 Aug 2006 3:25 PM - 3 messages
What is fastest way of accessing mysql by ado.net ...
Next »