Hello! When inserting a new row into a database I was wondering if it is possible to retrieve the id (key-field) for the new row - after insert ofcourse? Thank You Torben ...more >>

Hi; SQLDMO gives you a way to enumerate all SqlServer databases on the network and for a given server, all databases on that server. Is there a way to do this for Oracle? -- thanks - dave...more >>

We're using the above mentioned Application Block in our project, in order to execute stored procedure (SQL-Server). One of the stored procedures executes a list of simple "select" commands, e.g. select * from tableX, select * from tableY etc. I used a string array in order to name the tables th...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 >>

Hi, i make a connection to Navision via C/ODBC in ASP.NET First of all it didn't work with datasets, i had to use odbcCommands and a datareader this works fine as long as the valuetypes are string or code(special navision type) I have 1 field(Amount) that is type decimal, then i get the error whe...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 >>

Hi I am executing a query as below; Dim insStr As String = "INSERT INTO MyTable1 ( field1, field2, ...) ) " & _ "SELECT MyTable.f1, MyTable.f2, " & _ "FROM MyTable " Dim insCmd As New OleDbCommand(insStr, Conn) insCmd.E...more >>

I am creating datasets that I use to creat reports (using Crystal). I have been creating a dataset, then do the writexml, which I then use as the basis for report creation. If I use the xml file, I can preview the data in Crystal, but it does not see which data types (ie: integers/decima...more >>

I've read all over the web how hot and sexy ADO.NET is, but when it's coding time I just don't see the benefit (at least for me as a programmer). The biggest complains I have are: 1) I cannot open 2 simultaneous streamreaders with a single connection. When I stumbled upon this I couldn't b...more >>

Hi, I have an application using the OLE DB driver to connect to an MS Access database. AFAIK it uses MDAC 2.7 to accomplish this. This works fine under 2000 and XP, but not under 98 or ME. The download site of MDAC 2.6 or later says the following: This release does not include Microsoft J...more >>

combobox filling in vb.net and mydatabase is access gets redundantn what may be the problem User submitted from AEWNET (http://www.aewnet.com/)...more >>

I've the following simple page: === <%@ Page Language="C#" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <html> <script language="C#" runat="server"> void Page_Load(Object sender, EventArgs e) { SqlConnec...more >>

Dear all I hope some one can help me with this. I have been trying for ages to update a disconnected dataset and then write the changes back to the SQL database. However when I make changes to the relivant fields it updates the datagrid but does not write the edits back to the main SQL ...more >>

I have a typed DataSet that contains approximately eight DataTables with foreign key relationships that I am returning from a ASMX web service to a Winforms application. The rows of a few particular tables don't seem to be making it across the wire. * I can verify that these particular Dat...more >>

I am going to select buch of rows from database and update a field in them ,is there a good way of doing that ? thanks for your help. Ali-R ...more >>

Hi, I'm trying to open a connection to a SQL Server DB in C# (so that I can later execute a stored procedure). The code I have included below produces the following exception when "connection.Open()" is executed: Unknown ProviderConnection string is not valid In reading some of the o...more >>

Hi all, I have a DataTable Column which expression Property is valorized like this: Tbl.Columns["Elimina"].Expression = "'<INPUT type=\"button\" value=\"Elimina\" class=\"Testo\" onclick=\"CallDeleteDialogBox(' + " + "CONVERT(" + Tbl.PrimaryKey[0].ColumnName + ",System.String)" + "+ ')\">'...more >>

I am trying to execute the following stored procedure: sp_help_job on msdb on a SQL Server 2000 installation under the context of a user that is just a standard sql server login. Not a sysadmin. If i run it under the context of a sysadmin i get results. However, if i run it under a basic u...more >>

I want to use the parameters call like this: cmd.Parameters.Add(new OracleParameter("arg_username"), OracleType.VarChar, strName, ParameterDirection.Input )); but the Microsoft OracleClient driver does not allow the above syntax, I have to provide a ton of other parameters. I see people u...more >>

Hi, friends, In a VC# app, I have a DataGrid with DataTable as its SourceData. This DataTable has a ColumnStyle collection for each field. In Form_Load event, I set myDataGrid.AllowSorting = false; However, when the form shows up, I can still sort each column. Any ideas? Tha...more >>

Can I use ADO.NET to connect to a mdb database? I have not been able to find anything on this. Also, I am trying to use ADO in VB.NET and for some reason I can't seem to get a command to work. The code is below Imports System.Data.Odbc Imports System.Data Imports System.Data.OleDb ...more >>

Hi We have an access db which records daily orders. We would like the orders to be downloaded to a windows mobile 2003 device via usb cradle. Drivers then take along the device and get signatures from customers when items delivered. Once drivers are back, the information to be synched back to ...more >>

I am Italian developer, escuse me for my bad English I have a problem with ODBC. I must link to a database from Visual FoxPro, I have installed Windows XP Professional with service pack 2. When I try to install driver for Visual FoxPro i see the message: “Error 1918. Error installing ODBC ...more >>

Hello I am developing a multi-thread app. In this, each thread must take a number from a table and then update table with the number + 1. This number is to insert in other table by primary key. My problem is while I select number and update number, because other thread may be read this numbe...more >>

Hello I' want to build a fully editable webformdatagrid. The cells have to be textboxes all the time (this I already realised with columntemplates) and the update for all changes has to be done by one Update-button which uses the DataAdapter.Update Method. Problem is: The DataSet does not see...more >>