I'm in a pickle. Maybe you guys can shed some light. I am setting up a web site that uses a ADO and SQL server. My first site went well, and works wonderfully. So I use the same classes and modules I developed to build a second site. I'm developing and testing on a Windows XP machine, then ...more >>

Hi everyone, I'm wondering if there is some easy way to deal with null values being returned in a DataRow. When I get data from a database (Access) most of it is string based. However, I don't always know if a particular row will contain any information in any given column. Sometimes there...more >>

I am getting an error about my # pooled connections exceeded or timeout exceeded. I am searching my code for any open data readers. I have read that i can use perfmon to watch the number of pooled connections using .net clr data and counter "sqlclient:current #pooled and nonpooled". M...more >>

Hi, I am facing a problem while trying to use complexType in an element. I want to nest an element "somechildren" into an element "some". This can be done by creating a nested relationship between "some" and "somechildren". However, the problem is that the fields in the child table "so...more >>

I'm trying to populate a dataset with the contents of a csv text = file.... This is one of a number of attempts I've made to read in this = file (I don't actually want to display the information, but read through = it line by line in code..). My code at the moment looks like : Dim TextC...more >>

Should I make calls to .Dispose() for ado.net objects when I'm done with them, or is it best to let .net's garbage collector handle these objects after I'm done with them? Thanks ...more >>

The documentation indicates the DataTable has a property called "Rows" and it states that "Gets the collection of rows that belong to this table." When I go to use this property (show up in intellisence) all is well, but when I attempt to compile, the compiler tells me there is no such proper...more >>

If I am using c# and I have a DataRow and I know that I want the value for a column named "Fred" - how can I access this column if I do not know it's index? Must I loop through the columns collection to find the right index? Thanks in advance for your assitance!!!!...more >>

Hi, I working with vb.net and a Microsoft Access Database. I am tring to input a single quote ' into a table (query below). However, I am recieving an error. How would I go about performing such a task? INSERT INTO list (name, value) VALUES ('Sam', 'Sam's Car') Thanks in advance. E...more >>

If I am setting up a DataTable and a particular column is defined as a GUID and in SQL Server it has a default value of newid() does this mean that I should define the "DefaultValue" for the column as new Guid()? How do I handle setting the DefaultValue for the column in the datatable?...more >>

Hi, I noticed that since I have created lookup table in combobox, there has been a performace degradation in refreshing dataset (clear and fill)? 'code for creating lookup table in combobox da.Fill(ds, "employees") cboreportsto.DataSource = ds.Tables("employees")...more >>

I have a datatable that contains data I'm inserting programatically (not = from a datasource... using between postbacks to persist data). I need = to be able to update the elements within the table, but I also need to = sort the elements using a DataView. Here's my code as it stands: Dim dv As...more >>

Does anyone know the name of the exception that is thrown when an attempt is made to add a duplicate entry (key value) to an Access data base? The int value appears to be -2147467259. Any one know where I can find a list of exceptions and their corresponding integer value? Thanks...more >>

I thought I might post this to see if there is a pro that can help me. Here's what I want to do: - I have two tables ('tblPositions', 'tblTrades') - A relationship exists at tblPositions.ID = tblTrades.PositionID - I need to pull only one record from each relation set (the one with the ...more >>

Hi all, I am getting the following error message in my asp.net page while connecting to SQL server "SQL Server does not exist or access denied" I am using the following code constr = "User ID=designers; Password=designers; database=DesignManagement; server=dserv" ; SqlConnection objco...more >>

Hi there ADO.NET users. I have a new year present for you :) I've put together a template that generates update/insert/delete commands, an adapter that holds them together plus code for doing updates. It works for Sql server or Access for now. Template is run with CodeSmith (free template bas...more >>

Here is the code I have and it does not work. Any Suggestions? public bool saveRackTypes(DataSet saveSet) { SqlDataAdapter myDataAdapter = new SqlDataAdapter(); try { myDataAdapter.SelectCommand = new SqlCommand ("SELECT * FROM RackType", _myConnection); myDataAdapter.Update(s...more >>

Hi: Is there any way to get connected with an Oracle server without installing the 200MB Oracle Client. Some kind of driver? Oledb, Odbc, *db*? I'm using the 8i version. Is it possible under the 9i version? Thanks ...more >>

I have a dataset that i read into a datagrid, and I need to find a way to update that table using transactions in case some records update and some don't. I would rather use the data adapter update so I dont have to use all those update statements. Thanks!...more >>

I have a typed DataTable with two only fields that, together, I have set as the key. Why then is the DataTable allowing duplicate entries? ...more >>

Hi, Will be very thankfull if somone can exaplain the difference between; txtbox.databinding.add(New binding(("property of contorl",ds,"property of" _ & "datasource") AND txtbox.databinding.add(("property of contorl",ds,"property of datasource")...more >>

Hi, This is probably simple, but I've got a very simple C# function that connects to a VFP database and takes a SQL command as a parameter. When I attempt to send that command to the database (ExecuteNonQuery), it throws an exception indicating "Cannot update the cursor <TableName>, since it ...more >>

Greetings All, Where should I declare & instansiate Connection object? That is, should I do it in class or main module. I'm really confused, if connction obj. is decl. and insta. before connection string gets servername and database from registry this will causes an error? Any doc or codes ...more >>

I am learning VB.NET, trying to insert record in Access Database using oledbCommand. I am getting an error Which is typed below during compiling the programe. I am sending the source code .Please rectify the error and send me. ERROR MESSAGE: An unhandled exception of type 'System.Data.OleD...more >>

What's the best strategy for intercepting updated rows in a DataSet (let's assume only one DataTable) and turning them into INSERT's (I'll tweak a Date/Time stamp to insure they are new rows that don't violate any constraints)? I don't need code examples, just advice from those with exper...more >>

I have 400 rows in the TRAIT_NOTES tabel but my sp. returns just 87 records any idea why that may be? ALTER PROCEDURE dbo.GetTraits AS SELECT 1 AS TAG ,NULL AS PARENT ,NULL AS 'TRAITNOTE!1!' ,NULL AS 'Result!2!CONDITION' ,NULL AS 'Result!2!NOTE' UNION SELECT 2 ,1 ,NUL...more >>

I want to set a row i.e. upon calling my fucntion SetRow(int val), the cursor should be present in that particualr row. I dont want to use Edit button for my web daatgrid How to acheive it?...more >>

we are using the sybase 12.5 database in the unix server. using the oledbdataadpator, how can i connect to the database. That is what should be my string in the ConnectionString Thanks...more >>

Pls send me the Providers available for Dot.Net to Oracle 9i....... With advantages and disadvantages.... With thanks.... Jovin ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgrou...more >>

Hi, Thanks to Paul Clement & William Ryan, I've connected to my Excel spreadsheet by using the "Jet 4.0 OLEDB" provider and by setting "Extended Properties" to "Excel 8.0". Although the connection is prefixed with "ACCESS" rather then "EXCEL", I can successfully use the VS.NET Server Explorer...more >>

We have a faily large Asp.net application and we removed all of our dat access calls to an object that just contains the actual static calls we use against datatables and calls that execute directly against command objects (non query calls) We wrap all of our calls with a Mutex to avoid collisio...more >>