Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Refresh Binding Navigator Upon Row Delete
Alex - 28 Apr 2007 9:31 PM - 3 messages
I'm having a problem with the binding navigator on a form in that it won't reflect the results of a deleted record.  The binding source is a single table bound to a sql db as its data source.  When I call the ...
Score ConnectionString parameter and Dataclass library
Frederic_D - 28 Apr 2007 7:00 PM - 2 messages
Hello i created my data access layer in a class library (a dll), i referenced this dll in my project. When i deploy my solution i can access to the app.exe.config file, but i don't find the config file of my dataclass.dll. ...
Score polling a database
Pascal - 28 Apr 2007 4:45 PM - 4 messages
Hi everybody, a suggestion, please. I have an application A that modifies the records of an access database. I should write an application B (running on the same machine) that monitor these changes, without modifying application A. I think the only solution is polling the ...
Score Persistent settings
John - 28 Apr 2007 1:13 PM - 3 messages
Hi I need to store the path to db in my app. I have used app setting for this. Unfortunately various clients have different db paths and I have set them up once on each client location. The problem is that when I send them updates ...
Score Persistent settings
John - 28 Apr 2007 1:12 PM - 1 message
Hi I need to store the path to db in my app. I have used app setting for this. Unfortunately various clients have different db paths and I have set them up once on each client location. The problem is that when I send them updates ...
Score ADOX in VISTA not available??
ChaoTix - 27 Apr 2007 10:37 AM - 6 messages
Hi All, I am using VB.NET 2005 on Microsoft Vista. I have opened a project in VB.NET and when i try to run it, it will cause a error on the adox. Here is my Source: Public Function CreateAccessDatabase(ByVal DatabaseFullPath As String) As Boolean ...
Score DataTableDataView, how do I use dataview to show only 3 fields on the grid
aboutjav.com - 26 Apr 2007 11:54 PM - 2 messages
Hi, I am getting a datatable which I assigned the dataview as MyDataView = datatable.view; the datatable has about 7 - 10 fields. I only want to display 2 fields on my wingrid, like name and description. How do I user dataview to filter out the rest of the columns? ...
Score SQLCommand ParameterDirection.ReturnValue not what it was
Tom Garth - 26 Apr 2007 11:46 PM - 5 messages
With classic ADO you could attach a ReturnValue parameter to a command containing inline parameters. Ex: Cmd.CommandString = "PubsInsert('G. B. Shaw', 'I lost my Rifle')" Dim pRET As New ADODB.Parameter       pRET.Type = adInteger ...
Score TableAdapter UML Diagram
Arturo - 26 Apr 2007 6:46 PM - 1 message
Can anybody help me find a UML diagram that shows how the TableAdapter, DataSet and Database interact in ADO.NET ...
Score stored procedure with varchar(max) output parameter
Andrew Robinson - 26 Apr 2007 5:53 PM - 3 messages
I have a stored proceedure that has a varchar(max) output parameter. How do I specify my size value in the parameters collection? or is this something that cannot be done? Thanks, ...
Score telling if a transaction is open on a connection?
Smokey Grindle - 26 Apr 2007 5:30 PM - 1 message
is there any way to check if a transaction is pending on an open connection? (not committed or rolled back transaction) ...
Score Table Adapters
Arturo - 26 Apr 2007 5:00 PM - 1 message
I would like to get a UML diagram that shows how the Table Adabpter, Dataset, and Databse Server, interact with each other. Does anybody know where I can find such a diagram? ...
Score Multi select stored proc and strongly typed data sets
Amir Tohidi - 26 Apr 2007 4:40 PM - 2 messages
Hi I have a stored proc that has two select statements in it i.e. it returns 2 result sets. When I try to use the Visual Studio DataSet designer and point it to this stored proc, it only sees the first select of the sp and therefore only ...
Score Unable to Connect To Sql Server 2000 using .NET 2005 EXPRESS
Terrance - 26 Apr 2007 3:14 PM - 3 messages
Can anyone help me with an issue. I have a .net app that tries to connect to my sql server here on my laptop on my company's network. When I have someone on the network try the app they get the following message in the errorlog: ...
Score Accessing Linked Servers via ADO.NET
michael - 25 Apr 2007 8:24 PM - 3 messages
I have a SQL Server 2005 instance. On it are a bunch of databases and a linked server. ADO.NET easily accesses all the named databases on this server. However, I would like to access data through a linked server on the ...
Score Extra Row Added to Table
Ken - 25 Apr 2007 5:34 PM - 2 messages
Whenever I run this code, I get a row added to my table in the primary field whose text is "System.Object".  This code is intended to simply add a single row to a single table.  Anybody see why this is happening and what I need to ...
Score Null Reference Exception In System.Data.OracleClient Method?!
s_valmont - 25 Apr 2007 4:39 PM - 1 message
Hi all, I'm having issues connecting to an Oracle 9i database using ASP.NET 1.1.  The following sequence causes a problem: - webpage A logs an entry in the DB - webpage A opens webpage B which updates the first entry ...
Score Decimal SqlParameter strange behaviour
mikicaradojcic - 25 Apr 2007 12:56 PM - 2 messages
I've created SqlParameter with precision = 15, Scale =2 and name = @param1. I added it to command which text is: Begin SELECT * FROM TABLE WHERE VALUE < @param1 END if I put param .Value = for example 99.99d it works. ...
Score Provider independent data access: problem with Excel ODBC source
Jim Walsh - 24 Apr 2007 3:48 PM - 4 messages
VS2005 I have an application that is used by a variety of users. The application analyzes some data and writes the results into a database. Different users use different databases, and sometimes the same user will use a different database at different times. ...
Score Re: Asynchronous calls to sql server 2000
dkil1972 - 24 Apr 2007 1:24 PM - 1 message
...
Score Failed to enable constraints.
Bryce - 24 Apr 2007 1:13 PM - 2 messages
I have googled and see this is a common issue, but for some reason I can't figure this out. I have a typed dataset, and have created a Query called "GetDataById(@id)" I call it like this: VerificationForm.VerificationFormDataTable table = ...
Score Url reqriting with friendly text urls
anthonykallay - 24 Apr 2007 6:52 AM - 1 message
Hi there, I am trying to rewrite my url's for SEO purposes and have read this great article below [link] I can follow all the steps but all it really tells me is how to go ...
Score Timeout or other timing-type problem???
fuzz_ball - 24 Apr 2007 1:57 AM - 5 messages
So I'm experiencing an odd problem. I establish a connection and enlist in transaction and then save my dataset changes to the database. My dataset contains 20+ tables that get updated, and I have my code setup to handle inserts/modifies/deletes in the correct ...
Score DbDataAdapter.Fill() - just the first row
David Thielen - 23 Apr 2007 11:42 PM - 10 messages
Hi; Is there a database independent way to fill just the 1st row of a DataTable? ...
Score IDbConnection + select -> DataTable
David Thielen - 23 Apr 2007 11:28 PM - 5 messages
Hi; This should be possible but I can't figure out how to do it other than reading each row and stuffing it into a table. I have an IDbConnection and the select - no other info. I need a DataTable ...
Score ORA-00904 while using update
sjoshi - 23 Apr 2007 9:32 PM - 2 messages
I'm trying to use this simple code to update an Oracle table and it fails with this message: Oracle.DataAccess.Client.OracleException : ORA-00904: "MINDEX": invalid identifier The Select command works fine. OracleConnection con = new OracleConnection("Data Source=SP3DSMP2;User Id=sys;Password=xxxx;DBA Privilege=SYSDBA;"); ...
Score Integrated Security
Arne - 23 Apr 2007 8:46 PM - 2 messages
integrated Security= true or Integrated Security=SSPI Does the above mean the same thing in a connection string? ...
Score Asynchronous calls to sql server 2000
dkil1972 - 23 Apr 2007 7:43 PM - 4 messages
In upgrading an application to .Net 2.0 from 1.1 I had an opportunity to implement some asynchronous calls to the database. In the application there is a quick search facility that makes 6 calls to 3 different database. This I thought was the perfect scenario for ...
Score Can you precompile a desktop app?
the_grove_man@yahoo.com - 23 Apr 2007 5:18 PM - 4 messages
I read an article that you can procompile ASP.NET to speed up initial response time for users since pages do not have to be compiled the first time they are requested. [link] ...
Score SQL Server connection Pool error in Debug
Jerry J - 23 Apr 2007 1:24 PM - 4 messages
In my ASP.net application I am getting the following error... "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occured because all pooled connections were in use and max pool site was reached". ...
Score how to count hierarchical data from database?
vchaturvedi23 - 23 Apr 2007 10:37 AM - 3 messages
hellow frnds, i hv a form of vb.net with SQL2000 connection, how can i count the hierarchical data from database. eg. every customer hv a id and each customer hv two downline id left downline and right downline(either one of them will hv value or both ...
Score Problems with SQL server
Toni - 23 Apr 2007 7:07 AM - 16 messages
I have some program in VB6 (I can make new in .NET if it is necessary). This program is working with SQL Server 2000 database from long distance (computers are in agencies and is connected to DSL and VPN connection). ...
Score Forms and Labels
Allen Maki - 23 Apr 2007 2:20 AM - 1 message
I wonder if you could help. The event handler code below, will allow the user to change the phone number and write it on a label of a message box. I want to replace the message box with a dialog box. ...
Score Nested TransactionScope
David Morris - 22 Apr 2007 4:34 PM - 7 messages
Hello, I am trying to set up some nested transactions to speed up a group of unit tests. The unit tests call a common method to build up some test data, which takes about 30 seconds and then runs a specific test. Each C# unit tests has ...
Score Referential update error with DataSet
Flomo Togba Kwele - 22 Apr 2007 2:05 AM - 4 messages
I get an error when executing the Update method on a dataset. The dataset is a strongly typed one, with two tables in a parent/child relationship. The parent has an identity column for its PK, while the child's PK is a ...
Next »