tagged [dataset]
Copy DataTable from one DataSet to another
Copy DataTable from one DataSet to another I'm trying to add to a new DataSet X a DataTable that is inside of a different DataSet Y. If I add it directly, I get the following error: > Do I have to clo...
Convert DataSet to List
Convert DataSet to List Here is my c# code It uses a loop to create a List from a dataset.Is there any direct method or shorter method or one line code to
Update DataSet structure in Visual Studio to match new SQL Database Structure
Update DataSet structure in Visual Studio to match new SQL Database Structure After making some changes to my SQL database structure (using scripts in SQL Server Management Studio), how can I update m...
- Modified
- 29 Feb at 10:50
How to delete the first row of a dataframe in R?
How to delete the first row of a dataframe in R? I have a dataset with 11 columns with over a 1000 rows each. The columns were labeled V1, V2, V11, etc.. I replaced the names with something more usefu...
Looping through a DataTable
Looping through a DataTable Well. I have a DataTable with multiple columns and multiple rows. I want to loop through the DataTable dynamically basically the output should look as follows excluding the...
What is the difference between "LINQ to Entities", "LINQ to SQL" and "LINQ to Dataset"
What is the difference between "LINQ to Entities", "LINQ to SQL" and "LINQ to Dataset" I've been working for quite a while now with LINQ. However, it remains a bit of a mystery what the real differenc...
How I can filter a dataTable with Linq to datatable?
How I can filter a dataTable with Linq to datatable? hi how i can filter a datatable with linq to datatable? I have a DropDownList and there I can select the value of the Modul Column. Now I want to f...
- Modified
- 18 Oct at 12:27
Direct method from SQL command text to DataSet
Direct method from SQL command text to DataSet What is the most direct route to get a DataSet if I have a sql command? I started with `SqlConnection` and `SqlCommand`, but the closest thing I see in t...
Check dataset is empty or not
Check dataset is empty or not This is working for me just fine. With if checks if dataset is empty or not. If so, return null value. But is the check of dataset right way or should i do some other way...
LINQ TO DataSet: Multiple group by on a data table
LINQ TO DataSet: Multiple group by on a data table I am using Linq to dataset to query a datatable. If i want to perform a group by on "Column1" on data table, I use following query Now I want to perf...
C#, Looping through dataset and show each record from a dataset column
C#, Looping through dataset and show each record from a dataset column In C#, I'm trying to loop through my dataset to show data from each row from a specific column. I want the get each date under th...
Select method in List<t> Collection
Select method in List Collection I have an asp.net application, and now I am using datasets for data manipulation. I recently started to convert this dataset to a List collection. But, in some places ...
Test for null values in C#
Test for null values in C# If I do something like: Is there a good way to check for null values without using the try/catch? It's just that I don't care if the value in "col1" is null, OR if "col1" di...
How to fill Dataset with multiple tables?
How to fill Dataset with multiple tables? I'm trying to fill DataSet which contains 2 tables with one to many relationship. I'm using DataReader to achieve this : ``` public DataSet SelectOne(int id) ...
- Modified
- 3 Jan at 16:47
Combining two results of datasets into one
Combining two results of datasets into one I have created a webservice which returns two datasets(return type) as results. Is it possible to combine two datasets results into one so that I can display...
- Modified
- 2 Jan at 07:2
How to bind crystal report to manually created DataSet
How to bind crystal report to manually created DataSet I wan't to create DataSet from code and set it as data source for crystal report. I don't want to create a DataSet xsd file in VS if I don't have...
- Modified
- 1 Dec at 12:50
How can I convert a datatable to a related dataset
How can I convert a datatable to a related dataset I have denormalized data in a DataTable. The data contains employee names, and the pay they got over a series of pay cycles. i.e.: My DataTable conta...
Select single column from dataset with LINQ
Select single column from dataset with LINQ Just getting my head around all this LINQ stuff and it seems I'm stuck at the first hurdle. I have a datatable as such: ``` OrderNo LetterGroup Filepath -...
- Modified
- 13 Dec at 20:49
Casting generic datatable to typed datatable
Casting generic datatable to typed datatable I need to reuse a DataAccess method prescribed by client. This method returns a vanilla datatable. I want to cast this datatable to my Typed datatable. The...
- Modified
- 23 May at 11:46
How to move a DataTable row to the first position of its DataTable
How to move a DataTable row to the first position of its DataTable I want to get a specific row on an asp.net DataTable and move it to be the first one onto this DataTable base on a column `column1` v...
DataSource error: "Cannot Bind to property or Column"
DataSource error: "Cannot Bind to property or Column" I'm working on a database in C# when I hit the display button I get an error: > Error: Cannot bind to the property or column LastName on the Data...