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 >>

I created some very simple ASP.NET applications - form data is entered into an Access database. There are 4 of these apps - all similar in nature and even connect to the same database just different tables via stored queries. All of the apps were working fine on the web server. Then I recent...more >>

All, What kind of data type should I use to definde a timestamp (row version) data-type in MS SQL Server for a column in a dataset? I tried to define it as byte[], but MSDataSetGenerator is giving me the "unable to convert xml file content to a DataSet" error. Thanks, John Yung ...more >>

Hi, everyone, I ran into a serious bug upgrading to VS2005, and very easy to reproduce. It goes like this: 1. Filter a DataView 2. Get a reference to a DataRowView 3. Clear the filter - the reference to the DataRowView has changed to a completely different row! This is not a problem in ...more >>

I have a table with a datetime column. Then, in my C# program I open a datatable with that column in it and access it with the following syntax: dt.rows[i]["datefield"] Now, when I look at the data in the table from say Enterprise Manager, the row in question has an "11/17/2005 8:15:29 am...more >>

Hi all, I am having a problem with using SqlCeDataAdapter to update the database. I am working with the dataset and the data adapter to do my Select,Insert,Update,Delete . The Dataset holds the results of the select commmand and I store the adapter in a Hashtable .When the user does an inser...more >>

Hi there, I was loading a datatable with Dataadapter's Fill() method. Then, I could add a new record to the datatable and it won't complain about not null columns until I called the Dataadapter's Update() method. That's OK for me. Now I am experimenting with the Load() method of a datatabl...more >>

I'm using the OleDbConnection object to retrieve the contents of an Excel Worksheet as a DataSet. This works fine when testing the MyExcel.GetMonthly() method call. When I call MyExcel.GetMonthly() from a Serviced Component, it bombs. Code snippet: OleDbConnection cn = new OleDbCo...more >>

Is there any possible way to get messages asynchronously sent from a stored procedure running on SQL Server 2000, back to ADO.Net, in realtime (or at least somewhat close to it)? After much experimenting, I am left to say "no"... it is not possible. Although it would appear it should be. On...more >>

Hello, Here is the error message; ---------------------------- Exception Message: ForeignKeyConstraint Lkp_tbl040Cmpt_lkp302SensorType requires the child key values (5) to exist in the parent table. ---------------------------- I am encountering this error when I try to insert records i...more >>

I need to compare the values of two datasets and retrieve the differences into a third dataset. I need to retrieve Employees names and numbers from Excel sheet into ds1 and retrieve Employees names and numbers from SQL Employees Table into ds2. I did this part successfully. Now i want...more >>

Hi, I'am developing an asp.net app that is using an sql server. How should I deal with transactions? Should I do the transactions in my stored procedures or should I use Serviced Components or... Thanks...more >>

Creating a datatable from scratch and then I'm inserting with a select in the sproc to return the current values after the insert. Now I realize the timestamp column is a datatype of byte, and I'm not trying to insert the timestamp, but I want to keep the column in the datatable to be populate...more >>

Hi all. I am trying to resolve this seemingly very simple and not to mention well documented problem but just couldn't seem to get it to work. I have a datatable that uses an identity column as the primary key. I need to get the value of the identity column back after performing an insert to the...more >>

what are the conditions in order to bind to an object? i have an object, which implements the IList interface. Now I'am able to bind the objects, which are hold by the collection. now i implemented two properties in my collection. but i'm not able to bind to the properties of the collection...more >>

Hi all, I am trying to use System.Data.ODBC to insert a file into a binary field in SQL Server 2000. Now, before you yell at me, the reason I am doing this is that I am only writing intitial code against SQL, but this app will need to be able to run against any ODBC compliant DB, so I am ...more >>

Hi folks, I have an form where there are two text boxes bound to an object via a BindingSource. I have implemented a document save function via Binary Serialization that writes the underlying object to disk. The problem is, if a user edits the data in one of the text boxes but DOES NOT l...more >>

Hiya, I'm mucking around with .net 2, and experimenting with the BindingSource control. I've set the datasource to a dataset and set the datamember property as the table (or perhaps i've directly set the datasource to the table and left the datamember as null). When I run the Clear() meth...more >>

I wish to display, in a datagrid, only six columns of a table containing about twenty. I've created a data adapter which selects only the desired columns. I created a dataset and a dataview, and specified the dataview as the data source for my datagrid. The datagrid displays the 6 desired...more >>

I wrote an application using c# and mySQL database. But when I deploy it doesn't work on an other PC. How can I embed mysql in C#. A code example will be quite helpful for me. Any help wll be appreciated. ...more >>

Hi, I have a typed ds which contains a single table which in turn has a number of columns for which "min occurs = 0". The columns from this ds are bound to a bunch of controls on a form. I am having some trouble with the currencymanager when it comes to adding a new row, as follows; 1. A...more >>

What's the best approach to retrieving schema for an untyped dataset? Do it manually, an empty sproc, what else? ...more >>

With SQL Server 2000 with SP3a we used to be able to debug our Stored Procedures by stepping into them via our ADO .NET code, but we have recently upgraded to SP4 and can no longer do this unless we connect as 'sa'. We have made sue that the Extended Stored Procedure sp_sdidebug can be acce...more >>

Hello, i written a collection which holds instances of a specifc class. i added a binding like that textBox1.DataBindings.Add("Text", ((MyClass)oMyCollection[1], "Description"); If the content of the textbox changed, the values are saved in the object of the collection where the contr...more >>

After spending a few hours experimenting the typed dataset serialization (see previous post "How to include public properties in a typed dataset in serialization"), this is what I found which does look like a bug (I'm using the normal serialization with XmlSerializer): .. The values for th...more >>

I have a datagrid that consists of a data-bound hyperlink column binded to the "Song Name" column of the data source. When user clicks on one of the links, the associated media application such as RealPlayer or Windows Media Player will be launched. I searched through the MSDN Library and f...more >>

for example: connectionstr="DATA SOURCE=192.168.1.11:1521;UID=bnd;PWD=bnd;" instead of connectionstr="DATA SOURCE=sid;UID=bnd;PWD=bnd;" new oracleconnection(connectionstr); is it ok, and what is the format of data source?...more >>

Is there out a Query Builder Tool that is possible to integrate into my application ? Mainly for MS SQL Server. Which one do you recommend ? Thanks in advance ...more >>