In my abstract class (C# 3) I'm using a virtual method named GetData() which returns a DataTable. The algorithm of the method is as following: Get SQL query string from the class. Get DataTable from database using above query. Do transformations on DataTable and return it. In the 3rd point, I clone the original DataTable in order to ...
Hello, I'm starting a small project, using JSF 2.0. I'm having problems right in the start, in the CRUD of the first model implemented. What I want to do is pretty simple: The page has some filters to search, and using ajax, it populates a h:dataTable with the results. The user should now select the line with the result he wants to se...
Hi i am fairly new to jquery DataTables.Hope someone can help What I want to do is change the value of the data before rendering the table, I used this below "fnRowCallback": function( nRow, aData, iDisplayIndex ) { if ( aData[2] == "0" ){ $('td:eq(1)', nRow).html( '6' );} But I found that although I chang...
how to return a dataset from linq in .net 3.5? I have seen in some sites that CopyToDataTable method is used but I am not able to use that methos as I cannot find System.data.datatableextensions reference in the ref list. Please help me out. Thanks and regards, veena ...
How to get a DataTable from DataRow[] collection ? I tried the following conversion , but it returns null. string ProcessQuery(ref DataRow[] rows) { DataTable _tb = new DataTable(); foreach (DataRow _dr in rows) { _tb.Rows.Add(_dr); }...
I was asked this question recently in a test, which I didn't pass. For the life of me, I couldn't spot what the problem was. It's probably something really obvious as well, but even a colleague of mine couldn't spot it either. The best I could come up with was issues with bottlenecks and naming inconsistencies of parameters! I blame i...
Hi people. I have a datatable with some data I have read from a CSV file (you helped me yesterday with that, thanks). Now, I want to show a report with some columns of that datatable. It would be easier if I could see the fields and select them from the report designer: I'd just have to drag them to the columns. The problem is that thi...
I have a database table where columns are in multiple schemas. Example: SomeTable SomeSchema.Column1 SomeSchema.Column2 AnotherSchema.ColumnA AnotherSchema.ColumnB I have code using a DataTable.Rows[r][c].ToString() syntax and it looks like only the Column1 or ColumnA part is being returned. I need to get the full name SomeSchema.Co...
i want to use Linq's Iquerable that gives me the ' query that gets only the records needed to the page' based on the Page size i have given. i have used this: System.Linq.IQueryable<DataTable> ds = (from m in dttableDetails.TableName select m).Take(page_size).Skip(offset); but it is showing me error. i need the returned type as ...
i have used this query to fetch the Record of the Datatable based on the Pagesize. IEnumerable<DataRow> query1 = from row in dt.AsEnumerable().Take(page_size).Skip(offset) select row; Datatable boundTable= query1.CopyToDataTable(); first time when it opens the offset will be =0; it gives 10 records, next time i pass the offset a...
Hi, I have this simple code: currentDataTable.Columns.Add("Active", Type.GetType("System.Boolean")); currentDataTable.Columns.Add("Symbol", Type.GetType("System.String")); currentDataTable.PrimaryKey = new DataColumn[] {currentDataTable.Columns[1]}; string FilterExpression = "Symbol = AAA"; DataRow[] existingRows ...
in my db i have values as True/False/false/true.... i need to get oly the Distinct Values as True and False and not the all values as True & False & false & true... my code: DataTable dv= dt.DefaultView.ToTable(true, col.header); dv.Casesensitive=true; but i got the values as True & False & false. how to avoid both similar value...
Hey, I am trying to bind my data table inventorytable to the datagrid viewer.the problem in the code is when it compiles,it says the column"make" does not belong to the table but I make the column in the code as follows: public partial class Form1 : Form { List<Car> listCars = new List<Car>(); DataTable inventorytabl...
Hi, Is there anyway to insert in bulk a System.Data.DataTable in C# into a SQL Server table using a store procedure and passing this table as parameter? The table won't have a fixed number of records, Thanks ...
Importing a spreadsheet I have filled a DataTable object with that data and returns expected results. Attempting to put this into a format I can easily query to search for problem records I have done the following public void Something(DataTable dt) { var data = from row in dt.AsEnumerable() select row["Order"].ToS...
Hi people. I'm trying to use this implementation of a DataSetHelper to group a DataSet by a column. What I'm doing is: DataSet ds_tmp = new DataSet(); DataTable dt_tmp; ds_tmp.Tables.Add(data_table_UserTime); dsHelper = new DataSetHelper(ref ds_tmp); dt_tmp = dsHelper.SelectGroupByInto("UniqueUsers", ds_tmp.Tables[0], "User, sum(Time) ...
Originally i wanted to ask for the fastest way to query a Datatable for a special row. I have tested 5 different methods for their performance with a surprising(for me) result. Background: I have created a View in a MS Sql-Server 2005 Database. This view has current a total count of 6318 rows. Because i must check very often if a given...
I've never found an elegant way to do this, so I'm wondering what methods other developers prefer (for performance, readability, etc). Is there a way to use the LIKE operator in the DataTable.Select() function, based on the results of a query to another DataTable. For example, in SQL Server, the syntax would be: Select SomeValue From...
Hi all; my datatable; dtData ID | ID2 -------- 1 | 2 1 | 3 dtData.Select("ID = 1"); one more rows; i want row "ID = 1 And ID2 = 3" how to make ? ...
For my own edification, I decided to test the comparative speeds of DataTable.ImportRow vs DataTable.Merge. I found that DataTable.ImportRow was largely slower than DataTable.Merge. On rare occasion, the two functions had an equal processing time. On even rarer occasions, ImportRow was faster than Merge. Below are my testing results an...