Hello, I just purchased Visual Studios 2005. I noticed that when I drag a control from the DataSources toolbar, or set the datasource property of a datagridview, that code is automatically generated in the forms load event to fill the dataset. How can I disable this feature? I normally fill...more >>

Hi, I am trying to merge two datasets into one, each dataset has one table when I merge the two datasets I get a dataset with two tables? I need the merged dataset to only contain one table with the merged data. Does anyone know how to avoid this? ...more >>

Hi I have a sub method that has been passed a dataset as parameter. I need to insert this dataset into a table. What is the code that I need to do this? The dataset does not have any conflicting keys so it is a very easy scenario from conflict resolution point of view. Thanks Regards ...more >>

So far the dataset just shows Type, Benefit, Change I want it to show Type, Benefit, Change, Description This should be a pretty elementary question - and I've spent 2 days on it already. I just want to add one field from another table into my dataset, should be easy, but maybe it's the...more >>

it seem that data table and Expression field have a lot of Laks, it is true? the DataTable is powerfull of Memory relation data that bind to controls. so i can load data from remote service and manipulate it and after i send update to remote service. But, when i need to make standart oper...more >>

Hi all, I need a quick way to create a new datarow based on an existing one change a few values and update them to the database (the duplication should be made in the same db table). I've seen previous posts suggesting to use the ImportRow method for the datatable... i've tried it.. i...more >>

New feature come in VS 2005, ability to ADD local database files (.mdf) into project. When i install my EXE on client PC, I need install SQL server? ...more >>

Hi, I have an sql server on seperate system and my application runs on another dedicated server - both the machines works on Windows 2003 server OS. From last 2-3 days one of the .net application which has been working fine for the last 1 year suddently start giving timeout error when query...more >>

How to generate a dataset from stored procedure which have many resultsets? I try Dataset designer from VS2005, it only generate first table from stored procedure on server explorer. Another table cannot to generate. How should I do? ...more >>

Hi How can I insert a dataset into an sql table? Thanks Regards ...more >>

If I only have ASP.Net 1.1 installed on a server what would I replace this with? <dataProvider name="SqlClient" connectionType="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> Thanks ...more >>

I have typed DataSets in a data access tier and want to pass a connection string from the client at run time (for use by the TableAdapters created using VS2005). However, at design time, VS2005 sets the connection string as a property (i.e., serialized to app.config). This is ok for design...more >>

Hi, Where does the datareader store it's data in this scenario: Create sqlconnection, Create sqlCommand - query specified here could return 1000 rows SqlCommand.ExecuteDataReader, returns datareader use DataReader.read to iterate through the rows. As far as I understand all the 1000 rows i...more >>

Hi everyone. I have a small problem that I can not seem to resolve. I am executing a stored procedure using the ExecuteReader method. However it is failing. Here is my code in short. I debugged it using Sql profiler it appears that my currentdatetime parameter is going to the next line and I a...more >>

I'm using the SqlCommandBuilder to help construct the update commands to a SQL Server 2000 database. I have the SqlCommandBuilder generate the initial command text and then modify the CommandText to use primary keys to specify the row to be updated. With the 1.1 Framework on a machine (that...more >>

Hi, when you load a child row when the parent row doesn't exist in a relational dataset an execption is thrown. Is there an event to capture this occurence before the exeption is thrown? Thanks Bart...more >>

... ...more >>

