You could actually shorten it down considerably. You can think of the Select() extension method as a type converter. The conversion could then be written as this: List<Cards> target = dt.AsEnumerable() .Select(row => new Cards { // assuming column 0’s type is Nullable<long> CardID = row.Field<long?>(0).GetValueOrDefault(), CardName = String.IsNullOrEmpty(row.Field<string>(1)) ? “not found” : row.Field<string>(1), }).ToList();
I assume “direction” is “ASC” or “DESC” and dt contains a column named “colName” public static DataTable resort(DataTable dt, string colName, string direction) { DataTable dtOut = null; dt.DefaultView.Sort = colName + ” ” + direction; dtOut = dt.DefaultView.ToTable(); return dtOut; } OR without creating dtOut public static DataTable resort(DataTable dt, string colName, string direction) … Read more
First, your second option isn’t quite valid HTML in the sense that all of the rows (TR) in a table should contain an equal number of columns (TD). Your header has 1 while the body has 3. You should use the colspan attribute to fix that. Reference: “The THEAD, TFOOT, and TBODY sections must contain … Read more
Rows effectively returns IEnumerable (DataRowCollection), so the compiler can only pick object as the type for var. Use Rows.Cast<DataRow> if you want to use var. Cast is defined on Enumerable, so you have to include System.Linq.
The smartest thing to do would be to make sure your DataTable is typed, and this column is of type DateTime. Then when you go to actually print the values to the screen, you can set the format at that point without mucking with the underlying data. If that’s not feasible, here’s an extension method … Read more
Just bind the table to the view itself instead of to a bean. <h:dataTable binding=”#{table}” …> Then you can use #{table.rowIndex} where necessary. E.g. <h:column>#{table.rowIndex + 1}</h:column> Note that the code is as-is and that the EL variable name table is fully to your choice. See also: How does the ‘binding’ attribute work in JSF? … Read more
You should not set datasource of your listbox and/or combobox in this order ComboBox1.DataSource = dataTable; ComboBox1.ValueMember = “id”; ComboBox1.DisplayMember = “name”; Instead, this is correct order: ComboBox1.ValueMember = “id”; ComboBox1.DisplayMember = “name”; ComboBox1.DataSource = dataTable; NOTE: setting datasource should be last line. If you set datasource first, SelectedIndexChanged event will fire and you may … Read more
Do you mean like this?: dtData.Select(“ID=1 AND ID2=3”);
You can use DataTable.WriteXml Method. Here is an example; How can i convert my datatable into XML using C# 2.0? string result; using (StringWriter sw = new StringWriter()) { dataTable.WriteXml(sw); result = sw.ToString(); } If you don’t actually need a string but read-only, processable XML, it’s a better idea to use MemoryStream and XPathDocument: XPathDocument … Read more
After fiddling around quite a bit I found that the DataTable.Load method expects a primary key column in the underlying data. If you read the documentation carefully, this becomes obvious, although it is not stated very explicitly. If you have a column named “id” it seems to use that (which fixed it for me). Otherwise, … Read more