I am having a concurrency problem with a child table that I can't seem to figure out. I have a parent table 'ProposedCost'. Its primary key is a guid. I have a child table 'TermsAndConditions', it has a primary key that is a guid and a foreign key to the ProposedCost table. I have a grandch...more >>

Hi, I developed a simple app that has a parent-child table relation (parent's PK is an Identity col). I insert a new parente record and a few child ones. When I call the parent table's DataAdapter Update method it gets the new Identity value from SQL Server and update the child rows in memory ...more >>

I am retrieving fields from a database using a stored procedure that I know will always only return 1 row. I would like to arrange my text boxes, dropdown listboxes, etc... and bind the appropriate fields from this stored procedure to these controls. Can I return this one row of data directly ...more >>

I've got a couple of ADO.NET 2.0 questions that I thought I'd post here to see what you all think. Question One (regarding new SqlTypes): I ran across the new types, but the current docs online at msdn2 and in the 2005 BOL do not provide any details. The types I'm unfamiliar with are: SqlByt...more >>

for some reason, a specific database state gives me an IndexOutOfRangeException when I call SqlDataAdapter.Fill (in several cases the same code doesn't throw the exception) the SELECT is: SELECT Bank_sec_code, Dt, Par_val, Rate, Rate_nis FROM dbo.Common_rates WHERE (Dt = @dt) I supply a...more >>

I have a dataset with several tables in it. Some of the tables are related, such as like where I would have an 'Order' parent table and an 'Order Details' child table. The 'Order Details' also has a child table to it named 'Order Years' table. 'Order Details' has a foreign key of the primary k...more >>

Using System.Data.OleDb Dim ds As New DataSet da.Fill(ds) When I run this against Oracle 9.1 I get: "Conversion failed because the Decimal data value overflowed the type specified for the Decimal value part in the consumer's buffer." Sounds like OleDB doesn't know how to handle big nu...more >>

Hi, I have a typed DataSet with 3 DataTables containing master-detail detail. I need to perform variable levels of group by on this data - and pointers to example code greatly appreciated. I something in my MSDN library ages ago that grouping on datatables but cant find it any more! I a...more >>

Can i do this is ADO.NET using C# and a SQL server. Select * from table1 where Client= ( //What i want is (Client=CodCli) select CodCli, Vend from Table2 Where Vend ='Variable'; From i read i cant make a dataset from diferent tables, so how would you solve this problem. ...more >>

Receive the following error when stepping into the FILL (see last line). Being a newbie I cannot see anything obvious. Error message: An unhandled exception of type 'System.NullReferenceException' occurred in system.data.dll Additional information: Object reference not set to an instance...more >>

I am trying to connect to Oracle database from ASP.NEt usng VB.NET. I added a reference to the MSOracleClient and tried connecting to oracle using the MS .NET Framework data provider for Oracle. I have Orace9i client installed on my machine and I keep getting the following the following er...more >>

Hi, I'm sure many of you would have done this before. I'm databinding textboxes, and adding a newrow using, Dataset.Tables("Name").NewRow and setting the position of the currencymanager, but this doesn't clear the textboxes, even when I explicitly clear them. If I use Currenc...more >>

I'm wondering what's the appropriate way to do the following: My app programmatically creates a DataTable and its schema (shema varies), places it into an empty DataSet. Then, it reads from file, does some work, then populates the DataTable with many rows. Then, it copies a blank Access DB...more >>

Hi:my friends I meet a very very strange problem; I use untyped dataset, after I changed the value of one row in the datatable,I see the rowstate is modified,but after I call the update method of datadapter,nothing hanppend.Here is my code: daMasterRemote.Update(dsRemote.order_master); dsL...more >>

Ok, I have an mdb with a couple of linked tables from an MSDE db. When I linked em I saved the password. I have a query in Access that refers to one of the tables in MSDE. It works great. However, when I try to run that same query from and Aspx page, I get an error telling me that ODBC can...more >>

Hi Ng, I have an XmlDataDocument which I want to serialize, so that I can store it in my Sql server via ADO.NET. It should be possible to read it out again and create a similar XmlDataDocument instance, so that I can work with it. Unfortunatly, the XmlDataDocument isn't serializable from na...more >>

For my desktop apps, I create stored procedures for all of my update/insert/delete commands. I refresh the data with a "re-Select" as part of the stored procedure. However, with the Compact Framework and SQLCE, you cannot use stored procedures. Thus my question is, how best to implement the ...more >>

Hello, how can I fill a programatically created datatable with data from an xml file without having an dataset. The xml data have to be validated against a schema. Is there a ado.net builtin functionality, or do I have to code the functionality by myself. Any help is apreciated kind r...more >>

Hi alls I have a problem with a stored procedure : I use a CHARINDEX to filter a query and if I execute the query from sqlServer the charindex works fine but if I execute the query from my ASPNET application the charindex always return 0 (to test it I quit it from the Where to put it as a colu...more >>

G'day all, Being a fairly inexperienced programmer, I've never worked with= MDI Forms before=2E What I'm trying to do is open a Jet OLE DB= connection on my MDI Parent form (which is used to log in and= out with user name and password), and access this same= connection from the MDI Child ...more >>

does anyone have sample code of data being inserted to a table, then the last insert id is retrived and inserted into another table. The Code is c# and the database is SQL SERVER, NO Access examples or vb... Thanks for this... i just cant find a simple example on this identity problem, people...more >>

(Type your message here) Hi, I am trying to insert multiple rows using 'for' loop. It inserts first row but while inserting second row it gives error like "The variable name @name already declared. Variable names must be unique within a query batch or stored procedure" Please help me...my em...more >>

I have a question about how to define certain types of= constraints in strongly typed datasets=2E I will start from a= relational database example and show my problem when I move to= XML datasets=2E Lets say I have a relational database with 4 tables named= "Region", "Segment", "Product",...more >>

(Type your message here) -------------------------------- From: renu Friends, when I am trying to create a login page and connecting to the sqlserver database I am getting the following error ExecuteReader requires an open and available Connection. The connection's current state is ...more >>

DataSet is supposed to be an in-memory database=2E So is it= possible to fire a query on it=2E I want to fire a "Select" query= (with alises in it) and also a "Transform" (Crosstab) query=2E In= the current scenario I am putting things in an Access table but= for performance reasons want to ...more >>

I have a windows service that will insert records into an Access= database=2E Or at least that's the idea=2E The insert isn't= happening, but the code runs without raising any errors=2E When I= run the generated sql statement from a query window in Access,= the record inserts just fine=2E...more >>