This is a union query from an Access Database But I will also be using SQL server For the meantime in Access, I want parameters MRN, [GROUP] and SGR For the following UNION query - (how should I go about this using ADO.NET?) SELECT 'Inpatient' AS Type, [IN-BNFT] AS Benefit, [IN-BFC...more >>

Hello I use the data source window to connect to a database. Because the location of the database might vary, I want to change the connectionstring at runtime via my.settings.... but this is an application setting which can't be changed at runtime. I know how to accomplish a connectionstring ...more >>

Hi, Is there an equivelant to the old ado recordset which you could use the movenext/moveprevious methdods with? If not, what do you use to do this in ADO.NET? What would be the steps invloved in creating the equivelant object & how do you iterate through the 'record set'? (I'm using c#) ...more >>

Hi all, Merry Christmas! I have an application that reads records off an Excel spreadsheet and imports them into an Oracle database. What I have in my application is a subroutine that opens a database connection, sets up the command and parameters, and executes a stored procedure in t...more >>

Hi All, I want to update the values into database.And i get these values from a xml file.I have done the coding for that but its not getting updated.Plz tell me whats wrong in my program.if possible provide me some code for this...... DataSet XMLDataSet = new DataSet(); DataSet Sq...more >>

How do most people support multiple database types such as SQLServer, Oracle, Access, etc.? Mainly I am wanting to just support MS (SQLServer and Access) but may need others in the future. I am currently looking at creating a simple class that has a few methods for creating and accessing an...more >>

Hi, I'm trying to distribute my application written using .NET Framework 2.0. It uses a MDB file for it's database. On certain machines with Windows XP (I have also tried updating them to SP2), I received this exception when the application tries to connect to the MDB "The .Net Framew...more >>

I notice that after converting a vs.net 2003 ASP application to vs.net 2005 that my DataAdapters are gone from the design view along with the ability to enable the Data Adapter Configuration Wizard !! Surly you are not going to tell me that my Data Adapters can no longer be maintained (effi...more >>

I saw a lot of people were having a problem with this and I found an elegent solution to this problem so I decided to post it. Use the following Example: --------------------------------------- private void BindingNavigator_OnSaveItemClick(object sender, EventArgs e) { ...more >>

I have a combo box that inherits from DataGridTextBoxColumn. Everything works fine with the control except a CancelEdit(). The underlying rows' value is rolled back but the DataGrid column still displays the new value which was cancelled. Am I missing an event my control needs to receive th...more >>

Hello I want to ask how to connect a vb.net window client application to a remote MS Access databae which is located on a server? How to set the connection string in order to do so? Thank you ...more >>

Hi, I Want to update My Database , i using sqlDataAdapter and i have all the command (Insert/select/delete/update). I dont want to use update method cause i want to delete first from one table and then insert to the other so i want to Insert/update/delete in my way. Can i choose when to use D...more >>

I have to create an SQL statement at run time based on the items the user selects on a report menu. The SQL statement gets quite complex if you have 13 menu items each having associated WHERE cretria. I'm using StringBuider to build the statement Is there a simple way to create an SQL stat...more >>

Hi all, i am using Sql Connection with SqlHelper class; it is working fine with windows xp and MSDE; when i developed the application and tried it with Sql server200+ windows 2003 it gives Error message "The timeout period elapsed prior to obtaining a connection from the pool. This may h...more >>

I was having a problem using a DataTable targeted against a table with columns that have default values and do not allow nulls. When you added a new row to the DataTable, and call Update on the adapter. It uses the CommandBuilder to build the insert against the table. This insert has the ...more >>

Is there anyway new in SQL Server 2005 to enumerate all the servers on the network without sqldmo? I'm working in .NET and want to get the list, im doing it now in sqldmo and it works fine, but would like to do it with managed code instead of using a com object... ...more >>

I am using GetOleDbSchemaTable to read the data from the Excel file. It is working fine with all workbook/worksheets except the one that has numeric column names as headers. The connection string is strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + finfo.FullName + ";Ext...more >>

Any advice on how to use partial classes in C# to subscribe to RowChanging or ColumnChangine events???? http://msdn.microsoft.com/vbasic/default.aspx?pull=/library/en-us/dnvs05/html/newdtastvs05.asp is an excellent VB.Net article on using partial classes to validate changes to DataTable row...more >>

What is the easiest way to map table names when filling a dataset? I am filling a dataset from two tables. My command text looks like this: "Select * from FooTable; Select * from BarTable". After the fill, the dataset tables are named 'Table' and 'Table1'. So, I rename the tables using this...more >>