How abou joinview in 2005 ? Its needed...more >>

I have a control which binds to a DataSource (DataView) but doesn't have a BindingContext. Is there anyway to attach a CurrencyManager to this DataView? Thanks, Joe ...more >>

I want to do the following: - have a combo box linked to the Customers table - have a list box linked to the Orders table When I select a Customer from the combo, the list box will display all the Orders from that Customer. So far I managed to make the connection to the database and 2 sql d...more >>

Hi I have a stored proc with a varbinary OUTPUT param and I am trying to retrieve the value of this variable in the C# using SqlCommand and setting its parameters. However, I am not able to retrieve the value of varbinary variable in C# for some unknown reasons. I would really appreciate yo...more >>

Hi, I installed SQL Server 2005 Express on one of my development machine, I had since then having problem connecting to a SQL Server 2000 (On a cluster) database. The problem persist even after I remove SQL Sever 2005 Express. The following is the error message: SAC.EDS.CorpAction.Withholdi...more >>

Hi, I'm using Microsoft's data application blocks to execute a stroed procedure that look like this: (Note that I have not included the package declaration nor the T_CURSOR type declaration since it's working fine when I execute this procedure in a tool like TOAD or else) PROCEDURE qryTest(EM...more >>

I keep getting the following exception... A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Error: EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'. why would i be getting that? I have SQL debugging disable...more >>

Here's the scenerio: HAD: Entire Windows 2000 domain multiple servers Internal Web Server - Windows 2000 NAS Server - Windows 2000 Internal Web Application (On Web server) utilizing .ASP scripts to access shared directories through mapped drives on NAS Server. (And yes, I know UNC pat...more >>

Hi, I encounter the following error System.Exception: Could not create an environment: OCIEnvCreate returned -1. when i try to run a simple program of ASP.Net (databinding example) that connects to an oracle database. I have included the program: ----------------------------------- P...more >>

MyCase: I have an excel file Example1.xls which has file columns say A,B,C,D,E. Now when some error occurs i have to retrieve data from the input row index (this im doing by retrieving from the dataset) and insert the same data along with a new error message into the same file Example1.xls. So...more >>

Hi, I have to do queries between 2 databases and with dao/vb6 I've linked all tables of database 1 into database2 as followed and can than do the queries in database 2. Now I'm beginning to transfer the project in vb.net and I think db-functions should be transfered in ado.net. But how can ...more >>

Hi, I would like to build my app so it can connect to SQL Server, Oracle or mySQL and query data. Data queries should be parameterized to reduce impact of SQL Injection. SQLServer Dataprovider uses named parameters (i.e. @name) OracleClient Dataprovider uses named parameters (i.e. :name) ...more >>

Ok, let's say I have a web form with two textboxes. Let's also say I want to enter my first and last name into them. How would I bind these textboxes in a Visual Studio 2005 webforms ASP website ? What would I do to insert FirstName and LastName into a table called names ...more >>

Hi, Using VS2005 and ADO.NET 2.0, How can I build a typed dataset based on an Oracle stored procedure? Thank you, Alan ...more >>

Hi, My apologies if this is a simple question but I'm having a hard time making any progress so... I'm looking at VB ADO.net, moving from ADO / Access development. I've created a bog standard windows app in VB2005 Express and having read some of the basics am attempting to create a conn...more >>

Does anybody have strategies on when to through your Data Access and Middle-Tier into a Web Service opposed to a Control Library? I mostly deal with intranet ASP.NET web applications, and occasionally create web services that access my Data Access (which is in a control library). Right now my...more >>

In VS 2005 I've used the Data Source Configuration Wizard to create a MyDataSet.xsd, but I'm lost on how to get anything out of the .xsd into a workable ADO.NET dataset?? Any suggestions? Thanks, Rob. ...more >>

First time through on this, so I could use some help. I'm having difficulty getting data from a stored procedure into a DataGridView control in a Windows form. I'm using VS2005 and C#. My test program has two DataGridView controls. One is populated via SQL generated via drag/drop/propert...more >>

Hi, I have two dataGrids bound to two different datasets, which relate to each other as parent/child. The primary key/foreign key columns are hidden in the DataGrid. If I select a Parent the corresponding child's are displayed. I want to add a row to the child, with the currently selected par...more >>

Greetings, I am new to this and have some problems. I created a dataset using the vs2005 GUI and want to load the dataset using code in the back end I have: XmlDocument xmlDoc = new XmlDocument(); dsSampleTableAdapters.tblSamplesTableAdapter sample = new dsSa...more >>

I am getting the following error in my application: New request is not allowed to start because it should come with valid transaction descriptor. This is happening under a very singular circustance: I have just migrated to SQL server 2005 and ASP.NET 2.0. It is not happening all the time...more >>

Hi, I am writing an application where the select command returns multiple record sets and write the infomation to a xml file. I used typed dataset to store the returned info and use the dataset.writexml command to save the data to a xml file. Oh one more thing I am used the DAB (data applicat...more >>

Hi! Does anyone know of a way to tweak the code generator for the strongly typed data sets to allow nullable types? For example, the datatype "decimal" should be generated as "decimal?" instead. regards Carl ...more >>