I am dragging my SQL Server table onto my Windows form to create my connection and adapter. I then go an generate my dataset and save everything. When I build, I keep getting compile errors and if I switch to code view and come back into design view or if I close the form and re-open it, my data...more >>

If my data in SQL server was stored from a web application with requestEncoding set as iso8859-1. And now I want to change the data encoding to big5, (or anything else), how could I do that? Thanks for all advice and input. Calvin ...more >>

Hi, If I use (in development) connection object from design tools in ToolBox to get data from db to crystal reports, how can I make changes to server name and security options in runtime. That is, is there an option during "packaging and deployment" where I can make connection setting as pe...more >>

A strang error is occurring when I run the following code: SqlConnection c =3D new SqlConnection(); c.ConnectionString =3D "Initial Catalog=3DNorthwind;user = id=3Dsa;password=3Dkat1ie;Data Source=3Dserver"; c.Open(); SqlCommand command =3D c.CreateCommand(); command.CommandType =3D CommandT...more >>

Is there a more optimal way than creating a new column as an expression? The following code snippet works, I was hoping for a better alternative: <DataTable>.Columns.Add("MaxIndentation", typeof(string), "Max(indentation)"); MessageBox.Show(<DataTable>.Rows[0]["MaxIndentation"].ToString()); ...more >>

Anyone have any clue why invalid date casts fine into OracleDateTime. DateTime dt = new DateTime(20004,14,45); // this bombs SqlDateTime dt = new SqlDateTime(20004,14,45); // this bombs OracleDateTime dt = new OracleDateTime (20004,14,45); // ...more >>

Coming from an ADO Background, I got by ok without using Parameters when I executed SQL Statements. I would just dynamically create the sql statement, inserting text between single quotes here and there, and send her off to the server, and voila, It worked. Now I'm learning ado.net, and many ...more >>

How do I set reference to a Foundation Class Library from VB.net? I'd like to get access to the CDaoDatabase Class... Dose anyone know if I can even do it with VB.net Small code snip would be cool... Remember VB code not C Thanks .. ...more >>

Can someone recommend the best book that covers ADO.NET. I want good coverage of XML use in ADO.NET and I would like the examples to be in C# (if possible). Thanks ...more >>

I have a method that returns OracleDataReader type. I am having problems calling the method from Web Services. Can the Oracle Data Provider for .NET be serialized? if not what are my alternatives....more >>

Hi, After hours of frustration digging for an answer I decided to post this message concerning my GetChildRows and DataRelation problem. What I'm trying to do is to use a DataSet to fetch data from 3 tables and then using relations to navigate parent-child records. First I created an XSD fi...more >>

We use a Class that contains all static data calls to retrieve and update our SQL Server. the retrieval methods have been very fast, but sometimes the update functions get Verrrrrrrrrrrrrrrrry slow. We use a Mutex to synch the calls so that only one user at a time has access to the data that is ...more >>

hello. i manipulate a dataview (updating and thus filtering a large amount of rows) and the datagrid bound to the dataview slows down this process much by adjusting its scroll bars and maybe trying to redraw itself. ok, Suspend/ResumeLayout doesn't help. grd.DataSource = null; // updat...more >>

I'm having a frustrating problem with some simple code. Isn't that always the case? :) Here's the code in question... Public Sub GetAllEmployees() Dim tbl As DataTable = EmpDataSet.Tables(0) Dim Row As DataRow Dim MyString As String For Each Row In tbl.Rows ...more >>

In the scenario where I have multiple entries (a couple of thousand on a worst case) I'd like to add to a database via Stored Procedures, is it proper procedure to: - create a SqlCommand object for the insert - add parameters etc to this sqlcom obj - create a SqlConnection object to connect t...more >>

I'm trying to understand CommandBehavior.CloseConnection, used in this context conn.Open() cmd = New SqlCommand(sql, conn) rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection) Is that the exact same as if I had done this? conn.Open() cmd = New SqlCommand(sql, conn) rdr = cmd.Execut...more >>

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

For more reasons than is worth going into, I have to retain a legacy distributable Crystal report. This report requires .dbf and .cdx files that I am able to create in .net using the odbc driver. However, for the report to work properly, I have to generate .cdx index files for these. Here the ...more >>

Is there ever any reason to use a DataSet over a DataTable, if I will only be working with one sql server table throughout my system? Thanks, --Michael ...more >>

Hi I've been able to make data driven applications for some time now. I've made them using Java/JDBC and C#/ADO.net. I was just thinking though - I hear the term 'data provider' quite frequently, but I'm not sure what exactly a 'provider' is. Is it like a driver to a *particular* database...more >>