Hi There, I have tried just about everything to get the dataview working, all I want to do is loop through rows generated from the stored procedure and then suppress some of them depending on the amount of columns returned, with a table like structure. can someone help me out with a little ...more >>

Hi I need to insert a new record in an access table with values for various fields provided. In sql server you have an insert stored procedure to which you pass the field values as parameters. How do you do something like this in access using oledb & vb.net? Whatever is easiest. Thanks ...more >>

Just finishing up reading "Pragmatic ADO .NET" from the .NET Developer Series. Most of the examples deal with single tables. The ones that don't show a very simple relationship like Customer -> Orders. In the examples, the author seems to advocate loading tables into DataTables using SELECT *...more >>

Hi What is the oledb equivalent of sqldatareader? Thanks Regards ...more >>

Hi all, certainly know the good-old ado recordset with the capability of have a server side cursor with it advantages ad disadvantages. In some roadshow during this year someone has tell to me that 2.0 version on ADO.NET we would have had the server-side cursor come back again. Is this true ??...more >>

Hello, Another issue has risen after installing Visual Studio 2005. When I use OracleClient with ASP.NET v1.1 I receive an error stating it can't load OCI.DLL. This has never been a issue before so I assume that it is a result of the new version of VS. Doe's anyone know a fix for this prob...more >>

I have a function that replaces all my single quotes going into the DB with two single quotes. So "O'Hare" becomes "O''Hare". I have a dynamic sql statement for searching for customers. When they type in "O'Hare" I do the same command and turn it into "O''Hare" and use that in the where clause. Th...more >>

We have a Winform application in production. It has been compiled and installed on users' machines. One tasks in application keeps timing out. Is there anything we can do to increase timeout period without modifying source code and recompiling, redeploying this application? Connection string is stor...more >>

Hi friends, Could you please tell me or assist me to get a suitable link describing the difference between strong typed objects [datasets] and ordinay objects ? [datasets] Thanks in Advance Emmanuel Mathew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ...more >>

Hi All, I am using the following function to output data to an excel (.xls) file via a dataset, listview, etc... Dim m_sConn1 As String = "" m_sConn1 = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & FileName$ & ";Extended Properties=""Excel 8.0;HDR=YES""" ...more >>

Hello. We have SQL Server Stored Procedures that use the "CURRENT_USER" variable. We have SQL Server database fields that call "user_name()" as a default. That has been fine in the use and storage of user names, in the context of being called from IIS 5 and 6, from ASP 3.0 using ADODB. I'll...more >>

Hello, I am somewhat new to .Net and currently working on an intranet site using C# going against SQL Server 2k. I am accepting personal information on a single webform and trying to insert the information into three separate tables (all in a single aspx page -- without using stored procedure...more >>

Hi, I have my data in a DataSet class. But the data could changed on the SQL Server from an other user. How can I know, that the data is changed? It will be very usefull, if I could define a trigger on the SQL Server, and that could send me an event to my program, and the I can refill the Da...more >>

Hi Is it possible to do run a select query on a dataset from a web method using a dataadapter? A code example would be great. If not, how can we grab hold of the remote dataset data in a local table? Thanks Regards ...more >>

I am having some difficulties with determining how to leverage the use of typed datasets with a specific schema. The problem lies with the definition of a 'relationship', at least when defining the typed dataset via the IDE. The IDE forces me to define a relationship from a parent to a child, ...more >>

Hi: Is it possible to execute a complete script with different commands in one execution under ADO.NET? If so, with which component and how? Do I have to separate statements with 'GO'? TIA, Martin. ...more >>

Hi I have a dataset from a web service. I want to use a dataadapter with the dataset. What connection string should I use so the da knows that it is acting on the remote db associated with the web service dataset? Thanks Regards ...more >>

I was browsing both the Amazon and Barnes & Noble websites looking for some good books but there appears to be *so* many and it's hard to tell which are going to be good or not. I'm looking for one or two *good* books on the subjects of ASP.NET and ADO.NET together. E.g., using ASP.NET on the...more >>

Hi Group, I need to fill a dataset from a csv file. The issue is that the file is already loaded in memory I'm using an asp.net application to upload a csv file from the user, so after submitting, the file is uploaded in the server's memory. I don't want to have to save the file on the disk b...more >>

What would be some scenarios where setting persist security info to true would be useful ? Thanx Prem...more >>

I have the following code: The following line is global Dim sqlDS = New DataSet() This is in a procedure objConnect.Open() sqlDA = New SqlDataAdapter("select * from eventCalendar",objConnect) sqlDA.Fill(sqlDS,"eventCalendar") Dim totalRows as integer Dim totalColumns as integer...more >>

Hi, Can anyone share any good source on multithreaded data access please? (Data access that run in separate thread from UI) Thanks. ...more >>

I have a DataView where I am trying to use “rowfilter” property to get a subset of base table rows. When my View gets created any rows which have “modified” or “added” row state are not returned in DataView although they satisfy my filter condition. I have tried to use all possible combi...more >>