I'm using visual basic 2008 express I have 1 combobox which is populated from a coloum from my database, when I select a value from the combobox I wish to populate several textboxes with data from the row selected. I have created a dataset. How can I do this? Is there a tutorial I can read anywhere
View 2 RepliesI have a datagridveiw combo box with a few values in there. I am trying to capture what user clicked. I tried CellValueChanged, CellContentClicked etc. but nothing works.I want to store this value to a variable (important) and then shift the cursor to Column after user has selected value.
View 4 RepliesI am having a strang problem with button event handlers that I am creating at runtime.Actually if I set the form as startup form everything is working fine but when I set the main apllication form as startup form the events for buttons created at runtime are not firing.I am posting the code so that you can have a better look and see whts wrong?I have two classes under spotlight here "Class1" and "Grid"I am creating an instance of grid in class 1 and in a sub in grid I am creating buttons dynamically as follows and adding event handlers
For i As Integer = lIndex To uIndex
Dim btn As New Button
btn.Name = ds.Tables(tblName).Rows(i)(btnName).ToString
[code]....
I am adding items to a combobox through user entry and need to save them, so when I close the application down, they will reappear when again opened.
View 7 RepliesI'm using this line to populate my combobox with all files in my application path:
ComboBox1.Items.AddRange(IO.Directory.GetFiles(Application.StartupPath))This works fine, however it displays the path as well, and I only want to display the files with extension .txt
I'm trying to get a combobox to be automatically filled from a text file and have it editable by the user.
So far, when the program is running I can add new items and they appear in the text file and combobox but when I restart the program the combobox list is empty even though the text file has stuff in it.
Dim w As New IO.StreamWriter("z:url.list.txt")
Dim linecounter As Integer
For linecounter = 0 To ComboBox1.Items.Count - 1
[Code].....
I have seen something like the following in many software. Combo box populated and displayed with multiple columns (for example stock code, stock description). But now I am only able to populate with stock code. May I know how to achieve this? I know it can be done by calling a form (And I can do whatever coding in this form) out when clicking on the combo box. But I am looking for better solution, or is it possible to populate the whole datagrid into the combo box as source instead of only the data.
View 3 RepliesWhen my form loads, before the ComboBox has been populated and selected this Event (SelectedIndexChanged) gets triggered. How can I prevent the code insides this Event from Executing before form has completely loaded? I tried testing for .SelectedIndex but it returns 0.
View 3 RepliesIn a combobox populated by a DataTable I am having two issues!The SelectedIndex property will not set 1. Either by integer 2. Or by FindString
[code]...
this is my code -
[Code]....
this shall populate the dropdownlist data, but in the value i need it to pick up the "ID" field from the stored proc. the stored proc sends two parameters, ID and Name. so i populate name, but how do i populate the id in value like this -
[Code]....
I have a question on a datagrid object in vb.net 2008, that I what to be populated with certain values of a parameter from mssql database. The connection is made, the column header are loaded, but I what, when the form is loaded, to populate the datagrid only with certain values, doing a select commnad where id has a value given by me.What is the command to have this select done and display the values in the datagrid?
View 3 RepliesI have an Asp web form (language is VB) that is used to update records in a SQL database. The form is populated with the record with many textboxes as well as dropdownlists. I have a textbox that is populated with a date from the record and is displayed with the date and the time. I would like change the format to only display the date as "mm-dd-yyy". In the code behind the date field is called from the database and put into the textbox via:
"MyDate.Text = dt.Rows(0)("MyDate").ToString()".
I have a list view populated by a database. The columns for each record are First, Last and EMPID. When I look at the list view on the form at runtime, I can see some/all of the First name and then below that may be part of the Last and some ... periods and no EMPID. When I hover over the record, I can see the EMPID. Is there a way to have all of the information in the record visible in the list view?
View 4 RepliesI thought this would be an easy one but I can't think of a good way to do it.User submits a webform. Based on submitted information I build three classes and assign their properties from received data:
UserInfo userInfo = new UserInfo();
UserAddress userAddress = new UserAddress();
UserEmployer userEmployer = new UserEmployer();
Based on submitted information some classes end up being populated with properties and some do not.
What's the best way to check whether userInfo class, for example, ended up with properties assigned ? I don't want to save a particular object to the database if it doesn't have any real properties assigned and all of them are set to either null or "".
I only want to save the objects that ended up with at least one real property assigned.ps. using NHibernate to save data to db
I want create a datatable .In this datatable 2 coloums are percentage and marks I want to show the maximum percentage record display on first and simultaneosly another racord ?Thats why i take a dataview but dataview could not sort the datatable
exam.
Dim view As DataView = dt.DefaultView
view.Sort = "clm_percentage DESC"
dgvStudInfo.DataSource = view
After I have retrieved my data from my access database, I would like to insert text into one of the columns in a new row. Is this possible? Here's a snipit of my code I use to retrieve the data from access:
If con.State = ConnectionState.Closed Then con.Open()
sdr = cmd.ExecuteReader()
rtime = Now()
[Code]....
It's the rtotal_time value that I need to insert into a new row, in and cell, the datagrid.
I want display database value in datagridview 2 coloum ..how to may i bind the dataexmp:- Suppose in Database 100Dr,200Cr i want in datagrdview 1st coloum 100Dr & Second coloum 200Cr............
View 7 RepliesI want to calculate variance of a col in my datatable object. If i apply datatable.compute(Var(...)), i gives a negative result. Variance can't be negative. And it I just apply it to half of the data, it works fine. Does datatable.compute has a limited capacity?
View 7 RepliesI need to pull from an access database to populate a combobox. Then from there I need to have a second combo box populated depending on the selection in the first box. My thought of an example would be a website that is setup for selecting car make, modle,year...can that be done in VB?
View 1 RepliesI have a combo box and onload I want the combobox to be populated with data in a field from the database. However, when I execute I receive an empty combo box please could someone look what am doing wrong..
Private Sub populatecmbprojtype()
Dim cmd As New SqlCommand
Dim conn As SqlConnection = GetDbConnection()
[code]......
In the code below in the btnAmountEarnedClick event, the lblResults is not being populated.
Private Sub cboRecycleSelection_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboRecycleSelection.SelectedIndexChanged
[Code].....
I have several combo controls that need to be populated with a specific ID and name. I want the user to choose the name and have the ID in the background. Later when the data is exported from the database the specific ID's are exported and not the names.
I see that I can create the items in the combobox rather easily using their names. However, how can I associate the ID number for each of the items. Private Sub frmReceipts_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Add receipt types to combo box
cboReceipt.Items.Add("Monetary")
cboReceipt.Items.Add("Inkind")
cboReceipt.Items.Add("NSF")
End Sub
I thought it would be better to have a seperate table with the different receipt types and then somehow connect/link the contents of this new table to the combo box on this form. However, I am at a loss on how to do this.
[Code]...
I tried binding a DataGridView to a DataSet using the DataSource property but no data appeared in the DataGridView. I placed a DataGridView in an empty form, making no property changes except for the name. I did not create columns in the DataGridView. In the form's load event I placed the following code for loading a dataset named ds Executing in debug mode, I confirmed that there was data in that dataset. No column headings or data appeared in the DataGridView. What am I doing wrongly? There are 34 fields (columns) in the DataSet - maybe it exceeds the capacity of a DataGridView.
[Code]...
I have set up a search form so that when the user enters a character, a search occurs. I have some code behind to do the search. The code I am using is as follows:
Javascript:
<script type="text/javascript">
function TextBox_OnKeypress() {
document.getElementById("ctl00_MainForm_ibtnSearch").click();
[Code]......
i have some difficulty in displaying records from database to my combobox here is my code in the form_load
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As New SqlConnection
con.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:UserslitoDocumentsQMP_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
[code]....
I have here a combobx1 that has a value of Mr.A and Mr.B. want that if i choose from my combobox1 the selected value will go to my sql database.
View 2 RepliesI am looking to make a small application which uses 3 stages of combo boxes to filter results into subcatagories. Once the filtering is selected - I want the user to be presented with some advice, maybe even a small picture.I want the application to gather its information run from a database which will be network based via a mapped network drive on our network. There may only be 4 colums in that database. I want to be able to update the database as required.
View 3 RepliesI have here a combobox1 named choosename in form1. then i have a 10 textboxes named answers in form2.
I want that if i choose from the combobox1 the textboxes answers of form2 to will link to it. and it save into my sql database.
i'm fairly new to VB and am doing my second system through it. I am at the point where i want to link a combobox on my form to my access database so that when i click the dropdown arrow a list of surnames from the particular table in my access database appears.
[Code]...
First things first is this code remotely close to doing what i want it to do? I have to use an access database and i am familiar with this particular method of connecting to the database (sending any data to it is easy now). Secondly when the form opens (since the sub is called at load) i get the annoying old "object reference not set to an instance of an object" message.
I want to populate a combo box but not using a database
e.g. combobox displays
red
white
blue
But want I want is if a person chooses red I want to pass back the number 1 value to a backend database. I'm able to populate a combo box with the colours but not sure how i 'grab' the value to pass back
Dim colours as string[] = new string[] { "red", "white", "blue" }
m_cmbColours.Items.AddRange(colours)
What I want is this
value Colour
1 red
2 white
3 blue
Combobox just displays the colours and when chosen in the combo box I grab the value corresponding to colour chosen.