I have a dataset that gets populated from a stored proc in sql server. I have a column that has lets say has a set of values. I do not know what those values are. All I know is that they of the type "string". I want to extract all the distinct values from that column. ...
Referencing and assigning a subset of a matlab dataset appears to be extremely inefficient and possibly scales like rows^2 Example: alldata is a large dataset of mixed data - say 150,000 rows by 25 columns (integer, boolean and string). The format for the dataset is: 'format', '%s%u%u%u%u%u%s%s%s%s%s%s%s%u%u%u%u%s%u%s%s%u%s%s%s%s%u...
Hi, I have text file with log information from another program and it has very bad formatting but I can´t edit original program and I want create a new program with dataGridView which read data from .txt file and add it to datagridview. It´s not so hard and I made it with dataGridView1.Rows.Add and array of strings (and prepared columns ...
For a basic ERP (DB with around 150 tables, WinForm app) which would run on a classic LAN network (1 server and up to 25 clients) would you recomend EF4 or DataSet ? LINQ2SQL is NOT an option ! ...
Hi, How can i check if a dataset contains a specific value? It's crazy that no one has done this before. Couldn't find it on the net!!! ...
Hello, I have one dataset with a few tables. In one of the tables where I'm adding to, I would like to have a constraint where it will only allow to add a row if I have a unique value in a column. Table: Users Columns: AutoID, GroupID, UnitID*, etc. In the MVS2008, I went to the Designer and set the Unique property for UnitID to true...
I am looking for large web pages datasets for information search and text processing research. The language of web pages must be English. It can be news websites backups, sites with any textual content no more than 1GB in size. Do you know some good datasets? ...
Can some one recommend approaches to parallelize in C++, when the data to be acted up on is huge. I have been reading about openMP and Intel's TBB for parallelization in C++, but have not experimented with them yet. Which of these is better for parallel data processing ? Any other libraries/ approaches ? ...
Hello. In runtime my app gets data from MSSQL server and there's an object that pulls the data into my custom dataset. Here's the code: public static void FillRegionData(int country, RegionDataTable DestinationTable) { DestinationTable.Clear(); using (selectRegionsListTableAdapter _taSource = new selectRegionsListTableAdapter()) ...
I am using DataSet.ReadXML and DataSet.WriteXML to read and update an XML file. In some places I have a text column that may contain carriage return, linefeed ( ) When I put in the input file, ReadXML works fine and I get \r\l in the column's value. However when I update with DataSet.WriteXML, the output file appea...
My VB WPF app is using strongly typed datasets. The connection string is set in the app.config file and is changed via the application settings designer gui. During development I connect to the test database on another server. I want a screen indicator to make it clear that the app is connected to test data. I know I could parse the co...
I have a dataset with multiple tables. I can obviously do a Dataset.WriteToXML("Somefile.xml") What if I want to export the dataset to a SQLite formatted file. In other words I want to be able to write (i.e. serialize) the contents of the dataset to a SQLite file. Dataset.SerializeToSQLite("Sqliteformatted.bin") Similarly I want to ...
Hi Everyboyd I am using Linq to Sql. When My StoredProcedure Executing its result ll returned in form of IMultipleResults. I am converting it to ISingleResults and It can be Casted as List. So I need to Convert it to DataTable so That I can Bind it to Dataset and Pass the values to UI. But I want such method where I can convert it wi...
I have the following code which return a dataset in cuestionarios.obtenerCuestionarios Dim cuestionarios As New ObtenerCuestionarios Dim ds As New DataSet("Cuestionarios") ds = cuestionarios.obtenerCuestionarios DataGridView1.DataSource = ds.DefaultViewManager DataGridView1.DataMember = "cuestionario" Which creat...
i'm trying to get an error description according to error Id: String errorDesc = from resultCodesTableRow in resultCodesDT.AsEnumerable() where resultCodesTableRow.Field<int>("Error_Code_Column_Name") == errorCode select resultCodesTableRow.Field<string>("Error_Desc_Column_Name").T...
i have a table with these columns: errorCode (int) errorDesc (Varchar) i'm trying to get the datarow where errorCode is 5: DataRow resultCodeRow = (from resultCodesTableRow in resultCodesDT.AsEnumerable() where resultCodesTableRow.Field<int>("result_Code_colum_Name") == 5 ...
How do i wrap the linq to entities using c# to a datagrid . I was working earlier on web, so windows is new to me. I have like first name, lastname, phone numbers from a person object i want to display list of persons in datagrid but phone numbers needs to be combo box. Phone numbers are from different table. I get a list of anonymo...
I have a dataset, which have two datatables. Can I join these two datatables .I mean a left outer join similar to DB tables ? ...
Hi, I have stored procedures that return couple of tables, and i want to map objects to the tables. Until now, i worked with type data set, and i want to stop working with them. I am looking for suggestions on how to do that, i thought about reflection, or iterate through each table in the data set and populate my object, or split the p...
Hi, I want all the dmoz categories hierarchy. Is there a script to get this? Or is this dataset already available? Thank you ...