New to the VS.NET 2005 and I am writing a program using an access database as the datasource in visual studio.NET 2005 The problem I have is I am trying to write a parameterized query where a wildcard can be used to pull a complete name from only one or two characters entered. If I have the exa...more >>

Hello all... Here is what i want to do (in VB code)... <code> Dim SQL As String = "SELECT ROWID FROM (INSERT INTO STATIC_CONTENT (NAME, CONTENT) OUTPUT INSERTED.ROWID SELECT 'Contact Us', '') SRC" Dim newId As Integer myDbObject.ExecuteScalar(SQL) </code> Assume that myDbObject has alr...more >>

Using ASP.NET 2.0 with SQL Server 2000 Inside my dropdown list box I am using an SQL DataSource to select the following data SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact, c.phone As PriPortPhone FROM mppaContacts c Dropdown list box wor...more >>

Using ASP.NET 2.0 with SQL Server 2000 Inside my dropdown list box I am using an SQL DataSource SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact, c.phone As PriPortPhone FROM mppaContacts c Now I am trying to UPDATE the table name mppaContacts w...more >>

Hello, Does anyone know if its possible to access the row/column values of a DataTable while a DataAdapter is filling the table? Maybe using a new thread? I am currently trying to use a seperate thread for access while the main thread runs the DataAdapter.Fill and so so far it looks like t...more >>

Greetings, Is it possible to alias an ADO.Net table? I have this one table that has a pretty long name dsDataEntry.Tblsomebigtablename. I tried Dim dt As DataTable = ds...Tbl... Welll, that created table dt, but it did not populate the table. I guess I would have to loop through the o...more >>

Hi Everybody, I've got a strange problem on one of our clients computers: I've got a dotnet 1.1 application that connects to a database using .Net OleDB provider for Visual FoxPro. On most of our clients' computers everything works as expected, However on 1 computer running Windows XP Pr...more >>

Hello! ADO.NET 2.0 offers the possibility to execute SqlCommands asynchronously, for instance SqlCommand.BeginExecuteReader. Let's assume it takes quite some time to execute such an SqlCommand. Is there a way to cancel the execution of an SqlCommand executing in this asynchronous manner? ...more >>

I have field with a Date and a field with a Time; is there anyway to make a complete DateTime using an expression in ADO.NET? I don't have an option to do this in a database before getting the data into the app. Thanks, Joe ...more >>

Hi everyone, I have a stored procedure called 'PagingTable' that I use for performing searches and returning just the results for the current 'page'. That way I can do my paging on the server and only the data that actually gets displayed on the webpage is returned from the database se...more >>

Hi, I have this problem, I do an update to VFP table, using oledb all works fine while I run the asp net application from visual net IDE when I close the IDE (same computer) and open explorer to run the application and try to update the table, I get the error "cannot update the curs...more >>

I have a DataSet that contains one table. I want to create two new tables each of which contains all the rows but only some of the columns from that first table. Can I do this without going back to the original data source? THanks. -- Peter Aitken...more >>

I have defined a strongly-typed dataset with two tableadapters in a master/child relationship. On the master tableadapter, there is a parameter which restricts the fill of the tableadapter to less than the entire contents of master table. After filling the master table, do I simply fill the...more >>

I tried to use FxCop on the sample of http://asp.net/learn/dataaccess/default.aspx?tabid=63 And I got the following error. Basically the code defined a member with type of TableAdapter and no Disposable method is defined. It sounds it's not necessary in the samples. Should I have a empty ...more >>

Hi there I found a starnage behavior. I have a method 'GetDataFromDB', which i use internaly in my class to get data from the db. Now if i build the query using SqlParameters for the date my query takes up to 60 sec vs. 2 sec if I do not work with the SqlParameters! What can be the problem?...more >>

Hi there I found a starnage behavior. I have a method 'GetDataFromDB', which i use internaly in my class to get data from the db. Now if i build the query using SqlParameters for the date my query takes up to 60 sec vs. 2 sec if I do not work with the SqlParameters! What can be the probl...more >>

I've encountered a strange problem when trying to update data in two tables using a dataset. My application is split between a client (presentation) and webservice (business and DAL). I have a typed dataset, HSEDataset, containing two tables related by a foreign key constraint. I use the sta...more >>

I am having difficulty getting Jet databases to close by calling the DbConnection.Dispose method. The method seems to work, and the connection state changes to closed, but about 25% of the time at some level the process is keeping hold of the connection, and not deleting the ldb file for exa...more >>

Hi I am using below query to retrieve records from backend sql server 2005 db; SELECT ID, Company .... FROM tblClients WHERE (Status = @status) Problem is that sometimes I need all records regardless of what is status. How can I achieve that? Can I add something like OR ...more >>

hi there, i have a huge large text file (350.000 lines) that i want to import to a MS Acccess Database, of course i don't want to use Access, but do it with C#. i already have tried the AddRow method or Insert, reading each line of the text file, the problem of course is velocity, it would ...more >>

I want to pull some data from a CSV URL (from yahoo's website) directly into a DataSet. Is there a way to do this without having to save the CSV file on disk ? Thanks, Yannick L....more >>

Hi all, I'm experiencing quite a weird problem inserting an image in a database. I've designed a small form with some fields and a picturebox. I can fill all of them and clcik the 'create item' button, and the task is performed wonderfully, but as soon as I try to insert the data with the ...more >>

Hi, Sorry for the cross post first of all. I posted to the ADO forum the first time by accident. I wrote a windows service in c# .net 2.0. There is a timer that fires every second or so and when it does I start two threads (unless they are still running from the last time). One of...more >>

When the dataset is too large it thows OutOfMemory Exception although that there is enough momory on the web server, is this a bug in .net or something must be configured?! The Dataset contains near 50 000 rows. How can I escape this. Please help? ...more >>

hi, I am trying to use TransactionScope and multiple async calls but get Transaction aborted - transaction in doubt errors. My program goes like this using (TransactionScope ts = new TransactionScope()) { do an insert on Table1 (Connection1 = new SqlConnection) foreach table ...more >>

Hi all I'm in the process of making a system to integrate a webshop with an erp system. All exports from the erp are XML based, and when I needed a test application the obvious choice for me was to use XSD generated from the XML export files, and from the XSD to generat Typed Datasets. T...more >>

I have an access database dataset which a draggedonto a form which also put the data navigator on the form. The problem is that when I ADD a new record witht he add button, it gives me a primarykey that has already been used and deleted before in the database. Then of course when you try to sa...more >>

I have created a dataset containing master/detail tables and used it as a datasource for a master BindingSource. I created another BindingSource for the detail table - its datasource is the master BindingSource and its DataMember is the relationship between the 2 tables. I laid out 2 DataGr...more >>

I can connect to one db2 database through my application just fine. But when I attempt to connect to another database in another application, I am getting errors. When I create the connection object, I see the following on the "ServerVersion" property: "ServerVersion = '_OledbConn.ServerVer...more >>

Hi Using ado.net i am trying to connect Sybase[SqlAnywhere-9]. The problem is i am able to retreive data from the tables , but while inserting i am getting exception as "Authentication Violation".The database is local and i am using "iAnywhere.Data.AsaClient". The connection string i am us...more >>

Hi, I wants to create a Mater/Detail Form in VB.NET 2005. Can any one direct me to a good tutorial I went through http://www.15seconds.com/issue/051117.htm but it is not straight forward ...more >>