Questions tagged [dataset]

A dataset is a collection of data, generally represented in tabular form, with columns signifying different variables and rows signify different members of the set. If you are looking for a freely available dataset for any purpose, please consider asking your question on https://opendata.stackexchange.com.

11414 questions
25
votes
3 answers

Is there any Treebank for free?

Is any place I can download Treebank of English phrases for free or less than $100? I need training data containing bunch of syntactic parsed sentences (>1000) in English in any format. Basically all I need is just words in this sentences being…
YMC
  • 4,925
  • 7
  • 53
  • 83
25
votes
3 answers

How do I loop through a dataset in PowerShell?

I am trying to output values of each rows from a DataSet: for ($i=0;$i -le $ds.Tables[1].Rows.Count;$i++) { Write-Host 'value is : ' + $i + ' ' + $ds.Tables[1].Rows[$i][0] } gives the output ... value is : +0+…
Murtaza Mandvi
  • 10,708
  • 23
  • 74
  • 109
25
votes
6 answers

How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?

What I want to do I'm trying to use the Microsoft.Office.Interop.Excel namespace to open an Excel file (XSL or CSV, but sadly not XSLX) and import it into a DataSet. I don't have control over the worksheet or column names, so I need to allow for…
Justin Morgan - On strike
  • 30,035
  • 12
  • 80
  • 104
25
votes
4 answers

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: DataTable already belongs to another DataSet. Do I have to clone the DataTable and import all the rows to it…
MrCatacroquer
  • 2,038
  • 3
  • 16
  • 21
25
votes
8 answers

c# (WinForms-App) export DataSet to Excel

I need a solution to export a dataset to an excel file without any asp code (HttpResonpsne...) but i did not find a good example to do this... Best thanks in advance
maveonair
  • 766
  • 2
  • 7
  • 19
25
votes
9 answers

Table is nullable DateTime, but DataSet throws an exception?

I'm attempting to use the DataSet designer to create a datatable from a query. I got this down just fine. The query used returns a nullable datetime column from the database. But, when it gets around to this code: DataSet1.DataTable1DataTable…
user47589
24
votes
3 answers

Filtering DataSet

I have a DataSet full of costumers. I was wondering if there is any way to filter the dataset and only get the information I want. For example, to get CostumerName and CostumerAddress for a costumer that has CostumerID = 1 Is it possible?
Erika
  • 399
  • 2
  • 3
  • 8
24
votes
4 answers

How to create a Image Dataset just like MNIST dataset?

I have 10000 BMP images of some handwritten digits. If i want to feed the datas to a neural network what do i need to do ? For MNIST dataset i just had to write (X_train, y_train), (X_test, y_test) = mnist.load_data() I am using Keras library in…
Md Shopon
  • 803
  • 2
  • 8
  • 17
24
votes
10 answers

How to check for a Null value in VB.NET

I have this: If String.IsNullOrEmpty(editTransactionRow.pay_id.ToString()) = False Then stTransactionPaymentID = editTransactionRow.pay_id 'Check for null value End If Now, when editTransactionRow.pay_id is Null Visual Basic throws an…
Dan
24
votes
4 answers

How does one insert a column into a dataset between two existing columns?

I'm trying to insert a column into an existing DataSet using C#. As an example I have a DataSet defined as follows: DataSet ds = new DataSet(); ds.Tables.Add(new DataTable()); ds.Tables[0].Columns.Add("column_1",…
mezoid
  • 28,090
  • 37
  • 107
  • 148
24
votes
5 answers

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 the column name "TaskStart" and display it on a report, but its just shows the date from the first row for all rows can…
Peter
  • 351
  • 1
  • 5
  • 14
24
votes
3 answers

Stored procedure return into DataSet in C# .Net

I want to return virtual table from stored procedure and I want to use it in dataset in c# .net. My procedure is a little complex and can't find how to return a table and set it in a dataset Here is my procedure to modify: ALTER PROCEDURE…
cihadakt
  • 3,054
  • 11
  • 37
  • 59
23
votes
2 answers

How to concatenate values in RDLC expression?

I have an RDLC file in which I want to make an expression. Here is the image of properties of expression. I need to concatenate First Name, Last name and Middle Init.
asma
  • 2,795
  • 13
  • 60
  • 87
23
votes
6 answers

"Cannot change DataType of a column once it has data" error in Visual Studio 2005 DataSet Designer

I've got a DataSet in VisualStudio 2005. I need to change the datatype of a column in one of the datatables from System.Int32 to System.Decimal. When I try to change the datatype in the DataSet Designer I receive the following error: Property…
firedfly
  • 2,299
  • 2
  • 22
  • 20
23
votes
5 answers

Is there any way for DBUnit to automatically create tables?

I just realized that DBUnit doesn't create tables by itself (see How do I test with DBUnit with plain JDBC and HSQLDB without facing a NoSuchTableException?). Is there any way for DBUnit to automatically create tables from a dataset or dtd? EDIT: …
neu242
  • 15,796
  • 20
  • 79
  • 114