Hi Is there a simple asp.net site with MS Access backend that I can use as a learning example? Thanks Regards ...more >>

Hi All, Is anyone tried the ASP.net Data bind control? Will you use it for implementation? Is it good? Please advise. Thanks ...more >>

I have a web app that needs to work with a PowerBuilder app's database. This means sharing tables for user rights and other such things. The PB app uses Oracle's logons so the user id and password are passed in the connection string. To authenticate a user they are telling me to get the id and p...more >>

Anyone know of reference material for creating typed datasets programatically? I want to get similar functionality to the "Generate dataset" link in SqlDataAdapter. I've read mention of an example in framework beta2.. anyone got a copy I can download??? I guess I should be looking at TypedD...more >>

Hi! I have a DataSet (dsTracking) which contains a row is updated with DataSet XML and inline Schema. So, in a DataRow I have XML data and schema that can be used to create a DataSet. The XML data and schema was created using DataSet.WriteXml with the appropriate XmlWriteMode: ds.WriteXml...more >>

I used a SqlAdapter. I have an InsertCommand whose CommandText goes like that INSERT INTO table ( field1, field2, ...) VALUES ( @field1, @field2, ... ) I have an event handler for the RowUpdated event which goes like that: IDbCommand cmd = myConn.CreateCommand(); row[identity] = cmd.Ex...more >>

Folks I'm getting a fatal exception thrown when I try to run a parameterized insert query from a SqlDataAdapter. The table I'm appending records to is not the same table that populated the dataset in the first place. In my SQL database, ServiceID and Amount are int 4 and money 8 datafield types,...more >>

HI I am looking for a way that I can grab the value of a particular cell in a particular row. Is that possible and if so how can I do it Any help would be appreciated Thank You...more >>

I am writing a data upload routine, i need to split 1 row of data into 3 tables. I am tring to do the followin Insert Patient Details Insert Sample Loop if Old_Sample <> Current_Sample then Insert_Sample Loop Insert_Resuilts end loop ...more >>

I have a table w/ a column of datetime (MSDE). How do I convert that to a System.DateTime type? -- Thanks, Martin Schmid, EIT, CCSA, MCDBA, MCSE ...more >>

Is there anything in ADO.NET that is equivalent to the old ADO GetString? This would return a record/recordset as a string. Thanks. Tom ...more >>

Hi all I have a DataTable containing all String datatypes. I need to query the table for records where one of the fields numeric value is between two other numeric values. I've been trying the following string val1 = '1'; string val2 = '2'; filt = "Field1 between '"+val1+"' and '" + val...more >>

I have a dataset that contains view... i.e., the structure is like this: [char(9), date,char(255)] Using ado.net in C#, how to I create an 'iterator' on this table to read the first row, next row, etc.. until I reach the last row. -- Thanks, Martin Schmid, EIT, CCSA, MCDBA, MCSE ...more >>

Hello, everyone I have a web application that includes a SQL database. we used to install the database seperately since it needs to be installed on another computer. I want to write a window application that can be added in the Custom action of the Web set up project, but it seems I can not use a...more >>

MAJOR HELP NEEDED: I can't seem to track down the problem with this code! No errors are thrown, but the data does not get saved back to the "destination" database. HELP!!!!???? Here's the situation: taking a dataset from SQL, want to merge it with an Access dataset, and save it - THAT'S IT! The ...more >>

Hello, I have a data grid (grd1) on a form (vb.net) which displays data correctly from an Access mdb table. I populate the grid control with a typed dataset (ds1) which I fill from a data adapter (da1), connection conn1. Now I want to insert a record into the Access table and reflect ...more >>

I have an OleDbDataReader that gets created based on the following (simplified) SQL select table1.field1, table2.field2 f from table1, table2 where ...... on my development machine, the following line works fine. myOleDbDataReader.GetString(myOleDbDataReader.GetOrdinal("field1")); How...more >>

Hi, I use C# to fill a data field of "float" data type in SQL 2000 server. When I use Double.NaN value, there seems to be a problem in "Query Analyzer". I can no longer select the row, an error message: "Numeric value out of range". However, in Enterprise Manager, I can still see the row with ...more >>

If this forum is the wrong place to discuss this issue please point me to the right forum... We have an ASP.NET application (InterNet app) originally written in .NET 1.0 running for about 2 years. Recently we installed .NET 1.1 and upgraded the app to 1.1. During the deployment we also install...more >>

Hello all, I have to execute the following simple query in MS Access and I am using the OleDbCommand object to do this. SELECT Entries.MessageID, Entries.DatePosted, Entries.MessageBody, User.UserName FROM Entries INNER JOIN User ON Entries.UserID=User.UserID I get an error saying: Synta...more >>

I have a web form that is connected to a database. I'm collecting user information and when a user with a name like O'reilley enters his name it fails because of the apostrophe. How do I detect the apostrophe and pass the insert command a safe string to insert it into the database. Is there a...more >>

I'm using WriteXmlSchema to create a schema from a dataset. The next step is to do a BULK INSERT into SQL SERVER 2000, but the XSD file needs the changes listed below to work correctly. Is there a better way to create a XSD for BULK INSERT? Or what is the best way to change and remove elements in th...more >>

How can I trace what a data adapter is actually trying to do ? I have a problem since my adapter is always affecting 0 rows on any "Added" or "Modified" records in my data table, but deleted rows work fine. I can't seem to "step into" the stored procedures when the Update method of the data adap...more >>

Folks I've been working on this since yesterday, mined msdn and the usual discussion groups to no avail I'm trying to do some maintenance on our database, and clear out certain phrases from the JobInstructions field in our database. sCriteria will include some year-specific phrases like "Okay t...more >>

Hi, I want to filter on a date column of my view. I use the following syntax : MyDataset.MyTable.DefaultView.RowFilter = "MyDateColumn >= #" & StartingDate & "# and MyDateColumn <= #" & EndingDate & "#" It works perfectly until I change my date format to dd.mm.yy. I get an error message ...more >>

how can create a new table in a dataset and database with some columns that I want We have a dataset ,dataadaptor and dataconnection and i mean with ADO.NET statments. ...more >>

MAJOR HELP NEEDED: I can't seem to track down the problem with this code! No errors are thrown, but the data does not get saved back to the "destination" database. HELP!!!!???? Here's the situation: taking a dataset from SQL, want to merge it with an Access dataset, and save it - THAT'S IT! ...more >>

In this statement: select CONVERT (CHAR(10), DATE, 101) AS DATEOFORDER the dataset had it appear as "DATE" which was empty and as DATEOFORDER which was as it should be. If I try: Dstran1.Tables(0).Columns.Remove("DATE") it balks and says there is no column called "DATE" I dont want ...more >>

Hi, I store an SQL Result with two tables in my DATASET. Now I want to access the fields int_width which existin both tables. I only found the solution shown below. Is there a solution where I can use the name of the Database tabel and the fieldname ([database table].fieldname) e.g. tbl_...more >>

Hi, I'm trying to get a DataColumn type (VB.Net + Framework 1.1). The property DataColumn.DataType is supposed to return dotNet framework type. But no matter what is the real type of the DataColumn, all I get is System.RuntimeType. I'll really apreciate a tip to solve this problem. Thanks...more >>

Hi all, To summarize my problem, I'd like to know if it's better to open many short SqlConnection for each database calls, or one longer SqlConnection used by all database calls. Let's say I have a function called "GetMyPageData()" in my Business Logic Layer : function GetMyPageDataInXml...more >>

Does anyone know how .Net data types are mapped to DbType and vice versa?...more >>