22 Solved Topics
Remove Filter | |
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 … | |
| 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 … |
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 … | |
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 … | |
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 … | |
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 … | |
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"; … | |
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. … | |
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 … | |
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 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 … | |
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 … | |
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 … | |
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 … | |
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 … | |
Hello. I have a datagrid with 9 columns. I want to add a one row from data table who is that same. I believs I can do it that: [CODE]DataGridViewRow drow = new DataGridViewRow(); foreach (DataRow wiersz in dTable2.Rows) { for (int i = 0; i <= ilosckolumn - 1; … | |
Hi there, Does anybody know how to refresh a windows form after inserting into a database using a dataTableAdapter or any other method for that matter without having to close the form or use the fill method to reload the form? The problem with this is that you are taken … | |
hi all, am just curious to know...which is the better or more efficient way of these two? Note: tblOD is a DataTable [CODE] For dtrows As Long = 0 To tblOD.Rows.Count - 1 dgv1.Rows.Add(tblOD(dtrows)(0), tblOD(dtrows)(1), _ tblOD(dtrows)(2), _ tblOD(dtrows)(3), tblOD(dtrows)(4), _ tblOD(dtrows)(5), tblOD(dtrows)(6), _ tblOD(dtrows)(7)) Next dtrows [/CODE] OR [CODE] … | |
Can someone provide sample code on how to create and fill a DataTable with the table schema and data from a mySQL database? I found examples where you set up columns and other information programmatically. But i wanted to know if there a way to "sync" the schema in the … | |
Friends I m working with RowFilter, its working good with String Data, and like statements, specially its Autometed functuallity with string data is good, just like in follwing code (it is written in Textbox "txtSearch"s TextChanged Event) [CODE] Private Sub txtSearch_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSearch.TextChanged … | |
I have created simple database project, using vb.net, ado.net, oledb, datatable, datagridview. My program is working nice, I just need Help with how to add, delete, update and edit records. Can any one please and please help me in this case, or can provide any good tutorial or source code … | |
Hi, Any advice please. I have various forms (e.g. frmCustomers, frmProducts), each having bindingSources and tableAdapters. The forms have the required Fill methods triggered from their constructors. It appears that the DataTable filled only exists in the App for as long as the form does. What I want is a … |
The End.