Search Results

Search found 1168 results on 47 pages for 'datatable'.

Page 7/47 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >

• How to read a database record with a DataReader and add it to a DataTable

  - by Olga

  Hello I have some data in a Oracle database table(around 4 million records) which i want to transform and store in a MSSQL database using ADO.NET. So far i used (for much smaller tables) a DataAdapter to read the data out of the Oracle DataBase and add the DataTable to a DataSet for further processing. When i tried this with my huge table, there…

  Read the article

• How to use JSF's h:selectBooleanCheckbox with h:dataTable to create one object per row?

  - by c0d3x

  I have a Facelets page with a h:dataTable. In each row of the h:dataTable there is a h:selectBooleanCheckbox. If the checkbox is selected a new Object should be created with the data out of the corresponding row. How do I do this? How to get the selected rows or their data in a backing bean? Or would it be better to do it with…

  Read the article

• Can YUIs DataTable have resizeable but not moveable columns?

  - by Justin Tanner

  I have implemented column resizing with YUIs DataTable as demonstrated in this example: http://developer.yahoo.com/yui/examples/datatable/dt_complex_clean.html Is there anyway to enable column resizing without column moving?

  Read the article

• How can I get the checked rows in a YUI DataTable?

  - by Justin Tanner

  I'm using a YUI DataTable with a checkbox column like this: var myColumnDefs = [ {key:"check", label:'', formatter:"checkbox"}, {other rows...} ]; How can I iterate over the checked columns in my DataTable?

  Read the article

• How to insert the column with data in between datatable ?

  - by Harikrishna

  I have datatable like : id name address --------------- 1 abc akjdk 2 bcd dkjkl Now I want to insert one column with data in between to that datatable like : id name phoneno address ----------------------- 1 abc 11231 akjdk 2 bcd 12313 dkjkl How can I do this ?

  Read the article

• Pivoting DataTable Simplified

  A class to pivot a DataTable with various aggregate functions.

  Read the article

• What is the correct date format for a Date column in YUI DataTable ?

  - by giulio

  I have produced a data table. All the columns are sortable. It has a date in one column which I formatted dd/mm/yyyy hh:mm:ss . This is different from the default format as defined in the doco, but I should be able to define my own format for non-american formats. (See below) The DataTable class provides a set of built-in…

  Read the article

