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...
Select and updating data from datatable
As the exception says,Index is out of bounds,You are reading the first element (with index 0) but there are no elements in the collection. It is the same as this: int[] array = new int[0]; int x = array[0];//You will get an exception here Add an if statement to make...
Primeface Datatable filtering removed when sorting with o:form includeRequestParams=“true”
primefaces,filter,datatable,omnifaces,http-request-parameters
Ok so i found out that filteredValue was reseted on each ajax call because of the @RequestScoped. I think i was kind of mixing up things. So i switched all @ManagedBeans to @Named then i created a new @SessionScoped Bean with most of the attributes and i @inject a @RequestScoped...
Binding a datagrid template column (as datepicker column) to a datatable column
c#,wpf,data-binding,datatable,datagridcolumn
Okay, I figured it out. It turns out that the binding has to be done in the wpf code where the template for the template is created. No binding actually has to occur in the code-behind for the individual column. The table itself does still have to be pointed to...
Missing Data after insert into my end sql table using Sql Bulk Copy
c#,sql-server-2008,datatable,console-application,sqlbulkcopy
you need to look at the data in Access, and find/fix those bad column values, or handle them in your TSQL after the export. One option to debug - replace temp table with real table, replace datetime datatype with string, do your export, then query the table to find the...
With JQuery Datatable, how do you get the search/entries etc to be on the same line
After some investigation I found that the problem only occurred when I included the file dataTables.bootstrap.js - which makes the datatable use the current bootstrap theme. As DiogoDoreto said this did not have any floats so I added the following to the end of this file and this gave me...
How to Filter a DataView by another datatable row attribute
Use LINQ to join the two collections on the common field. This will give you a projection that contains all 3 fields (1 field of the DataTable and 2 fields of the DataView) for only the rows that exist in both collections (as you are joining them). You can then...
How to add a checkbox to a GridView and select/deselect based on a SQL table row value
c#,html,asp.net,gridview,datatable
Add this for a column with checkbox <asp:TemplateField HeaderText="Complete"> <ItemTemplate> <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("CT").ToString() == "1" ? true : false %>' /> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField> ...
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...
Displaying all pages from the pagination of a datatable
javascript,jquery,datatable,pagination,jquery-datatables
DataTables 1.10 does not have this ability natively, however there are pagination plug-ins that provide additional functionality. One of them, Ellipses, has an extra option iShowPages allowing to set how many pages to display in pagination control. Below is a sample code: var table = $('#example').DataTable({ "pageLength": 5, "pagingType": "ellipses",...
jQuery DataTables Column Show/Hide Toggle using Bootstrap Modal
jquery,asp.net-mvc,twitter-bootstrap,datatable
You need to use the same code. Just instead of anchor tags you'll have check-boxes. <input type="checkbox" class="toggle-vis" data-column="0" value="Name"/>Name And your jQuery event selector will change. $('.toggle-vis').on( 'click', function (e) { // Get the column API object var column = table.column( $(this).attr('data-column') ); // Toggle the visibility column.visible( !...
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"]...
DataTable.Update Fails and Throws DBConcurrencyException
c#,datatable,sqlcommand,sqldataadapter,sqlcommandbuilder
This error only occurs when, to quote MSDN An attempt to execute an INSERT, UPDATE, or DELETE statement resulted in zero records affected. To get this error means that the database has changed since the DataTable was created. The error tells you that the UpdateCommand affected 0 of the expected...
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...
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()" ...
Bulk Exporting Data from Codeignitor to CSV using Database Utility Class
php,database,codeigniter,datatable,codeigniter-2
// top of your controller ini_set('max_execution_time', 0); // Also you can increase memory ini_set('memory_limit','2048M'); Download this helper and place in system/helpers/ and finally create csv like this $this->db->select('*'); $query = $this->db->get('your_table'); $this->load->helper('csv'); query_to_csv($query, TRUE, 'filename.csv'); ...
Don't split the string if contains in double marks
Don't try and re-invent the CSV-parsing wheel. Use the parser built into .NET: Microsoft.VisualBasic.FileIO.TextFieldParser See http://stackoverflow.com/a/3508572/7122....
DataTables search child row content
jquery,datatable,datatables,jquery-datatables,datatables-1.10
I have to ask : What make you believe you can search in child row content you are injecting dynamically only when the child rows are shown? And how should a column() search could cover content from other rows, ever? When this said, there is of course a workaround. Instead...
Datatables for mutiple tables on one page having different td count each
Using class cannot be applied because each table has different td's count There is nothing to do when we use datatable for mutiple tables it works only for the tables which have same count of td's and can be applied using the both table's same class Live Demo...
Is it possible to define a column type in DataTable at run time?
c#,datatable,system.data,system.data.datatable
tempCheck is already a type, so you don't need the typeof: myDataTable.Columns.Add(columnName, tempCheck); typeof is an operator that is used to get an instance of System.Type from a type name, and this is done at compile time. The error "The type or namespace name 'tempCheck' could not be found" is...
binding on p:dataTable which is included multiple times causes ID unqiueness exceptions
jsf-2,primefaces,binding,datatable,facelets
You're basically binding physically different <p:dataTable> components to one and same EL variable. If this EL variable is not null (i.e. already set by a previous component in the same view), then JSF will reuse it instead of creating a new one, and override all of its attributes during view...
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"...
Categorizing a hash of arrays into a datatable. rails
ruby-on-rails,ruby,ruby-on-rails-4,datatable
In this case you can just call flatten twice. myhash = {"Level 1" => ["foo", "bar"], "Level 2" => ["foo", "bar", "foobar"]} myhash.flatten.flatten => ["Level 1", "foo", "bar", "Level 2", "foo", "bar", "foobar"] ...
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...
JQuery Datatable Error “Cannot read property 'length' of undefined”
According to the DataTables 1.9 documentation, sAjaxDataProp specifies the name of the array inside the returned JSON object that contains the entries. At the same time, DataTables appears to accept entries as arrays, not objects. Your return format should be: {"data": [["[email protected]","06-07-2015 7:55 pm","xx.xx.xx.xxx"],["[email protected]","06-07-2015 5:45 pm","xx.xx.xx.xxx"]]}...
DataTable.Rows returns second row in c#
Please change your connection string's HDR=YES property to NO as per my comment. conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = '" + path + "'" + @";Extended Properties=""Excel 8.0;HDR=NO;IMEX=1;ImportMixedTypes=Text; TypeGuessRows=0"""; "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.....
XPages. Hide column in DataTable
I can confirm I get exactly the same behavior out of this. I agree that I would expect the entire column to not render, but that's apparently not its behavior. I've always viewed the xp:dataTable control as a slightly dressed up xp:repeat, but not with as much window dressing as...
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/...
Best way to remove duplicates from DataTable depending on column values
I think this can be done more efficiently. You copy the DataSet once with DataSet importedDataCopy = importedData.Copy(); and then you copy it again into a dictionary and then you delete the unnecessary data from the dictionary. I would rather just remove the unnecessary information in one pass. What about...
Convert DataTable into object[ , ] array with LINQ
You cannot use Linq to create a rectangular array - Linq only operates on single-dimension arrays. You will need to use traditional for loops: object[,] objectArray = new object[dtReportData.Rows.Count, dataTable1.Columns.Count]; for(int row = 0; row < dtReportData.Rows.Count; row++) { for(int col = 0; col < dtReportData.Columns.Count; col++) { objectArray[row, col]...
Datatables select and search filter
You can accomplish this utilizing the Column Filter plugin ('#example').dataTable().columnFilter({ aoColumns: [ { type: "text" }, { type: "select", values: [ 'Adam', 'Bob', 'Casey', 'Dave'] }, { type: "text" } ] This sets up a filter for each column. The first column will be text, second a drop down containing...
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...
Add Column to DataTable before exporting to Excel file
vb.net,excel,datatable,type-conversion,dataview
The issue was in my CreateExcelFile() method. I inherited the app I'm modifying and assumed the method dynamically read the data in the DataTable and built the spreadsheet. In reality, it was searching the DataTable for specific values and ignored everything else. 2 lines of code later, I'm done....
There is no row in position 1 but in debug mode it is correctly mapped
You may have a row at position 1, but you may not have a row at position 2. Remember that the rows collection is zero based. So when you do this: TxtItem.Text = dt.Rows[0]["t_item"].ToString(); lbldesc.Text = dt.Rows[1]["t_idsc"].ToString(); You are setting TxtItem.Text to "t_item" of the first row. But you are...
Primefaces datatable duplicate “No records found” while doing column freeze for empty records
jsf,jsf-2,primefaces,datatable
I didn't find any solution to above problem.So, I manually overrided the css of second table generated by the above p:datatable. My css is: <style> .ui-datatable-frozenlayout-right .ui-datatable-empty-message td { display: none; //or visibility:hidden; } </style> ...
Datatable link stops working after page one
javascript,php,jquery,mysql,datatable
use below code your problem is called Event Delegation. Event delegation allows us to attach a single event listener, to a parent element, that will fire for all descendants matching a selector, whether those descendants exist now or are added in the future. <script> jQuery(document).ready(function($) { $(document).on('click','.clickable-row',function() { window.document.location =...
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++) {...
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())); ...
How to count the entire number of rows in a datatable
$(document).ready(function() { // Initialize your table var table = $('#jobSearchResultTable').dataTable(); // Get the total rows alert(table.fnGetData().length); } ); Source: jquery datatables row count across pages Another method: table.fnSettings().fnRecordsTotal(); see which one works for you Source: http://datatables.net/forums/discussion/2278/how-to-get-number-of-rows...
pick a random records from a datatable
Could you try something like, dt2 = dt.Clone(); dt.AsEnumerable().Select(x => x["IC_NUMBER"].ToString()).Distinct().ToList().ForEach(x => { DataRow[] dr = dt.Select("IC_NUMBER = '" + x + "'"); dt2.ImportRow(dr[0]); dr.ToList().ForEach(y => dt.Rows.Remove(y)); dt.AcceptChanges(); }); EDIT: int totalWinners = 10; Random rnd = new Random(); dt2 = dt.Clone(); for (int i = 1; i <= totalWinners;...
how to remove a row from datatable
This should do the trick instead of Delete and AcceptChanges: Form1.dt.Rows.RemoveAt(i); Update: Caution when using a DataAdapter and relational data source along with your DataTable. Using Remove modifies the DataTable, but not the actual data source. See https://msdn.microsoft.com/en-us/library/03c7a3zb(v=vs.110).aspx...
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...
Binding datatable values into a checkbox that's placed inside GridView
You code is right you may not be getting check boxes to be checked because some values may be saved with a space at beginning or at end so you need to use Trim() method also just to make sure that your condition satisfies call ToUpper() to convert database value...
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"},...
Stored Procedure for insert
sql-server,stored-procedures,datatable,syntax-error,sql-insert
You need the form of insert that takes a select rather than a values: insert into theTable (col1, col2, ...) select col1, col2, ... from ... where... All the features of a select are available (column aliases, grouping, joins, sub queries, ...)....
ignoring jquery plugin datatables empty rows on post action to database with laravel 5
I think you've over-complicated things. Using a combination of filtering the array and then an incremental for through the array will not work. If any entries are filtered out, your for loop won't make it to the end of your array. Just step back and simplify it: // assumes the...
Access particular row of p:datatable in Backing Bean on click of h:CommandLink without binding attribute
jsf,jsf-2,primefaces,datatable
But MOST of all, Take a look at the first selection example in the PrimeFaces showcase http://www.primefaces.org/showcase/ui/data/datatable/selection.xhtml
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...
Column [key] throws MissingPrimaryKeyException in dataTable
If you want to use DataRowCollection.Find you have to specify the DataTable's PrimaryKey(s). I would use Linq-To-DataTable: DataRow row = someTable.AsEnumerable() .FirstOrDefault(row => row.Field<string>("key") == "CUSTOMDATEFORMAT"); if(row != null) return row.Field<string>(1); // or by name but with correct type else return "something else"; Then you can use all methods you...
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...
How to change the position of text “No data available in table” in datatables?
javascript,jquery,css,datatable,jquery-datatables
Try this: Use this class in your css to position it in the right way . "td.dataTables_empty" . ...
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...
spring mvc- primefaces: pagination does not working
spring,jsf,primefaces,datatable,bootstrap
I'm not sure what went wrong on your end, but I copied your code into a testproject and the paginator works just fine with PrimeFaces 5.2.
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()); ...
Updating Pagination for polling with dataTables object
If you are using the legacy dataTables, then there is a plugin which does a standing redraw , meaning, retain the current page. http://datatables.net/plug-ins/api/fnStandingRedraw Import the plugin and use as follows $(document).ready(function() { var table = $('.dataTable').dataTable() table.fnStandingRedraw(); } ); For DataTables 1.10+ onwards, this is in-built in draw(false) method....
How to read data from Excel starting from given row and getting proper type inference
.net,excel,datatable,ado,type-inference
This is a dark road you have started down. I've been down it recently and after trying several options, I ended up going with ExcelDataReader. This is a nice .NET library that does a decent job importing data from .xls and .xlsx files. Basic importing is below: IExcelDataReader excelReader =...
Adding property in php datatable for google chart custom html tooltips
javascript,php,jquery,datatable,google-visualization
You were on the right track with array('type' => 'string', 'role' => 'tooltip', 'p' => '{ html : true}'),but you need to have an additional array for the 'html': true part. It should look like array('type' => 'string', 'role' => 'tooltip', 'p' => array('html' => true)); I tried it out...
C# - SqlDataAdapter doesn't fill DataTable no matter what
God damn, I never bothered to check the Rows property of the DataTable, turns out it did work. I thought it didn't because while in debugging mode Visual Studio is very misleading because when you hover over the datatable variable it just shows "{}" which usually would mean that the...
NullReferenceException on DataRow C# [duplicate]
Initialize your array first: ObjectProperties aa = new ObjectProperties(); aa.fieldParams = new FieldParameters[parsedData.Rows.Count]; //initialize your array first You also haven't initialized your Array's elements: foreach (DataRow row in parsedData.Rows) { aa.fieldParams[counter] = new YourArrayType(); //instantiate the current element //...your code... counter++; } Remember you have to instantiate every element of...
JSF NumberFormatException with f:setPropertyActionListener
jsf,datatable,el,jsf-2.2,setpropertyactionlistener
You kind of coded your self into a corner with your fancy bean implementation. Take a look at the processing steps for the f:setActionPropertyListener. Your code is choking at step 3: If the value of the "value" expression is not null, call getType() on the "value" and "target" ValueExpressions to...
How to unhighlight row in dataviewgrid C#
You can use dataGridView1.ClearSelection(); Or dataGridView1.CurrentCell = Nothing; Or dataGridView1.Rows[Index].Selected = false; ...
How to remove datatable from dataset?
You only need this selectedData.Tables.Remove(dt); But it would be better if you first check that DataSet contains the table which you are trying to remove. Also check if the DataTable can be removed from DataSet as pointed by Gianni B. if(selectedData.Tables.Contains(dt.name) && selectedData.Tables.CanRemove(dt)) selectedData.Tables.Remove(dt); Remove method does not return anything....
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...
How to upload/import a file in the new R shiny version 0.12 using DT package
Your code is fine. Are you sure you're updated to the absolute latest shiny and DT? Both of them have been updated pretty heavily the past couple weeks, so make sure you install their GitHub version. I would guess that one of the packages is not up to date. Note...
Jquery datatable group by two columns with expand and collapse
From documentation, .rowGrouping({ iGroupingColumnIndex1:2 ,bExpandableGrouping: true, // expand/collapse first column bExpandableGrouping2: true}); // expand/collapse second column updated fiddle: jsfiddle.net/RgKPZ/493/, you can set indentations with necessary css....
