Member Avatar
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 …
by nosfa in Software Development ()
Member Avatar
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 …
by Mushfik in Web Development ()
Member Avatar
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 …
by westsiderailway in Software Development ()
Member Avatar
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 …
by G_Waddell 131 in Databases ()
Member Avatar
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 …
by jaasaria in Software Development ()
Member Avatar
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 …
by ricardo.scheufele 8 in Software Development ()
Member Avatar
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 …
by pritesh2010 30 in Software Development ()
Member Avatar
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 …
by themaj 10 in Software Development ()
Member Avatar
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: …
by cgull 25 in Web Development ()
Member Avatar
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 …
by Kratoswoo in Web Development ()
Member Avatar
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 …
by GeekPlease 16 in Software Development ()
Member Avatar
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 …
by Pundia in Software Development ()
Member Avatar
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 …
by hatebin -1 in Web Development ()
Member Avatar
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"; …
by HunainHafeez 9 in Web Development ()
Member Avatar
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. …
by kindofsudden in Software Development ()
Member Avatar
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 …
by lulu79 in Software Development ()
Member Avatar
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 …
by kindofsudden in Software Development ()
Member Avatar
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 …
by kindofsudden in Software Development ()
Member Avatar
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 …
by lulu79 in Software Development ()
Member Avatar
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 …
by lulu79 in Software Development ()
Member Avatar
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 …
by Hari Murthy in Web Development ()
Member Avatar
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. …
by jbutardo -2 in Software Development ()
Member Avatar
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 …
by tendaimare in Software Development ()
Member Avatar
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 …
by crazyvonzipper in Software Development ()
Member Avatar
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 …
by themaj 10 in Software Development ()
Member Avatar
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 …
by sicko in Software Development ()
Member Avatar
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 …
by kram54 in Software Development ()
Member Avatar
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 …
by apals in Software Development ()
Member Avatar
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 …
by jbutardo -2 in Software Development ()
Member Avatar
I would like to give me your help please.. I have connected my sql db with vb and I m trying to make a UI. My question is that when I write code in order to create datatables and I fill them with the results of queries I've created, where …
by skran 9 in Software Development ()