Hi guys, for a while now, we've been flirting with the idea of having a single component in our app that handles all the plumbing for our Db calls ( creating connections, Commands & Parametes etc. ) through an xml definition of each Db call. For instance, a call to a Stored Procedure would ...more >>

I'm interested in the ASP.NET 2.0 Member Services and have a copy of AspNetDB which is created by default when using VS.NET 2005. The problem is I don't have a MS-SQL version and Microsoft has apparently dropped support for the default creation of AspNetDB. I'm hoping somebody knows if there i...more >>

I am getting a connection exception when trying to access an SQL Server which is NOT localhost through a Windows SERVICE. Following are the situations: (1) DOES NOT WORK: Windows SERVICE Windows Service Sql Connection = Data Source=ENTERPRISE;DataBase=CRM;Integrated Security=SSPI; S...more >>

Hi , I use a procedure to get list of all users and show them in a datagrid/datalist/etc.. with SqlDataReader . How can i list X item (lets say 50) on the first page , 2. 50 on second page and so on ...more >>

here is the sort of query I want to use to bind data to some control: SELECT employee.lastName, employee.firstName, account_supervisor_int.acctCode_ID_FK, account_supervisor_int.employee_ID_FK, employee.employeeID, account.acctCode, account.acctnum FROM employee, account, account_supervisor_i...more >>

Hi, I am trying to do the following in ADO.net using C#. I need to do an update, select, update statement as a single unit using the same DB connection. Is that possible? The database doesn’t support stored procedures/functions. I also want to make sure that it is locked while doing all t...more >>

I have a class that inherits from Dataset. I have couple of methods that extend functionality of the dataset to fit my specific need. I also have a SQL helper class that has method Execute dataset. Its brings back filled dataset. When i do : MyDataset ds = new MyDataset(); ds = (MyDatase...more >>

Hi all, Can Sql Server Fire an event to ado.net? Meaning...can I have a "trigger" raise an event that I can pick up via ado.net? What I'm trying to do is when a certain datafield is changed...my asp.net app can respond to it Best Regards, Mekim...more >>

Hi, I have a super-basic question for you: I have a typed DataSet which contains several tables. Throughout my WinForms app, the user has a chance to modify this dataset and submit these changes to the server. Prior to submission, the user will be given the option to "Save Changes" ...more >>

Hey. I'm new to Access, and need help creating a report, and I thought using a crosstab query would be the best way...now I'm not sure...here's the simplified report I'm trying to create: Year 1 Year2 YTY Margin Vendor Cost | #Units Cost | ...more >>

If I am using ADO.NET in a VB.NET screen to do inquires, updates, deletes etc on an MS Access database, does the client or the server that the application resides on have to have MS Access installed? Or are the MS JET access routines inherent in the ODBC access methods I'm using?...more >>

I am getting an exeception when I access an SQL database (on another machine) from a 'Windows Service'. The same code works if the SQL Server is local or code is in a Windows Application. Following is exception from Event Viewer: Event Type: Error Event Source: TestServ Event Category...more >>

Environment: Web server IIS 5 running on Windows 2000 (SP2) Oracle Client 8.1.7 Coonecting to Oracle 8i DB running on Unix ADO is used as connecting mechanism (MSDAORA) Synopsis: Curently we are using ADO (MDAC 2.5) to connect to Oracle 8i (Oracle client 8.1.7). We are using ...more >>

Hello, I use oracle 9.2, I have a trigger on a table. When I update my table the trigger generate the error: error ORA-01403: No data found But no exception is generated with my System.Data.OracleClient so in my c# code I don't know that an error occured!! Why ? What can I do to detect the ...more >>

I'm still having problems with the RowChanged event on the DataTable. I need to find an event which runs after a new DataRow has been added to the DataTable's Rows[] collection. Clearly, RowChanged() is not that event, since the "e.Row" event argument is not in it's own DataTable's Rows[] ...more >>

I'm getting this error message: A severe error occurred on the current command. The results, if any, should be discarded. I am using 2 SQL Servers A and B. Server B is a linked server on Server A. I am using ADO.NET to run a stored proc on Server A that calls another stored proc on Ser...more >>

Hi, I've got a problem with the DataBindings. I've got a form with 3 textboxes and also one DataGrid which shows the details for the the current record. I've got a DataSet with two tables in it (Master/Details). I created primary keys and set a relation between those two tables. In Addition...more >>

Hi, I have a DataSet with two DataTables. Both tables have the same primary key, say "ID". I am binding Table[0] to a Grid Control. Now I would like to create a DataTable that contains all the rows from both the tables, so that I can bind it to a Grid and see all the rows from both tables. Ho...more >>

I've been coding asp.net sites for a while now and this is beginning to really annoy me. SqlConnection.open takes roughly 26 seconds to complete the first time the site is run after a new compile, whether in debug or release. After its happened once i can render pages in no time at all, its ...more >>

I am using dynamic SQL inside my stored procedure because I need to use a variable with the TOP keyword. When I drag this stored proc on to my XML schema file inside VS.NET, the schema is not generated, which I think is understandable. Is there something that I can do to have a dynamic SQL b...more >>

A typical szenario in a database-centered application is that a user (accidentally or on purpose) requests data that would result in a very large result set, may be millions of rows. I really like the way how MS Access handles that problem. The first records are displayed as soon as they are ava...more >>