I have Management studio 2005 express. I can't find how to convert access database to sql server 2005 express. Please help. ...more >>

I have an app that generates a lot of data for multiple tables (on one database). This seems perfect for the SqlBulkCopy object which, according to the docs, can be used to handle this case as long as the properties on the object are changed prior to each call to WriteToServer (DestinationTab...more >>

Hi Is there any way to refresh a DataSet after inserting few records in a table (containing foreignKey column) using adapters' InsertCommand and ExecuteNonQuery(). I tried adapter's Fill(dataSet) but it does not add the new records inserted to the dataset's table. I am doing something like:...more >>

hi, i'm using the .net OleDBprovider to read the data from excel file... but sometimes the data from the few of the cells of excel gets truncated... i'm not getting the whole data..if the data length is greater than 255 characters... how can i solve this problem? ...more >>

Form1 has controls that are bound to columns in a table. "New" button on Form1 opens up Form2, which queries user for new record. After Form2 closes, how do you refresh the data displayed in the controls of Form1 to reflect the additional record? Thanks, Marty ...more >>

Hi This code does not update the copyTbl rows. I.e. when the copyTbl object is merged into the dataset actions on the rows of this table are not reflected in the copyTbl. I want the copyTbl to reflect changes made to the ds.Tables["Sets"].Rows. private void PopulateCopyTableFro...more >>

I have a combo box in which I want to display the distinct values in a field in a table. Depending on the table name and the field name entered by the user, I build an sql statement _Sql = "Select distinct " + _fieldName + " from " + _tableName and fill a dataset with the results How d...more >>

I have a simple Windows form bound to one SQL Server table using the BindingSource control. I would like to use the BindingNavigator control to navigate through records. One text box holds a required field. When I click the AddNew button on the BindingNavigator, a new record is added to the Data...more >>

I have this stored procedure on a SQL 2005 database that when invoked from query analyzer or SQL Server Management studio runs in 2 seconds. However, the following code times out on the executeScalar call: DbCommand cmd = cnn.CreateCommand(); cmd.CommandText = "spc_search_item...more >>

I am very new to C# with little experience with stored procedures (former Coldfusion developer). My problem is that I have two csv files (output from SAP) that I need to import into two tables (after deleting current data) on a reoccuring basis (about every 30 minutes). I have already figure...more >>

I would like to make a subclass of System.Data.DataTable with this method pseudocode: " for each DataColumn, change the ColumnMapping to MappingType.Attribute " However, I am not sure where I should put this kind of logic so it is only executed once. The DataTable may be populated...more >>

In VS 2003, used to be able to drag a stored proc (that had multiple selects) onto the designer and it would create a datatable for each select. In VS 2005 it only creates a datatable for the first select. I sometimes do multiple selects to save round trips to the db. Also, after going th...more >>

Dear all, I have to perform a programatic reconciliation of two sets of data which are based on the same schema. I thought a brilliant way to do this would be to use the dataset.getchanges() method, and then write the changes out as a diffgram using the dataset.writexml() method. The way I ...more >>

..NET 2.0 I've heard rumors that .NET 2.0 contains a functionality which automatically can convert a database table into a .NET class. This functionality is being used as part of the Data Access Layer... Is this true? what is it's name? I think the name is something like DOL - Data Object L...more >>

..NET 2.0 I wonder how a Data Access Layer should be created using best practice! So if you have a link to an article about this subject then please post it here I've heard Microsoft has a special pattern for this, but I have forgotten it's name, I think the name is something like Data ...more >>

I am trying to understand datasets. It says its disconnected blah blah..... Can some one explain me what happens exactly when... Say I have asp.net page in which Page_load is opening a dataset. So for every request will a separate dataset be opened...say 100 users are requesting so will the...more >>

Hi, Enviornment : Visual Studio .NET 2005 and SQL Server /Access I've spent 2 days searching for an answer to this problem which I am convinced is simple - if you know how. I can't get VS to create the TableAdapter classes for me to use in my .NET application. I run the TableAdapter Con...more >>

I want to develop a non-ASP C# application. My program will include a TreeView control that the user can add and remove items from, and I'm considering the possibility of using ADO to store my tree data. Can anyone tell me if it makes sense to use data binding between ADO and a TreeView ...more >>

Hi all, Though this question is probably more focussed on SQL, I thought I would post it on this forum in case someone here can help me with an answer. I have a single SQL table that has many columns and rows. What I want to do is to take one column in a table, (one that contains short str...more >>

I've discovered something odd (it seems) with using Typed Datasets to bind to an Infragistics WebGrid I have on my ASP.NET (2.0) webform. Essentially, if I set up a Typed Dataset (using Stored Procedures for all data access, including select, update, insert, and delete), and then create t...more >>