Click here to Skip to main content

Submit your article

Dataset

dataset

Great Reads

In Search of the Ultimate DataTable Serializer

by Massimo Fabiano

I know that "returning DataSets from WebServices is the spawn of Satan" but...

ASP.NET MVC - Generate Excel Spreadsheet from DataSet with Auto Size Columns, Auto-filter and Alternating Background Color

by Daniel Carvalho Liedke

Project to generate Excel Spreadsheet from DataSet with auto size (AutoFit) columns, auto-filter, alternating light blue background color with Open XML using ASP.NET MVC

typed programming the typed Dataset - for Beginners and others

by Mr.PoorEnglish

what is "typed" on typed Dataset, and how to use it

DataSet Vs SqlDataReader

by ASP.NET Community

Confused how to use DataSet and How to use DataReader?I am trying to give some of basic understanding about and differences between DataReader

Latest Articles

Creating a Custom De/Serializer

by Alaa Ben Fatma

In this article, we will walk through the basic concepts of de/serialization and how to create a very basic de/serializer.

ASP.NET MVC - Generate Excel Spreadsheet from DataSet with Auto Size Columns, Auto-filter and Alternating Background Color

by Daniel Carvalho Liedke

Project to generate Excel Spreadsheet from DataSet with auto size (AutoFit) columns, auto-filter, alternating light blue background color with Open XML using ASP.NET MVC

Print DataTable to Console (and more)

by yuvalsol

Print DataTable, DataView, DataSet, DataRow[] to Console, StringBuilder or Stream

Data Dictionary in C#.NET

by Mehedi Shams

Create a data dictionary for your database tables

All Articles

Dataset

Adding datatable into dataset is allways empty althout datatable has rows

9 Dec 2023 by Dave Kreskowiak

DEBUGGER! Ruin the code under the debugger and set a breakpoint on the line that fills the DataSet. Execture the code one line at a time and hover the mouse over variables to see their content. You could have figured this out in seconds! The...

Adding datatable into dataset is allways empty althout datatable has rows

9 Dec 2023 by Member 4529316

I have a Dataset with results I get from the DB, I keep that as a base dataset and would like any filtering will be done on the second Dataset. I ensure I have the filtered data on datatable but when I use dataset.table.add the dataset is...

C# dataset data filtering

6 Nov 2023 by Maciej Los

I'd suggest to read this: Filtering with DataView (LINQ to DataSet) - ADO.NET | Microsoft Learn[^] If you would like to filter the dataset using IN clause, then you have to use Any[^] method. See: List myset =...

C# dataset data filtering

4 Jun 2023 by Cesare Cogliandro

Good morning. I'm crushing my head to find a way to simulate the "IN (SELECT" sql clause. I have two tables in a dataset and a relation between them (i. e. Orders and Articles). I neeed to filter orders containing a given article (by Id or by...

What is the best way to communicate with the database through datagrid in C# WPF between dataset and entity?

7 Jan 2023 by mojtabahakimian

I use C# WPF, I am programming an accounting program with a SQL Server database, in this accounting program, data is inserted, updated, and deleted by the user directly in a data grid, which contains a textbox and Combobox elements. In an issue...

What is the best way to communicate with the database through datagrid in C# WPF between dataset and entity?

7 Jan 2023 by Graeme_Grant

Databinding with data models bound to the DataGrid. EntityFramework or Dapr is a cleaner and simpler database framework. There are plenty of Google searchable tutorials explaining how to do both.

How(fast way) to devide country map into suqare(4 points at fixed equal distance) and get 8 lat long at different zoom levels

24 Nov 2022 by Member 8840306

I am an new in map drawing.I want to generate data set.I have a county boundar lat long list by using it I generate the country borader using OpenGL. Counry borader data set is like this lat long 33.666 71.44 33.888 ...

How(fast way) to devide country map into suqare(4 points at fixed equal distance) and get 8 lat long at different zoom levels

24 Nov 2022 by Richard MacCutchan

As I suggested in your previous question on this subject at Download map at different zoom levels image fragment(suqare) for a scpecific country in image format (jpg) with lat long?[^], check the API documentation.