• How can I add the column data type after adding the column headers to my datatable?

  - by Kevin

  Using the code below (from a console app I've cobbled together), I add seven columns to my datatable. Once this is done, how can I set the data type for each column? For instance, column 1 of the datatable will have the header "ItemNum" and I want to set it to be an Int. I've looked at some examples on thet 'net, but most…

  Read the article

• Best way to get a single value from a DataTable?

  - by PiersMyers

  I have a number of static classes that contain tables like this: using System; using System.Data; using System.Globalization; public static class TableFoo { private static readonly DataTable ItemTable; static TableFoo() { ItemTable = new DataTable("TableFoo") { Locale = CultureInfo.InvariantCulture }; …

  Read the article

• Binding DataTable To GridView, But No Rows In GridViewRowCollection Despite GridView Population?

  - by KSwift87

  Problem: I've coded a GridView in the markup in a page. I have coded a DataTable in the code-behind that takes data from a collection of custom objects. I then bind that DataTable to the GridView. (Specific problem mentioned a couple code-snippets below.) GridView Markup: <asp:GridView ID="gvCart" runat="server"…

  Read the article

• How to convert List to Datatable in vb.net

  - by Samir R. Bhogayta

  Public Function ConvertToDataTable(Of T)(ByVal list As IList(Of T)) As DataTable        Dim table As New DataTable()        Dim fields() As FieldInfo = GetType(T).GetFields()        For Each field As FieldInfo In…

  Read the article

• What is it about DataTable Column Names with dots that makes them unsuitable for WPF's DataGrid cont

  - by Tom Ritter

  Run this, and be confused: <Window x:Class="Fucking_Data_Grids.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" Height="350" Width="525"> <StackPanel> <DataGrid …

  Read the article

• Why does calling the YUI Datatable showCellEditor not display the editor?

  - by t-boy

  Clicking on the second cell (any row) in the datatable causes the cell editor to display. But, I am trying to display the cell editor from code. The code looks like the following: var firstEl = oDataTable.getFirstTdEl(rowIndex); var secondCell = oDataTable.getNextTdEl(firstEl); …

  Read the article

• How to select min and max values of a column in a datatable?

  - by Ahmed

  For the following datatable column, what is the fastest way to get the min and max values? AccountLevel 0 1 2 3

  Read the article

• What data structure would be the least painful DataTable replacement?

  - by MatthewMartin

  I'm storing a lot of sorted ~10 row 2 column/key value pairs in ASP.NET cache-- they're the data for dropdownlists. Right now they are all DataTables, which isn't very space efficient (the rule of thumb is 10x increase in size when data is strored in a dataset). Old Code DataTable…

  Read the article

• Some way of getting just the data part from a web service returning a DataTable?

  - by simendsjo

  I'm using an external web service that returns a DataTable. There's a couple of problems with this. The first is that there are over 20,000 columns, and .Net crashes when trying to convert the xml to a DataTable. I have to use Mono to make this work. The other problem is that it takes…

  Read the article

• LINQ to SQL, LINQ to XML and Accessing DataTable using LINQ

  This article demonstrates how to use LINQ on DataTable, XML Data using LINQ to XML and SQL server data base using LINQ to SQL Classes.

  Read the article

• Sortable & Filterable PrimeFaces DataTable

  - by Geertjan

  <h:form> <p:dataTable value="#{resultManagedBean.customers}" var="customer"> <p:column id="nameHeader" filterBy="#{customer.name}" sortBy="#{customer.name}"> <f:facet name="header"> <h:outputText value="Name" /> …

  Read the article

• Mouse over effect with jQuery in richfaces datatable and datascroller combo

  - by John

  Hi, I'm problem with defining a mouse over effect for my datatables. I have <a4j:form> <rich:dataTable id="dataTable"> ... </rich:dataTable> <rich:datascroller id="dataScroller" for="dataTable" /> </a4j:form> <rich:jQuery…

  Read the article

• Is there a code-generator to create DataTable definition block from Excel Work sheet?

  - by burak ozdogan

  Hi, Basically the thing I want to achieve is to have a data-table that I want to use in my unit tests. And when I run my unit tests, I do not want to read any excel file into a data-table -or any call to Db-. So, I would like to have method that returns a…

  Read the article

• c# remove duplicate column values from a datatable without using linq...

  - by Pandiya Chendur

  Consider my datatable, Id Name MobNo 1 ac 9566643707 2 bc 9944556612 3 cc 9566643707 How to remove the row 3 which contains duplicate MobNo column value in c# without using linq... I have seen similar questions on SO but all the answers…

  Read the article

• If I'm updating a DataRow, do I lock the entire DataTable or just the DataRow?

  - by Dan Tao

  Suppose I'm accessing a DataTable from multiple threads. If I want to access a particular row, I suspect I need to lock that operation (I could be mistaken about this, but at least I know this way I'm safe): // this is a strongly-typed table OrdersRow row…

  Read the article

• How do you convert a DataTable into a generic list?

  - by IainMH

  Currently, I'm using: DataTable dt = CreateDataTableInSomeWay(); List<DataRow> list = new List<DataRow>(); foreach (DataRow dr in dt.Rows) { list.Add(dr); } Is there a better/magic way?

  Read the article

• How to calculate sum of a DataTable's Column in LINQ (to Dataset)?

  - by rivera.reyrivera

  I'm just started to read up on LINQ and I want to start incorporating it into my code. I know how to compute the sum of a DataTable's column by either "Foreach"-ing through the rows or by doing a compute.sum on the specific column. How do I do the…

  Read the article

• How to properly set a datatable to an gridview in code with an ObjectDataSource?

  - by Xaisoft

  Hello, I have an ObjectDataSource with an ID of ObjectDataSource1 on a webpage. I also have a gridview in which I am binding the ObjectDataSource.ID to the GridView.DataSourceID. The problem I get is when text is changed in a textbox, the code…

  Read the article

< Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >