I am inserting rown into my data table and would like to be able to retriever id of the row inserted immediatelly after it has been inserted. How can I do that? Regards, Dino -- ------------------------------------------------------------------------- FIGHT BACK AGAINST SPAM! Downloa...more >>

can some one tell me why is that ODBC.net is faster than OleDB.net???...more >>

Hi "Select UserId from users where userid = 2" How come it return Undefined value if the select doesn't return any result? How can I know if the select succeded or not? Thanks, Ronen ...more >>

Hello I want to read an XML file that was created with ADO into an ADO.NET dataset. The file was created using ... rs.Save "titles.xml", adPersistXML and is read into the dataset using... ds.ReadXML("titles.xml") My problem is that although the data is read OK, the inline schema i...more >>

I have an identity column defined as int in sql 2000. I use SCPOE_IDENTITY () to get the new inserted column id. The problem is that the object returned from the ExecuteScalar is of type Decimal? why is that happens? Thanks, Ronen ...more >>

I want to serialize a DataTable that exista within a typed Dataset into an XML file and later deserialize it. I am not able to do that.... any pointers?...more >>

Hi There, I am trying to execute some stored querys in my access 2000 database, I would like to do them in ADO .net but I am haing syntax troubles. This is how I would normally do it in .asp, could someone post the equivilent of this code in ADO.net please? Sean set objConn = server....more >>

Hello All, I am facing SQL Server related problem. Here is the scenario: 1. We have a windows application (24x7) that has timer running on = the form. The timer interval is set at 3 minutes. On every timer tick, a = method is called that executes a stored procedure. On execution of the ...more >>

The web server is running Windows Server 2003 Standard Edition, and it returns HTTP 404 error when running ASP.NET pages, but ASP pages are working fine. I also installed Visual Studio .NET, and the framework version should be 1.1. I am sure ASP.NET is enable in the machine by checking the fol...more >>

My code below always returns 0 for the Identity. Any idea why. The database is in Access 2k. int ID=0; OleDbConnection conn=new OleDbConnection(); OleDbCommand aCommand=new OleDbCommand(); conn.ConnectionString =ConnectionString; conn.Open(); aCommand=conn.CreateComman...more >>

hi i need to access cobol data files from .net, the files have no or .vix extention (i think thats a acucobol or something like that) (/me has completely no experience in cobol) i heard that there should be an odbc connection for that. Dous anyone have any ideas on how to do this?? -- ...more >>

Hi, i try to set a rowfilter with dezimal values like 2,7. .... vw1.RowFilter = "Key='" & Me.C1FlexGrid1.Item(cellZeile, cellSpalte) & "'" After run this row, it crash thx Rene ...more >>

I'm designing an app that will need to run in environment where different data is on different DB servers and OS'es (SQL Server, Oracle, Windows, AS400 etc). My app will need to pull together data from a few separate databases and then run some reports on the data. My original thinking was tha...more >>

This error happens every once in a while. I cannot figure out what is wrong or why this happens. This SqlTransaction has completed; it is no longer usable. public void InsertVisitorTargeter() { MyUtils.SqlClient sqlClient = null; SqlTransaction tran = null; try { sqlCli...more >>

Hi everybody - This may seem like an easy question to the .NET gurus out there but it has me very much stumped on how to accomplish. I have a dataset that I have merged together from separate queries. What I want is to include it in my final query so I can include other fields but I'm trying t...more >>

It's a commonly known problem that XSD.exe cannot parse the following XML into either an xsd file or class <Data><One><File><Name>Test1</Name></File></One><Two><File><Name>Test2</Name></File></Two></Data Because it can't cope with the fact that the <File> element appears in two places (the Custom...more >>

I have typed dataset and i don't know how to filter rows of table A according to children rows in table B Example TABLE USER has columns ID,Name Table USERNICK has columns nickname, ID Relationship is : each user can have many nicksname. (1,N) using dataview, i want to show ALL u...more >>

I have an application that gets data from a Access database and displays it on a form. I have a slightly odd and annoying problem that stems from the fact that the program I'm replacing with my program was writing in VBA in Access. The problem is that the RichTextBox control in Access uses '/n/b'...more >>

Hello, I retrieve all the Ids from a DB table. The 'current' Id is used to retrieve all the columns associated with that Id. I need to Move Next and Move Previous. The DBEnumerator is a Forward-only tool. A "For Each Row" solution would enclose nearly the entire application in ...more >>

hi all, I have 2 kinds of finanacial objects in my design, nevertheless they both should "share" the same logical ID. Let say i have 2 types defined as being OBJECT1 and OBJECT2 (2 being different kind offinancial transaction) They are totally different and do not share any field exceot there...more >>

Hey, Hi all friends!!! I've got an application which executes an stored procedure using an OdbcCommand object, but it has to executes several stored procedures at the same time, so i decided use multithreading, so that the application creates a thread for each stored procedure and start...more >>

Hi, On my webform is a DOB text box. If the user wants to clear out the field, how do I write a NULL back into the SQL Server Database field. Thanks, MDM ...more >>

Hi all, I'm missing something, probably stupid, on connecting to a SQL Server database from an aspx file. I haven't really done much w/ SQL Server and suspect that it's a problem on that side. I've installed the SQL Server developer edition locally and do have a pubs database. The connec...more >>

I am using ADO.NET datasets to transfer information between my client and business logic. When I fill the dataset and some dataset contraint is triggered, then the FillError event is triggered, that can be handled. My database contains some constraints that can be triggered when propagatin...more >>

Hello, If I name a table in the Fill method and that table exists in the DB (in my case, SQL Server), must the structure and rules be the same as the database table or are the DataTables totally independent and defined solely within the context of the SQL Command executed by the Fill me...more >>

Hi ! I wonder if there is a simple solution to how to dynamically view an image from a SQL DB. It´s a binary file and the insertfunction into SQL works fine. I can easily view all the text from the SQL DB. I can also view the image separatly. I load the text in a separate file : details.as...more >>

I'm getting an error message "Could not run the c:\program files\... \WinDataForm.vsz wizard" when I attempt to add new item and select Data Form Wizard as the template for a new project. Any ideas what might be causing this? I just re- installed and tried again, but same issue. I'm runnin...more >>

Hello, Can anybody please tell me how to read the data from Excel Work Book using ADO.Net so that these Records can be persisted back to the SQL Server 2000 Database. Regards, Anonymous ...more >>

Hi I'm trying to write strongly typed dataset. Ma DB has Tables with more then 100 columns each. Creating DataAdapter, DataSet and DataAdapter Commands by wizard fails. Doing it manually is not pleaserfull. I've discovered that when number of columns in table exceedes 100 Then DataAdapter ...more >>

I need to collect all thedeleted rows of a datatable How can I collect the deleted rows of a datatable?...more >>

Hi, I have written an utility that makes a backup (via SQLDMO) of a SQL Server database, then issues various ADO.NET Commands to this database. In case of any error it restores the database from the backup (also via SQLDMO). Problem is, when I want to do the Restore after an Error, the Rest...more >>

Hi experts! In ADO.NET connection, why DRIVER type is dropped?. Only PROVIDER is used. Pls i need a big explanation. thanx in advacne....more >>