I've made a program that calculates the costs of a transport, wich to my own surprice works. Because the prices vary with the weight of the transport, extra services and delivery within the 3 countries of the Benelux (Belgium, The Netherlands and Luxemburg), I use an array. The array is filled with data from a textfile (in this case not *.txt but *.prc). The data in the datafile is presented as follows :
[Code]...
so im trying to do this project, and it gives me a a data file, and asks me to use stream reader to put it in the combobox, and when i click the selected items from the combo box, it fills in the textbox's with other information i retrieved from the datafile...Does anybody know the solution?? heres what i have so far(option strict must be on) Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
this gets all the Item names from the data file to appear on the combobox... now if i knew how to get the other information to appear in the textbox's when i clicked on it,
I have a problem that I�m sure will not be hard to fix for anyone who has been using CR for some time.
To start I have created a program in VB2008 that uses a MS Access data file, I can connect to it with no problem and can also add data and amend data, so all seems to work perfectly. I have published it and it once again runs perfectly on another/s machines.I have now a requirement for a number of reports so have chosen CR for this purpose. I have connected the report to the database and that runs with no problems at all, that is until I try to run it on another machine, it seems not to be able to find the database and comes up with a database Login panel wanting me to log in with a password and Admin name.
I feel it's properly a problem with the path to the database but if I modify the path manually it still won't work.
I need to add a row of data to an exisitng TextFile that is in Tba delimited format. My program currently used ADO to read and update the table but that was creating to many problems with varying 3rd party providers of the Text File.
View 14 RepliesI am looking at trying to make a chart from my data I am retriving form a 3rd part textfile datafile
I am reading on report viewer, but so far everything i see references using an exisitng database, my database will be created at run time
I create datatables uisng OleDb connection and bindingsources to comboboxes and textboxes for display of data
I just need a simple x/y scattered chart/graph
I am inserting a record to a text file database using OleDb command Builder I am getting an error in one the fields could not insert .... expect type is decimal The problem is the column contains a mixture of Letter and numbers Ex:
[Code]...
I am using a VB.net application connected with a .mdf database file.The application is running successfully, and when I try to insert records its accepted.Everytime I close and reopen the application, new records from previous run disappear. This happens inside the VS IDE when I'm testing it.
View 2 RepliesI want to build an array with info from an XML file.
The number of columns is static, but the rows will be increased once in awhile and I want one column to populate in a combobox while corrosponding selectedindex appears in a textbox. I think I can figure that part out, but currently stuck at the array building.[code...
I have a TextBox column in my DataGridView. When the user clicks one of the cells in the column I turn that cell into a DataGridViewComboBoxCell and fill the items using the columns Tag property which is a 1-dimensional array with 3 items. This is what my Tag looks like:
?CType(sender, DataGridView).Columns(e.ColumnIndex).Tag
{System.Array}
(0): ""
(1): "No Reportable Result"
[Code]...
How can I fill this Percentage array with Sql data reader..
Dim StudentID As Integer = Me.ComboBox1.SelectedValue
Dim Percentage() As Integer
Dim con As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=D:Database
[code].....
I'm woking in aprogram that read sms from phone and show them in datagrid.berfore I link the datagrid to the database it read the show the message fine in the datagrid but now it show Error message
the code for the form load Code:Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0" & ";data source=" & Application.StartupPath & "SMS.mdb") Dim Mocmd As OleDbCommand = New OleDbCommand("Select * FROM TableMobinil", con) Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(Mocmd) Dim myDataSet As DataSet = New DataSet()
[Code]...
I am trying to port a program I wrote with old VB 1 and I have many control arrays in the program, and it was so easy to do this in older versions of VB, now I am trying to find how to do this and all the answers I have found are a major productions, to replace something that was so easy to do? I would think that microsoft would make programming easer with each new incarnation. instead they are making it harder. doing away with the DATA and READ statement, now it is much harder to fill an array with a loop, now you have to enter each item in an array ONE by ONE. they did away with the ON statement, I had several ON statements, I had to make complex Select case constructs. to replace a simple one word statement?
To make an array of controls in OldVB all you had to do is Name a Second control the Same as the First, and a dialog pops up and ask if you want to make an array, you click Yes, and that's it, what could be easier than this?
I have been told that the best way to do a search in VB is to fill an array with ALL the records from a table in a database and then filter the records from the array, instead of using the SQL statement Where.
View 25 Repliesthis is my code
Dim str As String = "str1,str2"
Dim array() As String = str.Split(",")
Dim MyListOfTextBoxes() As TextBox = {TextBox1, TextBox2, TextBox3}
[Code]....
i have 5 textboxes. i want to fill just textbox1 and textbox2 with array value. because no i have to word.but when i run the code "str1" repetition on textbox1,textbox2 and textbox3.
I have a series of checkboxes named cbS1 through cbS20 and I set 'Count' as an integer.What I need help doing is taking the value of count and check the checkboxes that are greater than the count.example: count = 7 so checkboxes 8-20 would be checked.Im not sure how to make an array out of the checkboxes to use in a loop.
View 1 RepliesI want to fill an Array and list box from a table, with ALL of the records.
I DONT want to use Displaymember. Like shown below...
CODE:
This is the code so far, but it is only filling with the first record.
CODE:
is it possible to fill up a 3 column ListView with an array.
View 5 Repliesmy Code for fill datatable is :
n1.SelectCommand = New SqlCommand("Select Code from PriceDrystore where AirplanCode = '" & lblAPcode.Text & "' and substring(Code,8,1)='" & lblRoute.Text & "' ", DS)
n1.Fill(z1)result this code = 8 items
[Code]...
I would like to get fill a String array with all the images found within a directory.Till now i use the following to get all the images with jpg format Dim List() as string = Directory.GetFiles(Path, "*.jpg")Now i would like to extend it and get all the image formats.Could i use the directory.GetFiles combined with an "ImageFormat enumeration"?
View 2 RepliesI want to modify this function to populate an array with each item in the database.I have tried various options, but I just can't get it to work
Private Function ConnectMe() As DataTable
Dim conn As String = "Server=192.168.0.36;Port=3306;Database=wswc;Uid=r oot;Pwd=Jack"
Dim cmd As String = "SELECT * FROM st_users"
[code]....
Instead of fill, I want to one by one add it to the dataset and also an array?
I need to fill an array with whole column from database table, so i have used reader to read the values from that column, but can not figure out how to put them into array (code below doesn't work) [Code]
View 3 RepliesI am using a select case loop to perform different tasks, one of the tasks the loop is doing is putting 1d arrays together into 3d arrays. But, when i come to print the 3d array only the 3rd "line" in the array is complete. Is there a way to pass variables created in a select case out of the select case?
Here is some code to try and explain better:
Select Case Int()
Case Is = 13
[code].....
then fill all tags and attribute of this page in vb arrayi know this is too much but would you expl
View 4 Repliesi want open html file in vb
then fill all tags and attribute of this page in vb array
This is my code:
Public UserBookings() As String
If dr.Read() Then
Dim intCounter As Integer
[code]....
I am trying to do is fill out a form with certain info, put the info into an array, and write it to a listbox using loops, arrays, and maybe a function if I need one. This is for VB2010 and here is what I have so far... I think there are ways to make it shorter but I cannot figure it out.... maybe just brain dead from all the coffee I have been drinking!
[code]...
I just want to display data of a single column from an oracle table into a datagridview or a listbox for readonly with no requirements to make changes to it. Simply display the information.What is the best way forward... To used DATAADAPTER or DATAREADER.s DATAGRIDVIEW SLOWER TO FILL THAN a LISTBOX.i am using the following code to fill datatgridview but for some odd reasons at time it is slow to display the data. I want to use listbox instead
Dim ds As New DataSet
Dim adp As OracleDataAdapter
adp = New OracleDataAdapter("select customer_name from customers")
[code].....
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 RepliesI have an array of people stored in a custom structure array... how can i copy this array to a temp array so that the temp array has all the same values as the original custom array?
View 4 RepliesI am trying to create the following program Store in a 1d array a set of 5 place names and in a 2d array the distances between the places. Ensure that the order of the places is the same in both arrays. When the names are places are input the distance between them is displayed. If they are not both in the table a suitable message is displayed
Dim town(1 To 5) As String
Dim Dist(1 To 5, 1 To 5) As Integer
Dim First As Integer
[CODE]......................
I think the best way forward is pass a parameter to the function findnumber.