6 ●4 I have a code that displays an array from GeoTab SDK, I am able to get the array to display in the console.log, and it populates the results like normal, However, When I try to populate the data in the table, nothing shows but the headings. Here is my code, and I will generate an object array and paste the code as well. I know the data that is generated is valid data, function generateDutyStatusLogSearch1(){ api.call("Get", { "typeName": "DutyStatusLog", "search": { "statuses": ["D", "OFF", "SB", "ON"], }, }, function(dutyStatusLogs) { var uniqueDrivers = {}; var multicall = []; …

Member Avatar
+0 forum 0

Hello. I have a SQL database called bd with a table called dados. I want to get one row from it. Web.config <add connectionString="Data Source=(local);Initial Catalog=bd;Integrated Security=True" name="bd" providerName="System.Data.SqlClient"/> variable declarations Dim DS As New bd Dim a1row As bd.dadosRow this code in the method won't return anything. In fact it throws a "object not set to an instance of an object" error. a1row = DS.dados.FindBycode(5440987) but if I perform a query I get the values: <img alt="snapshot" src="[https://www.flickr.com/photos/29661370@N04/21923636492/](https://www.flickr.com/photos/29661370@N04/21923636492/)"/> Where did I go wrong? Thanks

Member Avatar
Member Avatar
+0 forum 3

Hi. Below is the code which parse data from mysql into json, but for the name column i want to have <a href="http://example.com">column name</a> instead of jst the column 'name'. is it possible in any ways. <?php $link = mysql_pconnect("localhost", "user", "pass") or die("Could not connect"); mysql_select_db("userdb") or die("Could not select database"); $arr = array(); $rs = mysql_query("SELECT id, name, active, date FROM clicks"); while($obj = mysql_fetch_object($rs)) { $arr[] = $obj; } echo ''.json_encode($arr).';'; /* //The json object is : */ ?> Thanks

Member Avatar
Member Avatar
+0 forum 1

hi there, Dim queryString As String = "select avg(pumpnum) from petrol_table" Using adapter As New SqlDataAdapter(queryString, connectionString) Dim table As New DataTable adapter.Fill(table) Dim row As DataRow = table.Rows(0) TextBox5.Text = row.ToString as the code stands now, all i get in the textbox is "system.data.datarow" the column called "pumpnum" is a type "int" in sql. could someone please, show me where i am going wrong. Thanks :-)

Member Avatar
Member Avatar
+0 forum 1

Hi, Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes: I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour. Here is an example, if I have a table in Oracle with 3 rows (or records) in it and run the following query in my code `SELECT * FROM MYTABLE` it will return only two rows! If I run the same query through TOAD I get all 3 rows. Does anyone …

Member Avatar
Member Avatar
+0 forum 3

hi guys , i have a problem with my loading/refresh record in my form. i have only almost 500 record and take so long before refreshing/display the data. i have a user input form where user enter their record and while saving(direct to the database) and refreshing data i just call only my function getrec (). pls give me some idea to fix this problem. pls take a look Dim ActiveTable As New DataTable Private Sub frmRef_Userlist_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load getrec End Sub Private Sub dtBind(ByVal dt As DataTable) 'slow start here bs.DataSource = …

Member Avatar
Member Avatar
+0 forum 5

Hi, I have a class called "car" with - I have no ideia how to say this in english - "data members" as the following: Public pneu As classDoor Public mat As classTire Public length As Double And so on. All the related classes have null constructors. I have a tab control where each tab is equivalent a one of this features. The tab "Tire" with respect to "pneu", for example, has the following properties: Public Property materialh As String() Set(value As String()) mat = value End Set Get Return mat End Get End Property Public Property diameterh As String() …

Member Avatar
Member Avatar
+0 forum 5

i have follwing data in datatable how to convert it to xml ErrorType UtilityType MstLocCode MDescription SubLocCode SDescription FieldName FDescription 1 Elect NM0001 XMN001 ABC ddsafs 1 Elect NM0001 XMN001 XYZ ddsafs 1 Elect NM0001 XMN001 LMN ddsafs 1 Elect NM0005 XMN002 sds 1 Elect NM0006 XMN002 fghfgh Gas ddsafs 1 Elect NM0002 asas 1 Elect NM0003 asas 1 Alect NM0004 asas 2 Alect NM0008 asas and my xml output will be like follwoing <Country Code=“Test”> <Error Type=“1”> <Utility Name=“Elect”> <MSTLOC Code=“NM0001” > <SubLocation Code=“XMN001”> <Field Name=“ABC” ErrorMessage=“ddsafs”/> <Field Name=“XYZ” ErrorMessage=“ddsafs”/> <Field Name=“LMN” ErrorMessage=“ddsafs”/> </SubLocation> </MSTLOC> <MSTLOC Code=“NM0005” > <SubLocation …

Member Avatar
+0 forum 0

Having another brain fart on what I believe is a no brainer. I'm trying to read the contents of a DBF and write it to an ACCDB table; this is a daily event and the DBF has between 500-1200 records each day. I have successfully read the contents of a DBF table and filled my da.Fill(ds, "Data") with it along with a DataGridView. Now I want to write the entire table with NO parameters to my ACCDB Table 'BlahBlah'; both structures are the same. I see a ton of samples & examples WITH parameters, but no cmd.command INSERT examples to …

Member Avatar
Member Avatar
+0 forum 11

Hello, This is the first time I am trying to use jQuery DataTable. I read a lot of articles, but I can't make it work. I hope someone can help. I need to build a table that displays Rugby games scores. The table I am building should look like this: <table cellpadding="0" cellspacing="0" border="0" class="display" id="example"> <thead> <tr> <th>Match</th> <th colspan="3">Results</th> </tr> </thead> <tbody> <tr> <th></th> <th>Team</th> <th>Halftime</th> <th>Final Score</th> </tr> <tr> <td colspan="4">Match: AA</td> </tr> <tr> <td></td> <td>Team A</td> <td class="center">1</td> <td class="center">2</td> </tr> <tr> <td></td> <td>Team B</td> <td class="center">1</td> <td class="center">2</td> </tr> <tr> <td colspan="4">Match: BB</td> </tr> <tr> …

Member Avatar
Member Avatar
+0 forum 2

So I have a Datatable that is supposed to show information. I have it working in Windows Forms but tranfering it over to asp.net so a little diffrent. I do not understand GridViews that much. So any help would be appreciative. I will not give everything away. I did a break and noticed that all the information was getting recieved but the gridview was not showing up. All of this is on page load. dr = dt.NewRow(); try { dt.Rows.Clear(); dt.Rows.Clear(); dt.Rows.Clear(); dt = new DataTable("MyTable"); dt.Columns.Add("Scale"); dt.Columns.Add("Cases"); dt.Columns.Add("Cases2", Type.GetType("System.String")); dt.Columns.Add("Cases3", Type.GetType("System.String")); dt.Columns.Add("Cases4", Type.GetType("System.String")); dt.Columns.Add("Cases5", Type.GetType("System.String")); dt.Columns.Add("Cases6", Type.GetType("System.String")); dt.Columns.Add("Cases7", Type.GetType("System.String")); …

Member Avatar
Member Avatar
+0 forum 1

Good day folks, I want to delete some records in my datatable using query. But I don't know how to do it. Can someone help me? Thanks For i As Integer = 0 To objChkArray.Count - 1 Dim rows As DataRow() = dtable.[Delete]("ct = '" & CInt(objChkArray(i)) & "'") For Each row As DataRow In rows dtable.ImportRow(row) Next Next

Member Avatar
Member Avatar
+0 forum 4

Hi everyone! I haven't seen this question here, so I'll give it a try. I'm from a country where some words have accents, like *María*. I have all this words in a database and I would like to use the Select function from a DataTable but ignoring accents in the database. I know this may be not possible; if it's not, it really should be implemented. Thanks in advance! This is my current code: dataTable.DefaultView.RowFilter = string.IsNullOrEmpty(text) ? string.Empty : string.Format("{0} LIKE '%{1}%'", field, text);

Member Avatar
Member Avatar
+0 forum 1

Hi all ! 1. I'm developing a Database Web aplication with PrimeFaces, JSF frameworks. 2. I've allready implemented Managment Bean, Session Bean and EntityClass. 3. What's the problem ? I need to populate `<p:dataTable>` with data from Dbase, but I need filtering on dBase level, because I'm going to deel with a lot of data form dBase. 4. What's the problem of the problem ? :) Each header of a row of the <p:dataTable> has a `<p:TextFiled>`. By inputting letters in to `<textField onchange="#{SomeBean.SendQueryAndUpdateDataTableWithResults}">` I what to send a Query to dBase and recewe List of records which are matching …

Member Avatar
Member Avatar
+0 forum 1

i am getting error ERROR: The specified string is not in the form required for an e-mail address. but when i pass static email address , it works , why ? protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connectionString); String command = "select visitorEmailID from tblvisitorSubscriptions"; SqlCommand sqlCom = new SqlCommand(command, con); SqlDataAdapter sqlDA = new SqlDataAdapter(command, con); DataTable DT = new DataTable(); try { con.Open(); sqlCom.ExecuteReader(); sqlDA.Fill(DT); foreach (DataRow dr in DT.Rows) { String Dr = Convert.ToString(dr["visitorEmailID"]); Response.Write("Email:" + "\"" + Dr + "\""); //Email sending part MailDefinition mailDefinition = new MailDefinition(); mailDefinition.From = "hunain.hafeez@gmail.com"; …

Member Avatar
Member Avatar
+0 forum 1

I created a table, created a dataview, and sorted the dataview. I then populated the table with three rows of data and all was good. I then changed one of the fields (Hours) in one of the rows which SHOULD HAVE caused it to re-sort, but it did not re-sort. It seems to only affect the last row of the dataview. I tried removing and re-applying the sort condition with no luck. Any idea what is up here? Function CreateStoreHours() As DataTable StoreHours.Columns.Add("Store", GetType(String)) StoreHours.Columns.Add("Hours", GetType(Double)) StoreHours.DefaultView.Sort = "Hours ASC" dgvStoresHours.DataSource = StoreHours End Function 'Here I popluated the grid …

Member Avatar
Member Avatar
+0 forum 4

I have datatable looks like below: ![table2](/attachments/large/3/table2.JPG "table2") I want to create a stack chart that will produce something like this: ![stack2](/attachments/large/3/stack2.JPG "stack2") I don't know where to start. I have google about how to create stack column but still can't get it. So far I have a chart but mcname not include (only have LINENAME at X-Axis, DURATION at Y-Axis and Count (As Frequency) at Secondary Y-Axis) ![chart12](/attachments/large/3/chart12.JPG "chart12") This is my chart code: ' Setup the chart With Chart1 .DataSource = grpTot ''Datatable name .Legends.Clear() .ChartAreas.Clear() .BackColor = Drawing.Color.Linen .ChartAreas.Add(New ChartArea("Fred")) With .ChartAreas("Fred") .AxisY.LabelStyle.Format = "HH:mm:ss" .AxisY.Minimum = …

Member Avatar
Member Avatar
+0 forum 4

This is probably one of those that is so simple I can't see it. I have a string variable called Market. The variable is user chosen and is the exact same name as one of many tables in my dataset. Basically I am having the user choose which table they want in a combobox, then I want to use that variable to access the table. So if the user picks "Market1" then I want to open the table named Market1. I am simplifying here, but need to know how to open: For ds.<variable here>.rows.count - 1 'perform steps Next How …

Member Avatar
Member Avatar
+0 forum 2

I have a datagridview bound to a datatable and it works great. However, when I try to programmatically change the datasource property to a different existing table, I get a blank datagridview with no cells. Although I have tried many bits of code to remedy the problem, this is the one that I felt should do the trick: dgvThresholds.DataSource = SquirrelDataSet.Tables("Threshold market 12") ThresholdMarketTableListTableAdapter.Update(SquirrelDataSet.Tables("Threshold market 12")) dgvThresholds.DataSource = ThresholdMarketDefaultBindingSource dgvThresholds.Refresh() Any advice on how to get this thing to work? Seems simple...

Member Avatar
Member Avatar
+0 forum 3

I have two datatables that generate a datagridview like below: 1) datatable name : grpDT ![119](/attachments/large/3/119.JPG "119") 2) datatable name : grpTot ![211](/attachments/small/3/211.JPG "211") I want to merge both datatable so that I the datagridview will be like this: ![34](/attachments/large/3/34.JPG "34") what is the best way to do this? do i need to create new datatable and merge it?

Member Avatar
Member Avatar
+0 forum 3

I want to display datatable result in a label. I have something like this : PLEASE TAKE ACTION FOR LINE **LABEL** But i want the result to be like this: PLEASE TAKE ACTION FOR LINE **Z3, Z5, Z8** I try to use loop but still cant get the result that I want. Here is my loop: If ds.Tables(0).Rows.Count <> 0 Then For i As Integer = 0 To dt.Rows.Count - 1 line += dt.Rows(i)("LINE").ToString() lblLine.Text = line Next End If Can someone help me please..

Member Avatar
Member Avatar
+0 forum 1

I am trying to integrate the ColReorder.js(http://datatables.net/extras/colreorder/) [ which enable columns re-ordering option] into my existing data-table. Its works good, but the problem is its affects the CSS / CSS not applying. I don't know whether its clashing with my existing js ( jquery.dataTables.js ). Please help me how to overcome this issue. Thanks.

Member Avatar
Member Avatar
+0 forum 1

Hi, I have this datatable that I need to loop for my excel exporting function. And I have to export data that exceeds the row limit of excel worksheet. now I want to know how to create a query of limit on the datatable.select in such way like in sql. Example: (In mySql) Select * from table **limit 0,10;** Is there such query on the datatable.select that I can use? Like datatable.select("LIMIT 0,10") Thanks.

Member Avatar
Member Avatar
+0 forum 1

when i use this code to save my datatable to the databaseit works well on the initial save save but when I access the database fill the datatable and then I delete some rows from the datatable and the "SAVE" the changes are not carried on to the database.How come the changes are not reflecting in the database? what can I do ? '*************************************************************************************** '****** SAVE PRODUCT RAW MATERIAL DETAILS IN THE GRIDVIEW ***************************** Dim myConn As OleDbConnection = frmLogIn.Conn Dim oledbCmdBuilder As OleDbCommandBuilder Dim changes As DataTable Dim sql As String = "select * from ProductRawMaterial" Dim oledbAdapter As …

Member Avatar
Member Avatar
+0 forum 1

HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable object with the linked values. This is tricky because the linking is not always the same, and the column Field Names might also differ. EG> [DataTable1] - [PersonId] - [FirstName] - [Surname] - [Gender] ..... [DataTable2] - [ID] - [pID] - [DNA_Type] - [DNA_structure] Now assume [DataTable1] resides in a …

Member Avatar
Member Avatar
+0 forum 3

Trying to figure out the best way to do create a CSV export file from my source files and need some input. I'm trying to build a CSV export file for import to an Accounting System where there are 3 different tables mapped to a single field in the main table. Quick explanation/example: All tables are DBF and the structure is fixed by the Vendor & there will be no updating needed after CSV is created. The main table holds 'Transactions' and one of the fields 'xType' holds an integer. Let's say 1 through 4. 1 refers to a Payment …

Member Avatar
Member Avatar
+0 forum 4

Hi guys, I'm doing an application that works with an online mysql database. Here is a sample of my code: ~~~ Dim adapter As New MySqlDataAdapter("select * from my_table order by code", "server=my_server;User Id=me;password=password;Persist Security Info=True;database=database") Dim my_table = New DataTable adapter.fillj(my_table) ~~~ On the last line, the application freezes until the DataTable is filled. I realized that it doesn't happen with a local database. Is there a way to avoid this?

Member Avatar
Member Avatar
+0 forum 5

hi eveyone i have to big problem so this problem have two datatable first table like column1----column2----column3 row11-----row21-----row31 row12-----row22-----row32 i want to inset to other table column1---row11 column1---row12 column2---row21 column2---row22 column3---row31 column3---row32 my code: DataTable orjiTable = new DataTable(); DataTable gecicitable = new DataTable(); adptr.Fill(gecicitable); // orjiTable.Columns.Add(gecicitable.Columns[0].ColumnName.ToString()); // MessageBox.Show(gecicitable.Columns[0].ColumnName.ToString()); foreach (DataRow inRow in gecicitable.Rows) { string newColName = inRow[0].ToString(); MessageBox.Show(newColName); orjiTable.Columns.Add(newColName); DataRow newRow1 = orjiTable.NewRow(); string den = gecicitable.Columns[0].ColumnName.ToString(); newRow1[0] = den; orjiTable.Rows.Add(den); } for (int rCount = 1; rCount <= gecicitable.Columns.Count - 1; rCount++) { DataRow newRow = orjiTable.NewRow(); newRow[0] = gecicitable.Columns[rCount].ColumnName.ToString(); MessageBox.Show(gecicitable.Columns[rCount].ColumnName.ToString()); for (int cCount = 0; cCount …

Member Avatar
Member Avatar
+0 forum 3

Hello , i am working on a section of a project, that parses Logs from Postgres Database Server. The application is developed in C sharp Framework 4.0. A log is produced and displayed on a DataGridView with the following columns resultCode Statement Starttime Duration XT001 select * from PizzaMade 01-02-2012 03:10:14 00:04:10 - there are many loglines with the sameformat. - The Datagridview is filled from another loop by parsing a Textfile. My work is to generate stats from the data available in Grid in the following format Statement Count countpercent Occurs_on select * from PizzaMade 3 1.42 01/02 at …

Member Avatar
Member Avatar
+0 forum 2

Need help, I need to know on how can VB.net validates the format of each cell on the excel file that it opens, for example, the first row should only be numeric, or cannot be null, is it possible that vb.net can check it before it inserts it in the dataset or data table? how can it be done? thanks

Member Avatar
Member Avatar
+0 forum 4

The End.