I am working on Visual Studio 2005, VB.At the back end,there is a table called "Marks" which has a column called "Subject". This column contains duplicate values.when the form loads,I want to display all the distinct values from the "Subject" column in the listbox.
View 2 RepliesI have a checked listbox that I've populated with a table that has three columns, Name, Address, Phone - and have done so successfully, but when i display the items in the listbox, i would like to retrieve additional values of the checked items other than the primary displayitem.[code]'we now have an array full of the Name column only, from our checked items 'i'd like to grab the other two as well (not to display in the listbox, but to use elsewhere as variables) 'and keep the checked listbox as a control in the above code, the fill_array variable is only populated with the items displayed in the checkedlistbox - my question is, can i keep the display item the same and pull the other two columns from the datasource, but only for the ones that make the checkeditems list?
View 5 RepliesI am using VB.NET (version 2008). I have two types of items populating in a listbox (checked listbox). For example: lets say one is type "A" and other is "Type B". Their names maybe same so if the user sees those items in listbox then he won;t be able to determine their type until he click on them and checks out its properties. I wanted that I add each item to listbox and colour them so that blue for example means type "A" is there and red means the other. So this way I will be able to know at a glance that how many item of what type is present. I guess it may not be possible to do that in a standard checkedlistbox. I am also using component factory's krypton controls which enhance the gui of an application. But I dunno if I can progress using that.
View 5 RepliesI have a listbox in my form that gets its values from a data table by data binding. My question is, when the data (row) is loaded it also selects the first line automatically. I do not want this because I want the listbox to select an item only when the user clicks on it. Otherwise, the iteme should ony be listed. Is there a way to manage this?
View 2 RepliesUsing VB.Net (Windows Application)In the form (called as FirstForm), i am using textbox, add-form Button, search button.When i click the add-form button, it will give the new form (same as FirstForm)Code for adding new form
Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
Dim SecondForm As New FirstForm
SecondForm.Show()
End Sub
Search Button Code
Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search.Click
If FirstForm.Focus = True Then
FirstForm.textbox1.Text = gridview1.Rows(crRow).Cells("code").Value.ToString().Trim()
[code]....
The above code is working, but If i am in second Form when i click the search button and selected the value, then the value is appearing in the FirstForm textbox, it is not appearing in the SecondForm textbox.If SecondForm is showing, the selected Value should appear in the SecondForm textbox not in the FirstForm Textbox.
I have to convert what i put into an input box, and somehow convert that into an array.
My project is to put in some random numbers from an inputbox into a listbox, then somehow converting those numbers into an array and find the median of those numbers. I'm able to do the math, and I'm sure its probably 2 or 3 lines of code
I am trying to populate a listbox using 65000 words in a text file for a hangman game, I have looked everywhere for information but cant seem to figure it out. I am using visual Basic 2010, I read something about IO.streamreader but could not figure it out. I created a txt file in my.resources with all the words i want to use to populate the listbox. I also saved a notepad version of the list in my debug folder for my project.
View 14 RepliesI'm working in VB 2008 Express.
I have an MS Access DB with a Table setup with the columns that I need.
I have it linked into a form, with the requisite BindingSource, TableAdapter, BindingNavigator, etc.
On the form, I also have several textboxes linked back to the table. I can populate the table via the + (add new) button in the BindingNavigator and then filling in the textboxes (and saving of course).
Is there a way that I can put a button on the form and populate the table automatically? I want to do this via a textbox to control the number of records added - that way, I can put in an 8 and have 8 blank records added to the table via this one click (and don't have to enter the default info in for the 8 records one at a time).
I've attempted to do this by calling the BindingNavigatorAddNewItem_Click subroutine, filling in the textboxes and then calling MapBindingNavigatorSaveItem_Click subroutine, but this does not work.
I need to populate values from a database(Access) in to vb.net form. after selecting a field from first form, the next form should display all the parameters used in the selected field from the data base. Also if do editing it should be updated in the database.
View 4 RepliesPrivate ReadOnly Property Values() As Decimal()
Get
Dim X As Integer = 1
[Code]....
{"An error occurred creating the form. See Exception.InnerException for details. The error is: At least one element in the source array could not be cast down to the destination array type."}
I am creating a glossary of words used in a study course. I would like to populate listbox with words entered into an imputbox.
View 8 RepliesI want to be able to populate LB3 with data from LB2 that does not exist in LB1. i.e. Fred is in LB2 but not in LB1 so on button click, Fred will appear in LB3. Here's what I have so far:Private Sub Button6_Click(sender As System.Object, e As System.EventArgs) Handles Button6.Click
[Code]...
I have a chechedlistbox on my form in a windows project, and want to populate the checkedlist box with data that I querry from a table in sql database. I have the code below for the Form load event, but the checkedlistbox is not populated.
[Code]...
I'm having some problems trying to input records into a relational database. The design is really simple but I'm running into a wall when it comes to having the foreign key from my child table autopopulate the primary key from the parent table. I've made the connections in Access and from what I understood, so long as I committed a transaction, the child table would populate the primary key from the parent table. This is not happening.
my question is: is there a method that would do what I'm looking for? or am I cornered into using @@IDENTITY and manually inserting the primary key into the child table?
I've tried using datasets and data adapters and created a datarelation within the dataset, but it is still not doing what I need. everything I've tried thus far has allowed me to insert records into multiple tables, but won't relate them because of the missing primary key in the child table.
I have 2 queries. One is populating a dataset that populates the dropdownlist and the other populates rest of the textboxes of a table row. i want to know how can i fill the entire dropdownlist and then make selectedvalue the value from the other query? e.g -
dataset query = select hobby from hobbies
other query - select name, dob, address, hobby from employee
now the table looks like this -
Name DOB Address Hobby
Sam 01/10/1988 111 main st Dropdownlist(n number of records)
Now in the dropdownlist I want all the hobbies populated with the hobby in the employee table to be the selected value.
I am trying to populate an Access table with data from a csv file. Here is my code
csvConn.Open()
Dim objAdapter As New OleDb.OleDbDataAdapter
Dim objCmdSelect As New OleDb.OleDbCommand("SELECT * FROM [reporting.csv]", csvConn)
[Code]....
The csv has 58 rows of data. The Access table I get is 58 rows of the same data as the first row of the csv. Am I not using parameters correctly?
am trying to populate an array like so:
Dim tmpArray As String = ""
Do Until x = Form1.arrayCal.Length
tmpArray = tmpArray & "," & x
[code].....
The idea is to click Button1, for it to open a browser window, then select 1 or more files from a directory and add them to ListBox1.Currently I'm using a very basic method that adds all files from a directory to my ListBox
Dim files() As String = IO.Directory.GetFiles("C:Users")
ListBox1.Items.Clear()
For Each file As String In files
[code].....
Before any jumps in and says, Why dont you just use a gridview, i have my reasons not to use it.I trying to dynamically create a table and then populate the cells via a linq object.
Good news, i can dynamically create the table and the cells.
Dim numrows As Integer = MyActions.Count()
Dim numcells As Integer = 5
[code].....
Here is the code I am playing around I am getting error populating the table cells into my listview. In my codes it is always add only in one cloumn in my lv.
Private Sub DumpTables()
Dim t, c As Integer ' Used to count tables and cells.
Dim IWebDocument As HTMLDocument
[Code]....
i have imported names from database table into combobox..i want to add item"all" above all names..how can i just add one single item in combobox after populating it form database tabel.
View 1 Repliesthis is the scenario. I have 1 aspx file with a table in it. it has a .aspx.vb file behind it. i want to populate this table from the .vb code. the table shall have many lines (rows) but they should be in this format. also the checkbox data, textbox data and dropdownlist data comes from database behind. how should i go about this?
View 2 Repliesis there any way to populate a listbox with totals data from previous pages? I'm working on a project for a class where the final form needs to have all the totals from the previous 3 pages (each page has one total each), in some capacity (so I do not necessarily need to use a listbox if there is an easier way to do this).One thing about the previous 3 forms, two are set up in radiobuttons and one is set up w/a checkbox format (but I will likely change the radiobuttons over to checkboxes as a later revision).I just can't figure out how to populate the listbox with info from a previous form, I keep thinking load events, but that doesn't take into account which options might be taken from previous forms.once the totals from the previous forms have been added to the final form I will need to add a 7% sales tax. I assume that something such an if then statement will take care of that though.Just wanted to run that everyone here at the forum just in case there is a better way to do that.
View 2 RepliesI have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?
View 1 RepliesI currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
I am using a string builder to set up an html table row by row so that it can be emailed. I currently gather my information from the database using a data reader and while dataReader.read, I use stringbuilder.Append to add each cell value to the table.The issue is that after about 200 rows, the html breaks and displays a cell value above the table in the email. I have tried changing the cell padding, but this was not successful.
View 2 RepliesI have a simple windows form that i would like to send the values of a few textboxes and comboboxes to an rdlc report after saving them (I have VS 2005 standard, so no crystal reports) - it's as follows:
-1 form
-3 textboxes - textbox1, textbox2, textbox3
-1 label - label1
-1 combobox - combobox1
-5 buttons - button1, button2, button3, button4, button 5
the textboxes are labeled length, width, height the combobox is labled unit of measure and contains two options - inches or centimetres the label has text of "your total cubic inches/centimetres is:" - followed by the unit of measure selected.the buttons are labeled save, calculate, print, print preview, and exit.Having said all of the above, the save, calculate and exit button code is easy enough and is good to go - it's print and print preview i'm stuck on the solution i'm after is to take those values and send them to an rdlc report that immediately prints (calls up the default printer dialogue) without preview or anything when the print button is clicked and also have a print preview function as well for when of course the print preview button is clicked.The report has already been created with the titles mentioned above..
I have bound a listbox with a dataTable Now i want to move the values from the listbox to another listbox.i have changed the selectionMode of the listbox to multiple.So they choose multiple items and they get moved over to the other listbox.
for each item in listbox1.selecteditems listbox2.items.add(item) next
i get system.data.datarowview in the listbox2 how could i replace that with the actual value ?
[code]If I wanted to get Part Name for multiple PartIDs from OrderDetails, how would I go about doing this? Would I use two DataTables? I'm confused as I cannot see an efficient way to do this. The only thing that I can think of is to create a DataTable with SQL:[code]and then maybe use a For loop to take each PartID, create another DataTable to find the PartName for that and then give this to a variable. There could be up to 10 PartIDs to search through and I don't want to have variables such as PartID1 PartID2 etc. [code]
View 2 RepliesI am very new to vb.net. I have been using vb6 for a while and I am making the leap.I have a list box that receives entries from another text box, there will be multiple entries, and only some will be applicable per record(its a report writing app).e.g. The user says ok I need this and that signer for this record.
lstSigners.Items.Add(strSigner + strSigner)
The entries that are needed are then selected via checkbox in the listbox. I now need to be able to capture which items the user selected.