Stack Overflow
Stack Overflow

Questions tagged [system.data.datatable]

57 questions
1
vote
1 answer

How to compare to datatable with different columns

I have the EMP datatable it contains 500 records like this: UserAceNumber UserID emp001 emp002 emp003 emp004 (userid will be empty for all the 500 records) Another Empdetails datatable contains some…
Nathan
  • 91
  • 2
  • 7
1
vote
3 answers

Data Access ASP.NET

I built an online news portal before which is working fine for me but some say the home page is slow a little bit. When I think of it I see a reason why that is. The home page of the site displays Headlines Spot news (sub-headlines Spots with …
Subliminal Hash
  • 13,614
  • 20
  • 73
  • 104
1
vote
0 answers

Need help to compare a SpecFlow table with a DataTable

I am trying to use SpecFlow BDD testing with data collected from an SQL Analysis services cube (got ideas from this article https://notesfromthelifeboat.com/post/analysis-services-2-testing/) Most of the things work, but the final step where I want…
Geir Forsmo
  • 149
  • 2
  • 11
1
vote
2 answers

Join Datatables from a loop and merge in one Dataset

I have this requirement that the user request one or more partnumbers.And i need to display all the result in one Data Set Ex: Request SerialNumbers with PartNumber Required Quantity A 2 B 1 C …
BizApps
  • 6,048
  • 9
  • 40
  • 62
1
vote
1 answer

Unity, How to use AsEnumerable

I need to use AsEnumerable() on a DataTable in Unity, but it seems the Unity version of System.Data doesn't have that method! I tried to import the VS version of dll into the asset, but it told me that Multiple assemblies with equivalent identity…
PiggyChu001
  • 440
  • 6
  • 20
1
vote
0 answers

Copy System.Data.Datatable to Access DB Programmatically Vb.net

I've looked through an awful lot of questions/answers here, I'm sure this has to have been asked before but I can't find it as it applies to my exact situation. I have a system.data.datatable from a generic source (could be anything), and I need to…
Mike
  • 43
  • 5
1
vote
4 answers

Compare two DataTables and select first table records NOT in the second table

I have two DataTables that are getting data from two different sources. I would want to have a new DataTable Table3 with ONLY Tables1 rows that do not have matching Table2 rows. My two DataTables have different structures as indicated below.…
Hakuna N
  • 183
  • 2
  • 17
1
vote
1 answer

how to know Datatable is already subscribed?

How to know that DataTable is already subscribed to OnRowChanged or OnColumnChanged events ? I am facing a issue with many notifications in my app ? so I wanted to put a check and want to subscribe table only once ??
Jon Kra
  • 11
  • 1
1
vote
1 answer

DataTable.Rows.Add() time grows proportionally to DataTable size

Users noticed that records in the DataGridView started appearing on the screen with some delay. So I analyzed logs and saw that there is a strong dependency between time that takes it to call DataTable.Rows.Add() and amount of records in data…
Olga
  • 49
  • 5
1
vote
2 answers

Specifying the records to be deleted from a database using the TableAdapter.Update method

I have been messing with this for quite some time now and it's getting less and less fun; I followed the MSDN guide for deleting a row from a datagrid. And it works for any row however I am not able to specify the row... essentially I can delete…
Confussedinwales
  • 25
  • 6
1
vote
0 answers

How do I handle a DataColumn expression exception on single row without causing all rows to use default value?

I'm trying to use a DataTable to perform calculations on rows of data using the Expression property on DataColumns. msdn I found that if there is an exception while applying the expression to the rows, the default value will be used. That's exactly…
Chris Dibble
  • 388
  • 1
  • 5
  • 16
1
vote
0 answers

Error when passing Oracle SYSTEM.DATA.DATATABLE result as parameter to another powershell script

I'm working on a script that is expected to perform the following: Connect to Oracle DB and run main query to extract raw data. - Already working as unit tested Import raw data to a Microsoft access database template (.mdb) - Working as unit tested…
Zell
  • 33
  • 6
1
vote
1 answer

Is it possible to define a column type in DataTable at run time?

I would like to create a DataTable but I don't know the types of columns at compile time. Therefore, I would like the columns types to be decided at run-time. WHAT I'VE TRIED: First, I get some data from Excel: Type tempCheck =…
LLaP
  • 2,528
  • 4
  • 22
  • 34
1
vote
0 answers

How to retrieve results from dynamic linq query, with data from a late-binding library, into a datatable?

I am working on a library that generates reports automatically. The reports are never known in advanced, but the manner in which they are called are configured in an Oracle database. Each report has its own class; in each class, there is a database…
ADame
  • 11
  • 4
1
vote
0 answers

System.Data.DataTable event raised on RejectChanges

I have a huge DataTable instance bound to a GUI, next to the DataTable there lays a specialized object (let's call it ValuesIndex)implementing fast access to DataTable content. The problem is I need to keep ValuesIndex synchronized with the current…
soliloquyy
  • 355
  • 3
  • 14
1
2
3 4