Splitting a Datatable based on Column value
considering dt datatable has all the records including both the columns, you can create two DataView with your filter condition like EnumerableRowCollection<DataRow> query = from data in dt.AsEnumerable() where data.Field<bool>("a") == true select data; DataView view1 = query.AsDataView(); EnumerableRowCollection<DataRow> query1 = from data in dt.AsEnumerable() where data.Field<bool>("a") == false select...
filtering not working from select
jquery,table,datatable,filtering,html-select
You have entered wrong index in fnFilter. Find the below working code, JSFiddle The issue was with on event, you should provide the selector to on function or else use Delegate: It just attaches the event runtime. For more info refer http://api.jquery.com/delegate/ and Need to use $(this) to get the...
C# Find non matching values in DataTables
c#,datatable,matching,relation
Well, you could of course use a little bit of LINQ by turning the data tables into IEnumerables using the AsEnumerable()1 extension method. I am using a few assumptions to illustrate this: "id" is the column with an integer value relating rows in FEData and SSFEData. "id" is the primary...
Filtering DataTable that contains objects
Thanks to kanchirks comment I came up with this solution. EnumerableRowCollection erc = dataTable.AsEnumerable().Where(dr => ((Cell)dr[columnIndex]).Value.ToString().ToLower().Contains(filter.ToLower())); ...
JQuery 1.4.4 and Datatable 1.7 not working
javascript,jquery,json,xml,datatable
I gave up debugging the XML parsing - too cryptic. There is no need for porting the XML to JSON at all. So made this up instead : var table = $('#dynamicPhoneDirectory').dataTable(); var parser = new DOMParser(), xmlDoc = parser.parseFromString(rawxmlData,"text/xml"), phoneBook = xmlDoc.querySelector('PhoneBooks'), phoneBooks = phoneBook.querySelectorAll('PhoneBook'); for (var i=0;i<phoneBooks.length;i++) {...
C# Get String From Data set Exception
Well, “First_Nameˮ is treated as a variable name and not as a quoted string, as the quotes are not "normal" double quotes, but typographical left/right quotes, so they are threated as unicode signs. Change them to normal double quotes. String Receiver_name = rec_Ds.Tables[0].Rows[0]["First_Name"].ToString() + " " + rec_Ds.Tables[0].Rows[0]["Last_Name"].ToString(); So: Be...
Creating a sample data table with X, Y, Z axis (student, cours, score) to bind to grid
The display structure you are trying to achieve isn't how you would set the information out within a data set You could then cut/ Slice the data any way you like for displaying purposes Quick way of displaying to the grid Create an object -> put the data in to...
dataTable doesn't show list [duplicate]
I've found the solution guys! Hope this helps for someone that had my same problem. I added this @PostConstruct public void init() { prodotti = pFacade.getCatalogoProdotti(); } in the prodottoController bean, and now it shows all the products on the database!! That PostConstruct must be used everytime we use a...
Avoid onRowClick event when outputLink is clicked inside of RichFaces datatable
javascript,javascript-events,datatable,richfaces
Basically what Event.stop(event) does is the following: \\ stops the event from bubbling up the event chain event.stopPropagation(); \\ prevents the default action the browser makes on that event event.preventDefault(); In your case you want just to prevent bubbling, so a way to go: onclick="event.stopPropagation()" ...
Get p:dataTable row data via p:selectOneMenu
jsf-2,primefaces,datatable,row,selectonemenu
This way I can loop through my list of objects, allocate that specific object of the row and change the value That effort is unnecessary. Just bind input component's value directly to the desired property. <p:selectOneMenu value="#{car.selectedValue}"> This way JSF will transparently do all that effort for you. If...
Combobox Datasource assign to Datatable
vb.net,combobox,casting,datatable
I would use TryCast to get the job done. Dim dt As DataTable = TryCast(combobox1.DataSource, DataTable) If dt Is Nothing Then ' It didn't work because it's not a datatable ' Editors: I specifically did not reduce this expression ' to emphasize the need to check for 'Nothing' ' and...
Refresh selection model of p:datatable on row deselection
jsf,primefaces,datatable,selection
I finally found the solution. They had extended PrimeFaces implemenation and incompletely implemented some methods. The following thread helped me in solving the problem: p:dataTable selections are lost after paginating a LazyDataModel
JavaScript: Add table values to input field on button click
javascript,input,data,datatable
I created the whole solution on codepen. This is the function used: var clicks = 0; function csv() { var box = document.getElementsByName('text')[0]; if(clicks === 0){ var newcsv = ""; var tds = document.getElementsByTagName("TD"); for(var i = 0; i < tds.length; i++) { newcsv += tds[i].innerHTML; if(i != tds.length-1) newcsv...
Join some rows in datatable
Try this var result = (from p in ur_data_table.AsEnumerable() group p by new{ col1 = p["TYPE"], col2 = p["CODE"] , col3 = p["NAME"]} into groupedTable select new { X = groupedTable.Key, //Each Key contains col1,col2 & col3 VALUE = groupedTable.Sum((s1) => int.Parse(s1["VALUE"].ToString())) }).ToList(); Here first your datatable will convert as...
adjust the rows dynamically in paginator of primefaces datatable
1.Define two JSF inputHidden Fields say screenHeight, and screenWidth in your xhtml files 2.Calculate the computedHeight and computedWidth using javascript when page loads and store it into the hidden fields. 3.Automatically the value will be binded to the managedbean varaibles. 4.Write a method to return no of rows based on...
Adding image to GridView created in CodeBehind
You can make use of <asp:ImageField/> within the the Gridview to achieve this. So your markup will look like <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="false"> <Columns> <asp:ImageField DataImageUrlField="Value" ControlStyle-Width="100" ControlStyle-Height="100" HeaderText="My Image" /> </Columns> </asp:GridView> In your C# code you can use List to add the images. So something as simple as...
Export DataTable to CSV File with “|” Delimiter
c#,asp.net,csv,datatable,export
You can try: StringBuilder sb = new StringBuilder(); string[] columnNames = dt.Columns.Cast<DataColumn>(). Select(column => column.ColumnName). ToArray(); sb.AppendLine(string.Join("|", columnNames)); foreach (DataRow row in dt.Rows) { string[] fields = row.ItemArray.Select(field => field.ToString()). ToArray(); sb.AppendLine(string.Join("|", fields)); } File.WriteAllText("test.csv", sb.ToString()); ...
DataTable Modifies Date Format - WHY?
c#,sql,asp.net,sql-server,datatable
DataTable uses .NET DateTime class and it probably get converted to string with DateTime.ToString() method when CSV is created. That method uses date format from current Thread's Culture settings. You need to use DateTime.ToString(string format) overload when creating CSV to specify desired format of DateTime. Here's general description of culture-specific...
datatable with html content
jquery,html,checkbox,datatable
Use mrender property - $('#newItemBasketTab').dataTable({ "aaData": result.itembasketdata, "aoColumnDefs": [ { "aTargets": [ 0 ], "mData": "ID", "mRender": function ( data, type, full ) { var checked = "checked"; if(data) { checked = "checked"; } return "<input type='checkbox' checked='" + checked + "'>"; } }, {"mData": "nic5dcodename"}, {"mData": "asiccprodcodename"}, {"mData": "unit_name"},...
Return DataTable from ORACLE
I am not VB specialist, but this code worked fine, so it may be useful for you: Dim dt = Oracle2table("select * from dual") Console.WriteLine(dt.Rows(0)(0)) Function (I removed exception handling for simplicity): Function Oracle2table(ByVal sql As String) As DataTable Dim conn = New OleDbConnection(connString) Oracle2table = New DataTable conn =...
Primefaces datatable combine data in only one row
You're using the dataTable component in a wrong way. It just displays data in a tabular view and the only thing you're supposed to do, is to supply it with a Collection of model objects and explicitly tell which property from a model instance should be displayed under a certain...
highcharts datatable - function parameters
javascript,highcharts,datatable
Call drawTable function in load function, instead of reference. load: function(){ Highcharts.drawTable(this, 310, 100, 0, '', 20, 20, 2.5) } Example: http://jsfiddle.net/z9zXM/1035/...
Bootstrap datatable pagination only showing buttons but not working in Grails
twitter-bootstrap,grails,datatable,pagination
You can try the following code. View page.. <table id="example" class="table table-bordered table-hover" cellspacing="0" width="100%"> <thead> <tr> <th>Title</th> <th>Short Description</th> <th>Stream Type</th> <th style="text-align: center;">Total Download</th> <th style="text-align: center;">Active</th> <th style="text-align: center;">Action</th> </tr> </thead> <tbody> <g:each in="${dataReturn}" var="dataSet"...
DataTable.js implement a filter to hide rows by index
javascript,jquery,datatable,jquery-datatables
table.draw() does not work because it is defined inside the $(document).ready scope. You must have global table variable, then it will be accessible in your displayAdvertRight() function too. I.e var table; $(document).ready(function() { ... table = $('#example').DataTable({ ... }); I get the impression that you have two <select>-boxes, startTime and...
Checkboxes will only work on current pagination page in jQuery datatables
javascript,php,jquery,checkbox,datatable
you can get all the selected check box values using following code this might be helpful for you var myArray = []; var id = ""; var oTable = $("#example").dataTable(); $(".class1:checked", oTable.fnGetNodes()).each(function() { if (id != "") { id = id + "," + $(this).val(); } else { id =...
dataview.rowfilter syntax error - missing operand mystery
vb.net,datagridview,datatable,dataview,rowfilter
It looks like you have a white space in the Datatable column header. So, you have to enclose the Column name in the RowFilter within square brackets. Dim dtdv As New DataView dtdv = dt.DefaultView dtdv.RowFilter = "[Controller ID] = 'PS2USB1'" XMLDGV.DataSource = dtdv ...
Columns in DataTable Disappearing
You lose your data on postbacks. That's normal. You have to use some of state management mechanisms like ViewState or Session to mention few. You can try this using ViewState: private DataTable purchase_display_data { get { if (ViewState["purchase_display_data"] == null) ViewState["purchase_display_data"] = new DataTable(); return (DataTable)ViewState["purchase_display_data"]; } set { ViewState["purchase_display_data"]...
