I have here a huge csv file with millions of rows entries. I want to load this data in a vb.net application, what datatype should i use, datatable, array or sth. else? It needs to be as fast as possible. how i can optimize the loading of the data? I once loaded this data in a datatable and it took days.. then i exportet it as xml data and loaded this xml file with the data. this was about thousand times faster.
View 5 Repliesan application i developed using vb 2008 express, to fill a web form with data from an access database, one after another when a button is clicked hasn't given me what i expected. the loop was suposed to stop after filling web form with the first data on clicking a button and continue to fill the webform with the next(2nd) data from the database on clicking the button again. Below is the code i wrote
Private
Sub STARTButton_Click(ByVal
sender As System.Object,
ByVal e
[Code]....
I have a window application develpoed in vs 2008, framework 3.5, in which i have put a button.. Now where i click that button the other text boxes are filled up with the data from database thru web service.. what i want is while all text boxes are being filled i want to show an animated loading gif image till data loading is completed in all the text boxes.. i have tried to use image picture box but while data is loading gif image is displyes but in static mode.. cant see animation... i think this is because data loading and animation both are done thru one UI thread..
View 8 RepliesI have a program to make for a class i am in and i am stuck on this one part, its a form application where you have to enter the first and last name of five students along with their final grade then you click a submit button after each one and i need it so that after all five buttons are clicked it activates the summarize button and i can't figure out how to do that and another thing when you hit the summarize button it has to compare the grade against the value of a text box containing the pass threshold to amount how many passed or failed.
View 1 RepliesI need to store a calculation to use later and obtain a new calculation
[Code]...
I have used the following code to get bandwidthIt works but i have following doubts1.I need Total Internet Data transferred in MB, how do i convert?, total data transferred (download+upload) varies with other bandwidth monitoring applications. how do i get exact data transferred?2.I need to exclude file transfer in local LAN in Data Transfer, The follwoing method includes internet data transfer + Local file transfer
Option Explicit
Public Enum OperationalStates
MIB_IF_OPER_STATUS_NON_OPERATIONAL = 0
[code].....
I have attached that file. The sample of data are as below:
PUBLT 167_89 656 PB -38321.478 6807.984 657 PB DAUD 200005041 278.271074.5150 69.4035 08370074.1830 69.2755 083800254.1925290.4620083900254.5615291.010008400008390098.2710 74.3630 20.3943
[Code]...
the main problem here is i want to use 2 value from 2 line in one time to do that calculation... if those data in one line its not a problem..
i need to take data input from a textbox such as this
13:41 A spider loses 20 hitpoints due to your attack.
13:41 You gained 18 experience points.
13:41 Loot of a spider: 2 gold coins, meat
13:41 A wolf loses 25 hitpoints due to your attack.
13:41 You gained 27 experience points.
[Code]...
i want to know that when im adding my data in form after loading one person data then 2nd person data the 2nd person data cannot come to next line it is adding on the same line.plz tell me wat can i do?
View 6 RepliesI am trying to load a xml file into a data set by loading the information into a data row. when i try to complete the task it throws a nullReferenceException. the row has data in it and i used the code earlier and it work.
[URL]
Imports System.IO
Imports System.Xml
Public Class frmMain
[Code].....
which way do you think is best? Using connection As New OleDb.OleDbConnection(My.Settings.CustomerConnectionString & My.Settings.CustomerDatabasePath)
Using command As New OleDb.OleDbCommand("SELECT [customer] FROM [tblCustomers] ORDER BY [customer] ASC", connection)
connection.Open()
Using reader As OleDb.OleDbDataReader = command.ExecuteReader()
[Code]...
Its my first time here. And I'm a new to programming and to VB.NET too so please don't mind if I say or ask stupid things :POkay here's my question. Let's say I have a table which contains student details. (Student Code, Name, DOB, Sex, Address, Contact No) and I have a grid which shows ONLY the student code and the name.
Now What I wanna do is when you double click on a cell, ALL the data related to that particular row should be loaded into a form with textboxes.
I'm trying to load data into a DGV row at a time from a dataset and keep getting the following error on the highlighted line.
Private Sub LoadClientGrid()
Try
grdClientList.Rows.Clear()
For Each row As DataRow In rsClientGrid.Tables("tblClients").Rows
Dim grdRow As New DataGridViewRow
[Code] .....
I have an xml file called "QuotesxmlDoc", in my program I have written code for a search screen that searches the xml file for titles or keywords in quotes saved and the information is then shown in a datagridview, see the code below:
Private Sub btnSearchQoutes_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchQoutes.Click
Dim xmlnav As XPathNavigator
[Code].....
On the main screen of the program, I want to show all the saved quotes from the xml file in a datagridview, I just need to show the date, category, author, title of the quotes, I also need the datagridview to refresh everytime a new quote is saved.
Try something along these lines:
TextBox1.Text=(dt1.rows(DataGrid1.CurrentRowIndex).item(0).tostring)
where dt1 is the datatable you're using as the data source and you want the data from the first column of the grid to be shown in the text box.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('381571b4631840c6b8a8abfe5b54ed97')
Loading into a Datagridview, Nothing seems to work no Error even with test data Added.
Here is some code
Dim SqlConnectionString, SqlCommmandText As String
Dim SqlAdapter As SqlDataAdapter
Dim Table As DataTable
[code]....
I have a small VB program written using VB Express 2008Part of it uses an Access database this all works fine using the custom classes.I want to extend it to use some parameterised settings which I have stored in a table in the same Access database .I want to load these parameters from the table at program startup, then use them later in the code as needed.In SQL I want to execute :-select parameter, parameter_value from system_ parametersthen store this in an array which I want to index on the parameter column/elementAny suggestions on how I can load this data into the array ?
View 1 RepliesRichTextBox1.LoadFile("c:pic.jpg", RichTextBoxStreamType.PlainText)It seems like it loads the data correctly, but the data is all wrong. I know this because when I use a packer sniffer, the data of the file that I sent is different when I sent the file manually.ou can also try RichTextBox1.SaveFile("c:pic.jpg", RichTextBoxStreamType.PlainText) after the picture of the data has been loaded and the picture becomes corrupted (won't show any picture anymore)
View 7 RepliesI have created a project with a search form. add new record form and a also have an edit record form.Under the add new record form I have added an attachment button an a opendialog where I can select multiple files, so far this is working great, then I add the name of each file that I select and added to a listbox, so far so good,for example:
View 4 RepliesI have an webbrowser, and I want to save the start page into an XML file... I have a textbox where I can input the start page url and an "apply" button, I got the apply button to work, and the URL saves into my_start_url.xml.
[Code]...
I am trying to show xml data in an Ultragrid. I have tried using Ultragrid.loadfromxml and using the location of the file and i have also used a file input stream and throw that into the load xml method
View 3 RepliesI have a tab control and what I want to do is when I click on the tab, data is loaded into the DGV. This does not happen until I click on the tab page several times and then the data is shown. What I did was I took the dataset fill from the Form_load and put it in the Tabpage2_GotFocus procedure thus:
[Code]...
Our application is using VBSQL.OCX on Sql server 2000 to create temporary tables and load pipe delimited data from a text file with predefined format into the tables. It is failing intermittently doing this. 99% times it works perfectly. But on occasions it does fail with error. Once the process is rerun with the same input file it runs successfully.Basically the architecture is of Store/Head Office where there are around 200 remote stores sending set of data files to the Head Office. At HO our application sequentially processes each store which has all the set of files received, creates a corresponding table, loads the data from the file into the table and moves onto the next store.If it is for some reason not able to load the file for a store, it gives a failure message and continues with next store.Error which the OCX throws is "Attempt to convert data stopped by syntax error in source field"
View 1 RepliesI'm writing a forms application. I'm adding a piece that allows you to double click on a row of a datagridview control to open a new form with more details. These additional details are pulled from a database, which takes a bit of time to finish.If I run the DB query from the form's load event, the form doesn't show up until everything in the load event has completed, which can take several seconds.I want the form to show up instantly when you double click, and all of the fields to be populated once the data is ready.Is there an event I should be using other than Load?
View 6 RepliesWhen loading file data to the listbox that I recognize some characters and replace them for me "?"I put the code I use to load the data:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If OpenFile.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
Using fs As FileStream = New FileStream(OpenFile.FileName, FileMode.Open, FileAccess.Read, FileShare.Read)[code]....
I have a grid loaded with data. What I wanna do is when you double click on the row header, the data in that row should load into a form with textboxes. I've chosen the RowHeaderMouseDoubleClick as the evnt for this but dunno how to start.
View 2 RepliesProblem:Combo Box in CHILD MDI Form is not reflecting the "data" added from the table1. I have an MDI Parent form, and MDI Child Form.2. The Child form contains a Combo Box, and i want to load the data to this combo box dynamically "selecting from" a table. I am able to select from the table, and using the following code to add rows to the combo box
frmForeignKey.cmbSource.Items.Add(targetSSID) frmForeignKey.cmbTarget.Items.Add(targetSSID)
3. The Child form is called with the following code from MDI Parent form
Dim fkChild As New frmForeignKey fkChild.MdiParent = Me fkChild.Show()
[code].....
I'm populating a DataGridView from a file with the following
Dim fnum As Short = FreeFile()
Dim inputLine As String
Dim i As Short = 0
Dim strAuditDate As String
Dim strAuditTime As String
Dim msg As String
[Code]...
When I do this, the MessageBox.Show shows the contents of a row, which is tab delimited. How do I get the data that I read to display in columns of the Gridview?
I have saved an image in database using following code.
ofd.ShowDialog()
vrPicHolder = IO.File.ReadAllBytes(ofd.FileName)
Dim drPic As DataRow
drPic = DsPic.tblPicTest.NewRow
drPic.Item("Picture") = vrPicHolder
[Code]...
i have access database connected to application.. i have a table in database called "clanovi" (members) and first column items loaded to combobox their name and surname..now..when i select one of them from combo box i need all their other info loaded into several text boxes..adress,email etc..all of that info is in the same table ..i need some example code too .
View 6 Replies