Download map at different zoom levels image fragment(suqare) for a scpecific country in image format (jpg) with lat long?

21 Nov 2022 by Member 8840306

I am new in drawing map country wise from scratch.Is it possbile to download the Image DataSet of map of a Spcecific Country in at different zoom levels image fragment(suqare) image format like jpg with lat long of each corner of square? I...

Download map at different zoom levels image fragment(suqare) for a scpecific country in image format (jpg) with lat long?

21 Nov 2022 by Richard Deeming

Have a look at OpenStreetMap[^], which has far less restrictive terms of use[^] than Google's maps.

I need only top 20 highest review count among all the cars bar graph?

21 Nov 2022 by Member 15839673

Basically, I have a dataset with car models and I need a bar graph where the highest review count of 20 car brands should be displayed in the bar graph! I have tried this below code but I am getting all the brand models from the dataset I need...

machine-learning

Download map at different zoom levels image fragment(suqare) for a scpecific country in image format (jpg) with lat long?

21 Nov 2022 by Richard MacCutchan

See Google Maps Platform �|� Google Developers[^] for details of how to get map data.

Problem converting dataset to list in c# using linq

2 Mar 2022 by Adil Liaqat

public List userAvailabilityCheck(createUserModel obj) { SqlConnection dbConnection = new SqlConnection(conntection); SqlCommand cmd = new SqlCommand("select_User", dbConnection); SqlDataAdapter da = new SqlDataAdapter(); ...

Database between two software

15 Feb 2022 by Vlad Calin

Hello, fellows! I hope you are doing fine these days. Currently I am working on a project at work, whose final goal is to create an interface between 2 pieces of software (I cannot mention which software, as it is a research project). The steps...

Database between two software

15 Feb 2022 by Maciej Los

In addition to solution #1 by OriginalGriff, i'd suggest to read these: Using SqlDependency for data change events[^] Query Notification using SqlDependency and SqlCacheDependency[^]

Database between two software

15 Feb 2022 by OriginalGriff

If you are going to use a database, use it properly - in a format where that data can be stored a single time and queried within that DB. Storing Excel files in your DB does not pass the second criteria and very often fails the first as well. ...

.net core 3.1 WPF - RDLC add data source throws error in VS2019

7 Jan 2022 by Viken Patel

I am trying to create a RDLC report in WPF. My .NET Framework version is .NET Core 3.1. Can you help me with this? While adding data source, I get an error Error Screenshot What I have tried: I have tried to build with x86 but still not...

.net core 3.1 WPF - RDLC add data source throws error in VS2019

7 Jan 2022 by Dave Kreskowiak

That error means you're trying to call a method or get/set a property on a object that is null, meaning that object doesn't exist. You haven't shown the code that's throwing the error, so this is about the most you're going to get for an answer....

Dataset values to store in list object

4 Dec 2021 by Zeeshan Dar 2021

DataSet values to store in List object I have a DataSet, that needs to be passed into a list object. Name of columns in DataSet are same as properties of list object. Example: Data Set columns PickupCity PickupState PickupCountry List...

Dataset values to store in list object

4 Dec 2021 by Zeeshan Dar 2021

Hi, After searching and few adjustments, below solution worked for me. Create helper class public static class Helper { public static List DataTableToList(this DataTable table) where T : class, new() { ...

Dataset values to store in list object

4 Dec 2021 by OriginalGriff

Try this: Conversion Between DataTable and List in C#[^]

Clear dataset, datatable

30 Nov 2021 by Gireesh B

Dataset. Tables. Clear() and Datatable. Rows. Clear() Not clearing the data. Data appending every time. Please help me What I have tried: Ds = new dataset( table name) Ds. Tables. Clear() Ds. Reset() Dt = new datatable(table name) Dt. Rows....

Clear dataset, datatable

30 Nov 2021 by OriginalGriff

I suspect that that code isn't being executed, or isn't affecting the tables you think it is: Dt = new datatable(table name) Dt. Rows. Clear() Dt. Columns. Clear() Dt. Reset() The last three lines are irrelevant, as the DataTable is already...

I need help to understand the dataset?

30 Jul 2021 by Member 15307080

so for the first data set(2015,2016,2017) you have to just divide the recycle_rate/Enery_saved for the particular waste type. for the second data set(2018,2019) you have to calculate the recycle_rate by doing...

data-visualization

how copy a datatable value to dataset datatable in vb.net 2005

21 Jul 2021 by Shanmugam Vasu

hi,please guide me, how copy a datatable value to dataset datatable. my sample code is below:dim dt as new datatabledim ds as dataset....ds.tables("Name")=dtBut it returns the error 'Property item is ready only'.Thanks

how copy a datatable value to dataset datatable in vb.net 2005

21 Jul 2021 by Member 14180938

Use this is the easiest way to copy datatable to another dataset ds.Tables.add(dt.copy)

C#: how can I delete from databound combobox (SQL, dataset)?

18 May 2021 by Flidrip

What I'm trying to achieve: To delete a row from SQL table1 where column1 = @myParameter. Where @myParameter holds the value of my current comboBox1 selection. My ComboBox populates fine, and is bound to a DataSet. This is my code: using...

C#: how can I delete from databound combobox (SQL, dataset)?

18 May 2021 by Flidrip

Thank you both for your inputs. As for why I couldn't delete any rows, I figured out what the problem was. My code that gave value to my parameter for the DELETE statement, returned: "System.Data.DataRowView" E.g. it returned the object, and...

C#: how can I delete from databound combobox (SQL, dataset)?

18 May 2021 by OriginalGriff

var i = comboBox1 comboBox1.DataSource = null; comboBox1.Items.Remove(i); What on earth did you expect this code to actually do? Remove an item from itself? You do understand what a combo box list is, don't you? You don't change the ComboBox:...

I need help to understand the dataset?

10 May 2021 by Amr Mahmoud 2021

-1 i need to know how can i calculate how much energy in kiloWatt hour (kWh) has Singapore saved per year by recycling, by using this data? waste_type: The type of waste recycled. waste_disposed_of_tonne: The amount of waste that could not be...

data-visualization

I need help to understand the dataset?

10 May 2021 by Member 15192276

Use just the recycled_waste feature and the energy_saved in the energy dataset to get the energy saved for each waste type and the total sum.

data-visualization

How to apply a function in pandas time series

11 Feb 2021 by Member 14779487

hi Stdev = Sample Standard Deviation Ln = Natural Logarithm Sqrt = Square Root volatility Index = Stdev(Ln(P1/P0), Ln(P2/P1), ..., Ln(P30/P29)) *Sqrt(365) i want to write this code on a data frame like this Date Twap...

Call data in xarray using long and latitude

24 Jan 2021 by EngAb1989

I have the problem that inside my nc dataset: Dimensions are x and y Coordinates are longitude and latitude: Dimensions: (x: 521, xfit: 6, y: 420) Coordinates: longitude (y, x) float32 ... ...

Call data in xarray using long and latitude

24 Jan 2021 by CPallini

When working with floating point values you usually search for the 'nearest value' match instead of 'equal value' match (there are good reasons for that). In order to search for the 'nearest value' match, a good strategy could be a binary search...

Configure Entity Data Source Shows an Error Entity Framework 6.1.3

16 Oct 2020 by sreeyush sudhakaran

Hi, When I tried configuring the EntityDataSource of my ASP .NET 4.5 WebForms Project and Selected named connection , It Popups an Error message as below"The metadata specified in the connection string could not be loaded.Consider rebuilding the web project to built assemblies that...

Configure Entity Data Source Shows an Error Entity Framework 6.1.3

16 Oct 2020 by Member 14967439

1. go where you project is located(open Solution explorer. right click on solution and click on "Open Folder in file explorer" 2. open EDMX file with notepad and change ProviderManifestToken="2012" to ProviderManifestToken="2008". save it 3. ...

Create a graph and a report from same dataset in rdlc reports

29 Jul 2020 by Member 14898617

I have created a winform data entry connected to .accdb as source The entry part is done, and i have given a button to open another which must contain the summary of the data in table & in graph format. I have created the table successfully in...

Create a graph and a report from same dataset in rdlc reports

29 Jul 2020 by Richard MacCutchan

As with this question you posted: Binding source update error after updating the databse accdb[^], you need to check the spelling of your variable references.

How to create excel sheet with multiple sheet name based on modules ?

3 Jun 2020 by Maciej Los

Quote: I use open XML library Sorry, but you're wrong. You're using EPPlus, because OpenXml does not have built-in LoadFromDataTable method. All you have to do is: 1. create Excel file (workbook) 2. loop through the DataRows collection of...

How to create excel sheet with multiple sheet name based on modules ?

3 Jun 2020 by ahmed_sa

I work on c# desktop app I cannot export data to excel sheet with multiple tab meaning multi sheet based on data exist on data table module field I use open XML library Data table data as below : Divide Output Excel File To Multi Tab based...

Detecting and removing redundancy in file

8 Mar 2020 by Patrice T

Quote: Detecting and removing redundancy in file Programming is the art of details and precision, you need to be precise in the requirements. - you said 1 big file but your sample input is 2 vectors, not the same thing, not the same algorithm,...

Detecting and removing redundancy in file

7 Mar 2020 by phil.o

You can open the source file for reading, and create a destination file for writing. And create a list (or a hashset) of integers. Upon reading the source file and parsing the values, check whether current value is in the list/hashset; if it...

Errors when opening arff file into weka

20 Feb 2020 by Richard MacCutchan

@ATTRIBUTE sex REAL @DATA M,0.455,0.365,0.095,0.514,0.2245,0.101,0.15,15 You have declared column 1 (Sex) as a REAL type, but your data uses a character type. I have never heard of Weka or ARFF but found the information quite easily at Arff...

Errors when opening arff file into weka

20 Feb 2020 by Hamza Nadeem

@RELATION abalone @ATTRIBUTE sex REAL @ATTRIBUTE length REAL @ATTRIBUTE diameter REAL @ATTRIBUTE height REAL @ATTRIBUTE wholeWeight REAL @ATTRIBUTE shuckedWeight REAL @ATTRIBUTE...

C# remove cell duplicate cell values of datatable

5 Jan 2020 by Member 14089908

Hello, I have a datatable like bellow. NoReg |Emresa |Caracteristicas |Origen |Destino 3 |INFOTEP |MINIBUS CONFORTABLE |LA VEGA |PUERTO PLATA 3 |INFOTEP |MUSICA TELEVISOR WIFI |MAO |SANTO DOMINGO OESTE 3 |INFOTEP |MUSICA TELEVISOR WIFI |MONTECRISTI |SANTIAGO...

C# remove cell duplicate cell values of datatable

5 Jan 2020 by Christian Graus

If you're getting the data from a database, use DISTINCT. Otherwise, just create your data source in a list, by using LINQ and Distinct. Enumerable.Distinct Method (System.Linq) | Microsoft Docs[^]

How convert IQueryable to Dataset in LINQ to SQL

10 Dec 2019 by m.kolbadi

In 3 layers project I get data with store procedure in data access layers and I want convert this to datatable(for bind in gridview). IQueryable don’t supported from server side paging.I found this way:public DataTable GetInfo(int Id){ db = new...

stored-procedure

Update dataset with child relation and dataadapter not working

20 Nov 2019 by Matt14159

Isn't it the most frustrating thing when you find an old post with exactly the same problem you're having, and no solutions. PZero1992 if you're still around, do you remember how you fixed this?

Update dataset with child relation and dataadapter not working

20 Nov 2019 by PZero1992

Hello,I have an issue when trying to insert my generated data into my database. (MS SQL SERVER)I have a database containing only two tables: "Test", which is the parent table, containing some header-data and "LOG", which is the child table containing "ID_Test" and some logging values.I...

How to add the data row from one datatable to another datatable

4 Sep 2019 by Keerthi Kumar(Andar)

Hi experts,I have got one data table I wanted to check each and every row of that data table using for each loop ..if that row values contains valid data then i want to insert to a data table called dtvalid data table,If that row contains invalid data then insert to dterror data table.Am...

How to add the data row from one datatable to another datatable

4 Sep 2019 by Member 14579015

You need to use "importrow" when only you have rows to be copied, without merging the new structure. simply: For index = 0 To dtOld.Rows.Count - 1 dtNew.ImportRow(dtReceived.Rows(index)) Next

How to dynamically update fields of crystal report from multi-tables of dataset in C#

20 Jun 2019 by TheKhanSoft

Hello there, I have created an App in C#, wherein: I wan to update Crystal Report dynamically. For this purpose, 1. I have created a DataSet (item in solution) 01 - Items.PNG - Google Drive[^] 2. Added/Defined Tables, one of these tables is "PersonalInfo" 02 - DataTabe (from DataSet).PNG -...

How to enter a VB.NET memory stream into a picturebox which is then extracted to dataset for use in a rdlc report image

13 Jun 2019 by Member 14225384

The scenario is that I have a Visual Basic .NET form with a picturebox on it. The image for this box can come from a file (gif) or from Inkpicture strokes. The gif file was originally created from another Inkpicture stroke. Once input and accepted, this Image is then transferred into a dataset...

Can someone help me sove this: key error: none of [int64index...] dtype='int64] are in the columns

13 Apr 2019 by Member 14231855

I'm trying to shuffle my indices using the np.random.shuffle() method, but I keep getting an error that I don't understand. I'd really appreciate it if someone could help me puzzle this out. Thank you! Here is my code: #Goal: Preprocess the Data to Predict Excessive Employee absence ...

How to sort ( I try this code )?

14 Feb 2019 by el_tot93

i using data set to show data what i want to how to sort may data form the data table i have 2 code to use in my data one of them is sqlcode and the another one is c# code i want to sort the ( Answer column from A to Z ) . SELECT TOP (100) PERCENT Subscriber_No, Subscriber_Name,...

How to sort ( I try this code )?

14 Feb 2019 by Gerry Schmitz

How do you know it "didn't sort". "Answer, No Answer" most likely being "bools", all you get is 2 big chucks sorted as to 0's and 1's. With the "top 100" ... mostly likely being all 0's.

How to get the result of a stored procedure with parameters in C#?

10 Jan 2019 by DrgIonuţ

I have the following stored procedure with parameters: USE [DBRapBreaza] GO /****** Object: StoredProcedure [dbo].[PS_SpauOPompa] Script Date: 1/10/2019 10:01:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[PS_SpauOPompa] ...

stored-procedure

How to get the result of a stored procedure with parameters in C#?

10 Jan 2019 by RickZeeland

See examples here: sql server - How to execute a stored procedure within C# program - Stack Overflow[^] There is a DataSet example at the bottom.

stored-procedure

How to get the result of a stored procedure with parameters in C#?

10 Jan 2019 by Wendelius

If I understand your question correctly, you don't have any C# code yet. If that is the situation, then the easiest way is to use SqlDataAdapter Class (System.Data.SqlClient) | Microsoft Docs[^] to populate a DataTable with the results from the Stored procedure. For examples about the code,...

stored-procedure

C# - multiple tables of dataset to multiple datagridview

21 Aug 2018 by Er. Puneet Goel

Use below code. The reason is when we add using ds.Tables.Add("111"); it is not able to add table ot ds at 0 and 1 index. DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); MySqlConnection conn = new MySqlConnection("SERVER=...."); ...

C# - multiple tables of dataset to multiple datagridview

21 Aug 2018 by bryandkko

Hello, MySqlConnection conn = new MySqlConnection("SERVER=...."); MySqlDataAdapter ad; DataSet ds = new DataSet(); ds.Tables.Add("111"); ds.Tables.Add("222"); ad = new MySqlDataAdapter("SELECT * FROM 111", conn); ad.Fill(ds.Tables["111"]); datagridview1.DataSource = ds.Tables["111"]; ad =...

Beijing traffic data

1 Aug 2018 by CHill60

As @Richard-MacCutchan has pointed out, this is a Technical Question Forum and your question is somewhat off-topic. However, CodeProject does have a Chinese forum - General Chinese Topics Discussion Boards[^]. Try posting there and see if someone is prepared to help

In mapreduce how to sort intermediate output based on values?

27 Jul 2018 by anjitaa

"The MapReduce sort the intermediate data(between mapper and reducer phase) by key by default. If we want the data should be sort based on value, then we need secondary sorting. There are 2 approaches to fulfill the same. 1. If reducers will get all the value for a particular key and buffer...

In mapreduce how to sort intermediate output based on values?

27 Jul 2018 by Bansal himani

How to sort intermediate output based on values in MapReduce ? What I have tried: How to sort intermediate output based on values in MapReduce?

How do I save dataset data in C#?

10 Jul 2018 by Solariem

Hello, I'm a fairly new programmer and I am working on a windows Application in C#. I have created a grid view which is bound to a local DataSet. There is no sql server, this is strictly local DataSet. I have written the event handler code for the save button that I added on the binding...

How to convert dataset with multiple datable to json?

25 May 2018 by #realJSOP

Have you tried json.net? It lets you do this: string json = JsonConvert.SerializeObject(dataSet, Formatting.Indented); Seriously, google is your friend.

How to convert dataset with multiple datable to json?

25 May 2018 by Chandan KIIT32

I want to serialize multiple DataTables to JSON which are interrelated and it is possible there will be additional table are all set in the mapping table. In this case, I have 4 DataTables. This is my first time using JSON, and I have found it really tricky to find a simple way of doing this....

How to find the name of the assembly variable serving as connectionstring to a dataset?

25 Apr 2018 by Frederic GIRARDIN

I have to wrote a protected function extension on dataset in my program. It should take consideration of "_" character in dataset.getttype.name to split information. Then i should have enough information to compute my own connnectionString variable Name : dataset.gettype.name =...

How to find the name of the assembly variable serving as connectionstring to a dataset?

25 Apr 2018 by Frederic GIRARDIN

Since to the previous question I myself answered, that I had discovered the solution, but that I did not know how I could solve it, I told myself that the best thing was to ask this question separately for give everyone a chance to answer. So I summarize, I'm trying to find out, how to get the...

Creating a Custom De/Serializer

13 Apr 2018 by Alaa Ben Fatma

In this article, we will walk through the basic concepts of de/serialization and how to create a very basic de/serializer.

deserialization

How do I print a datagridview to crystal report?

21 Mar 2018 by ~BECHEBY

'Insert this code in a button (Print Button) Dim Querry1 As String = "SELECT Item_ID,Item_Name,Price,Quantity,Sum_Total From tblCart Where TransID = '" & TransID.Text & "' SQL.runQuery(Querry1) Dim rptDocs1 As ReportDocument Dim connection As New...

How do I print a datagridview to crystal report?

21 Mar 2018 by Kim Gabinete

my datagridview(dgvCart)'s data are populated by values from textboxes, it's not binded in a database. do i need to create a dataset for my datatable..? that datatable's values will come from the datagridview(dgvCart). so that i can print it into the crystal report. or is it possible that...

How do I print a datagridview to crystal report?

17 Mar 2018 by Mycroft Holmes

You don't "print a DGV in CR". You create your report in CR with the layout you want (use a table in the report) and set the data source to the same data as your DGV. You then print the report, NOT the DGV.

How to pass parameter to RDLC report with a dynamically created dataset as its datasource

15 Mar 2018 by Member 13727912

u should use .rdlc paremeters to filter the data from dataset by using setparameters to add parameters to report, like ReportViewer ReportViewer1 = GetReportViewer(); ReportParameter[] parameters = new ReportParameter[1]; parameters[0] = new...

How to pass parameter to RDLC report with a dynamically created dataset as its datasource

15 Mar 2018 by nina4ever

In my Windows Forms Application, i want to create a report. i have created an .rdlc file and assigned it a "dummy" dataset as a datasource just to get the schema, as described here...

How to find the name of the assembly variable serving as connectionstring to a dataset?

7 Mar 2018 by OriginalGriff

here may not be one. It could be held in a configuration file - the best way - and read on demand when the connection needs to be established (or read into a local variable which only exists while a method is running) It could be in a const value - and the compiler may optimise that to a in-line...

How to find the best way exposing .NET dataset DLL ?

25 Feb 2018 by Frederic GIRARDIN

Hi. Creating a .NET DataSet is easy with Visual Studio, but there is no way to expose that object from a shared DLL. Indeed, when we use only one EXE, we have the same problem: dynamically changing the Dataset ConnectionString which is only a parameter does not seem natural: we traffic a value...

How to find the best way exposing .NET dataset DLL ?

25 Feb 2018 by Frederic GIRARDIN

The fact is that I misunderstood the TableAdapterManager, so I tried to work directly with the table adapter. To do this, I operated a wide replacement of Friend to Public. An operation that was required after each change of the DataSet Designer! And of course, I was wrong. Last Friday, I found...

Copy Rows from One DataGridView to Other DataGridView in C#

27 Dec 2017 by Itz.Irshad

Hi All,How we can copy one or more than one rows from a data grid view to other data grid view on same form. Here, I've searching option which search from the first grid and if found some matching rows then copy them to 2nd grid. How I can achieve this ?Thanks

Are there any advantages to adding my C# datatable to dataset when only 1 datatable is involved?

24 Dec 2017 by User98743

I've been using a lot of DataTables lately. I haven't been adding the DataTable to a DataSet. I'm wondering if there are advantages to adding it to a DataSet when there's only one DataTable. I'm coding in C# Also, is this common practice? What I have tried: My DataTables aren't being added...

Are there any advantages to adding my C# datatable to dataset when only 1 datatable is involved?

24 Dec 2017 by Dave Kreskowiak

No, there isn't. A DataSet is just a collection of DataTable objects and any DataRelations between them. If you're got only a single DataTable, there's no advantage at all.

How to: from MS access create a ODBC table link to datatable inside a DOT NET APP

21 Dec 2017 by DataMig

How To: From MS Access create a ODBC Table Link to DataTable inside a DOT NET APP So the DOT NET APP is like a poor mans SQL Server (or Data Server) The Data is in memory and does not need to be persisted or saved Pointers in the right direction would help Many Thanks In Advance m ...

How to: from MS access create a ODBC table link to datatable inside a DOT NET APP

21 Dec 2017 by Dave Kreskowiak

You have to create a provider one of the database drivers installed on the system, such as OLEDB, ODBC, or whatever. THIS IS FAR FROM A TRIVIAL TASK!! The documentation on this subject is very sparse. You can find the start of it here[^]. More on a few samples (NONE OF WHICH ARE VB.NET OR C#!)...

How to get data set of stock market share prices of mobile phone?

14 Dec 2017 by Richard MacCutchan

You need to use the website of the stockmarket that you wish to use. Many of them will have a simple API that provides the data in JSON format.

How to fill datatable with list

29 Nov 2017 by Member 10563271

my question is very simple i have created a dataset using vs designer and added only one datatable. now how can i load datatable from another datatable with same columns from code What I have tried: DataSet1 dsobj = new DataSet1();

How to fill datatable with list

29 Nov 2017 by Richard MacCutchan

See DataSet.Merge Method (DataTable) (System.Data)[^].

ASP.NET MVC - Generate Excel Spreadsheet from DataSet with Auto Size Columns, Auto-filter and Alternating Background Color

25 Nov 2017 by Daniel Carvalho Liedke

Project to generate Excel Spreadsheet from DataSet with auto size (AutoFit) columns, auto-filter, alternating light blue background color with Open XML using ASP.NET MVC

Print DataTable to Console (and more)

9 Nov 2017 by yuvalsol

Print DataTable, DataView, DataSet, DataRow[] to Console, StringBuilder or Stream

How to fix: conversion failed when converting the nvarchar value 'hex mec' to data type int.

26 Oct 2017 by C I'm not Sharp

The problem occurs when I run the page even though I am not getting any errors on .cs. 'Hex Mec' is the first CompanyName from Supplier table with a datatype varchar (even though the error says 'converting the nvarchar value'. I'm trying to Populate One Asp.net Dropdown based on Selection in...

How to fix: conversion failed when converting the nvarchar value 'hex mec' to data type int.

26 Oct 2017 by phil.o

We cannot see how your are populating your DropDownList. Generally, DropDownLists bound to a table need two informations: the key representing the selected value (a key because it must allow to retrieve a specific row in the table unambiguously), and the text used to display the selected value....

How to fix: conversion failed when converting the nvarchar value 'hex mec' to data type int.

26 Oct 2017 by OriginalGriff

If your column is supposed to be an integer ID field, why are you converting it to a string, in order to convert it back to an integer? And if it isn't an integer - and it isn't if the data in your table is "hex mec" - then it probably should be, so problems like this don't occur. We can't say...

How to fix: conversion failed when converting the nvarchar value 'hex mec' to data type int.

26 Oct 2017 by Richard MacCutchan

Exactly what value do you expect to get from trying to convert "Hex Mec" to an integer? It is obviously impossible for the computer to make any guesses as to what you want.

Make combox index allign with SQL database column (C#)

20 Oct 2017 by Member 13475705

private void combopop() { using (connection = new SqlConnection(connectionString)) using (SqlDataAdapter adapter = new SqlDataAdapter("Select * FROM BiludstyrTABEL", connection)) { DataTable dt3 = new DataTable(); ...

SelectedIndexChanged

How to retrieve data from dataset dynamically according to column name

16 Sep 2017 by himanil

I am on a software where I need to display Data on labels. I am using a Datagrid view which loads an Excel file using Data set and by using same dataset which is already filled with Data, One can type Column name in Textboxes for which user needs to display Data on Labels. Everything Works...

How to retrieve data from dataset dynamically according to column name

16 Sep 2017 by Richard MacCutchan

Firstly you should check the values in the various textboxes to make sure they are valid. That will help you avoid the error you see. Secondly, you cannot dynamically create a query in the way you are trying. You need to use the values from the textboxes to find the row and column indexes. You...

How do I resolve the error that says rows cannont programatically added to the datagridview

15 Jun 2017 by Member 10578733

DataSet info1 = this.GetData.getInfo("SELECT 0 AS EmpNo,Er.EmpID,(Er.FName&''&Er.LName) AS [Employee Name], Ed.DeptNo AS [Department No],Er.Gender AS [Sex] FROM (EmpRegist AS Er INNER JOIN EmployeeDept AS Ed ON Er.EmpId = Ed.EmpId) WHERE Ed.DeptId=" + (object)DpetID + " AND Ed.Status=0 ...

How do I resolve the error that says rows cannont programatically added to the datagridview

13 Jun 2017 by Kornfeld Eliyahu Peter

Quote: Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound I would say it is quiet clear... As you grid now use to display some data source (hence data-bound), you can not alter it directly... You have to add rows to the data source and...

How to avoid 'system.outofmemoryexception' error in clearing and loading C# datatable in a loop

5 Jun 2017 by govindarajan k

For our Project, from C# we execute an Oracle SQL Query and store the result of the query in the output file (CSV or TXT or XML file). Since the number of records are huge (like 2,848,489 records) for some of the files, it takes more time to finish creating the Output file. So, I tried fetching...

How to avoid 'system.outofmemoryexception' error in clearing and loading C# datatable in a loop

5 Jun 2017 by RickZeeland

I would recommend using an SqlDataReader, see: [SqlDataReader] instead of using DataTable and DataSet. Also I think Oracle provides query options like Rownumber or Limit to get only a limited amount of records at a time.

How to calculate sum of hours in crystal report?

17 May 2017 by Developer29

I have the total numbers of hours in the string format(HH:MM:SS) in dataset.I want to calculate sum of HH:MM:SS in crystal Report. For example 52:42:04 +20:34:04 = 73:16:08 I tried the below code in function...But the Output is 00:00:00 What I have tried: WhilePrintingRecords; NumberVar...