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 >>

Once a user clicks on the "add" button it adds the new record to the DB but i want at the same time to get the primarykey of the record i just added. Is this possible without writing a new "SELECT * bla bla"? and if so, how 2? thx in advance, Richard My code ----------------- Dim st...more >>

I hope you won't mind if I spam this newsgroup with a little announcement: Visual Studio 2005 Beta 1 is available! The Express editions are available for public download, and the full version is available for MSDN subscribers. Get more info and download from: http://lab.msdn.microsoft.com/vs20...more >>

ADO.net using VB.net I've written a simple application which will import data from one MS Access db to another. The file is on our 2K Server. The application works fine when I run it from VB.net... but when I create an EXE file of my application, and then run it from my PC (ie via a Schedul...more >>

Hi All, I've got a puzzling situation. I have a strongly-typed DataSet with 3 tables which I want to copy into a generic DataSet. So I do this: DataSet ds = null; StrongDataSet dsStrong = new StrongDataSet(); Dosomething( ref dsStrong ); ds = dsStrong.Copy(); An exception is thrown ...more >>

What I'm trying to do is exectue a stored procedure that returns some records along with an additional RETURN value. The code is below: *** SqlConnection Conn = new SqlConnection (System.Configuration.ConfigurationSettings.AppSettings["MyConn"]); SqlCommand Cmd = new SqlCommand("spMySP", Con...more >>

Okay, I am doing the: table.rows.add(NewRow) thing, but now I decide I want to be able to find the row by primary key. Now the primary key for this table is an Ident, so that value will come from the database. I have all my update components in order. Every thing works, until of course I set the...more >>

I have several apps that use a roll your own approach, but I am embarking on a project which will not allow that with the time constraints. I have gened up a little app to try the databinding approach. Simply it is a page to maintain the Territories table in Northwind (SQL Server). I have t...more >>

For some reason I am having brain freeze and I am not even eating ice cream. I know this is a very simple question for some. I am filling a dataset with some information from a table off an AS400. Some of the time this table might have 0 to 1 record. Most times it will have more than 1 reco...more >>

Hello, I have opened a datset from an Oracle Database. I am trying to 'Select' a non key column. strFind = "INTERNAL_EMPL_ID = '" & provId & "'" - This yields : "INTERNAL_EMPL_ID = '0000015615'" drArray = ds.Tables(0).Select(strFind) This should return a single row ro...more >>

I have a DataView set up as following: DataView dv = new DataView(); dv.Table = twsDS1.twsContractHdr; dv.RowFilter = "AgencyID = '" + agency + "' AND NeedsStatus = 'I'"; int cnt = dv.Count; In my test, this returns the expected value of "3" for the cnt of incomplete items within the contr...more >>

Hi There, I am trying to loop through some fields on a form in order to call a stored procedure to insert bulk information into SQL server, the thing is I am trying to exit the loop but the loop keeps going past the counter varible. I only want to insert the information based on the value of t...more >>

SQL Server 2005 Express Technical Preview http://www.microsoft.com/downloads/details.aspx?familyid=2ccf2ab6-bfd9-4ac8-b31d-ddbad7d532a2 Download: http://download.microsoft.com/download/c/f/8/cf872b5a-509b-44ce-b5ac-e693f7aec971/SQLEXPR.EXE Web: http://msdn.microsoft.com/sql/ex...more >>

Dear all, When running the .ASPX program, I recieved the following error "Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'." I reinstalled Sql Server and issue is fixed. However, the issue occur again after a while. In web.config file, the connection se...more >>

I am having this problem with an application which seems to call DBConcurrencyException when calling the Update Method to my DataAdapter. It seems to happen only when I add a new record to my DataTable and this is the first row, if I have 2 rows the exception is not thrown. I really do not know ...more >>

How to OPen and Save records in DAtagrid into text file with VB.net Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ----------------------------------------------------...more >>

vb.net application: I'm having trouble with an identity-column changing to a new value, if an error is raised on insert - ex. violation of unique constraint on another db-column. An new value is assigned to the ID-column in the database, but not in the form, when I correct the values violating...more >>

Hi There, I am storing images in SQL server ans trying to retrieve them into an image control but I can't seem to get the image to show. If I load the image page (ReadRealImage) on it's own it works no problem, what I am trying to do is to load the image into a user control page with an image ...more >>

I have a DataGrid that is configured to use the Edit/Update/Cancel concept correctly. My grid shows values from 5 database fields. I only need to update that last 4 fields. The last field is a Yes/No value in Access. Using the OleDbCommand, if I do not consider the Yes/No field, the Execute...more >>

Can I run multiple queries separated by semicolon (;) with ado.net compact framework uisng windows ce? I have tried to use it by setting IDbCommand.CommandType = CommandType.Text and without it. but couldnot get my code work I am using quriy like Update settings set value = '1' where name =...more >>

Hi all, I've written a recursive stored procedure that will navigate one of my tables in a hierarchical fashion. When I run the stored procedure within query analyzer it returns the proper data. However, when I "fill" the DataSet with them - there only appears to be one row of data. I shoul...more >>

Hi, Recently, we installed Sharepoint Services on our test server (Server 2003) to try it out. I made a new web for my regular aspx pages. My problem is that now whenever I try to access my old pages, it prompts for a username and password for that server. I want it to allow anonymous web reques...more >>

I'm trying to select from an Access DB based on a date field. The date field in Access is specified as Date/Time and the following code is grabbing the date from a DatePicker in short format: Error - Date type mismatch in criteria expression Dim PeriodStart As Date = dpTSPeriodStart.Text ...more >>

Hi, I'm just about to write one of these components to simplify simple dataset return, and command execution against a SQL Server database. Does ANYONE have a component freely available that I can use? This will save me a day or two! Cheers :) -- Liddle Feesh *fap fap fap fap* ...more >>

trying to add a new row by entering it directly in datagrid bound to dataview. after typing in value, new row disappears. primary key is set to autoincrement. also how to assign another value to another column in datatable at the same time this datarow is being created through Dataview? ...more >>

We use sql and like the way we can create a window, have the .NET ide find a datatable,generate a connection, generate a sqladapter, and generate a dataset tied to that adapter. We also like the way that the .NET ide will automatically generate the add,modify and delete commands on that sqladap...more >>

Did I miss something, or is this just lame? With Oracle 10g & distributed transactions I get: System.DllNotFoundException: Unable to load DLL (oramts.dll). at System.Data.OracleClient.UnsafeNativeMethods.OraMTSJoinTxn(HandleRef pCtxt, ITransaction pTrans) ... If I rename the 10g version of ...more >>

I have an Winforms application that's using ADO.NET to access a SQL Server database. The connection is NOT pooled, and is kept alive for as long as the application is active. It also creates a ##TEMP table to be able to detect an already running instance (only one can run at a time). If the TCP c...more >>