53 Topics

Member Avatar for
Member Avatar for patk570

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 …

0
212
Member Avatar for nosfa

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 …

Member Avatar for Miurei
0
354
Member Avatar for Mushfik

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 …

Member Avatar for diafol
0
355
Member Avatar for westsiderailway

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 …

Member Avatar for westsiderailway
0
3K
Member Avatar for G_Waddell

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 …

Member Avatar for Cesc_1
0
205
Member Avatar for jaasaria

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 …

Member Avatar for Begginnerdev
0
947
Member Avatar for ricardo.scheufele

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 …

Member Avatar for PerplexedB
0
337
Member Avatar for pritesh2010

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 …

0
174
Member Avatar for themaj

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 …

Member Avatar for ss125
0
280
Member Avatar for cgull

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: …

Member Avatar for cgull
0
311
Member Avatar for Kratoswoo

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 …

Member Avatar for Kratoswoo
0
228
Member Avatar for GeekPlease

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 …

Member Avatar for GeekPlease
0
1K
Member Avatar for Pundia

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 …

Member Avatar for TnTinMN
0
2K
Member Avatar for hatebin

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 …

Member Avatar for LastMitch
0
187
Member Avatar for HunainHafeez

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"; …

Member Avatar for HunainHafeez
0
1K
Member Avatar for kindofsudden

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. …

Member Avatar for TnTinMN
0
1K
Member Avatar for lulu79

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 …

Member Avatar for lulu79
0
4K
Member Avatar for kindofsudden

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 …

Member Avatar for kindofsudden
0
191
Member Avatar for kindofsudden

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 …

Member Avatar for kindofsudden
0
286
Member Avatar for lulu79

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 …

Member Avatar for lulu79
0
4K
Member Avatar for lulu79

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 …

Member Avatar for lulu79
0
819
Member Avatar for Hari Murthy

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 …

Member Avatar for pritaeas
0
100
Member Avatar for jbutardo

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. …

Member Avatar for Maligui
0
204
Member Avatar for tendaimare

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 …

Member Avatar for Maligui
0
263
Member Avatar for crazyvonzipper

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 …

Member Avatar for Michael27
0
260
Member Avatar for themaj

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 …

Member Avatar for themaj
0
267
Member Avatar for sicko

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 …

Member Avatar for Mitja Bonca
0
120
Member Avatar for kram54

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 …

Member Avatar for Mitja Bonca
0
213
Member Avatar for apals

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 …

Member Avatar for Mitja Bonca
0
210
Member Avatar for jbutardo

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 …

Member Avatar for jbutardo
0
542

The End.