i'm finishing up on my A2 Computing project now and am trying to make a few improvements. first of all, i want to fill a combo box with a list of variables from my database, so when they enter a new record on my vb form, they will have an option to choose from..
my attempt at coding:
Do
ComboBox.ObjectCollection.Equals(ds.Tables("TTDB").Rows(inc).Item("GroupID"))
inc = inc + 1
Loop Until inc = MaxRows
i have a combo box that i'm trying to fill from a database, managed to get it working through the wizard and the form view method but could do the next bit that way. I then started to try it the coded way, got the database linked but it only shows the first name in the database, how do i get it to show all the names in the database?
this is the code for the form
Imports System.Data.OleDb
Public Class NewTicket
Dim ds As New DataSet
[Code]....
I'm trying to get a combo box to fill itself from a MS access database field but I can't get it to work. I can get it to work at school but not at home. Also can't get a program that worked at school to work here so I'm guessing that somewhere there is something blocking the connection to the database. I've gone into the MS access trust center and looked at the settings there but I can't see anything that would be stopping it. I just need to find that setting (if it is indeed a setting) wherever it is and fix it so that I can access my database. I am not using visual basic from access I am accessing access through visual basic.
I can't get it to work with an ADO connection, either. Also when preview data via clicking smart arrow on the combo box then going to preview data I can see the data just fine. Also I just noticed I get two lines in my output after the file is run that say "A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.dll" I don't get these lines if I comment out all the code for the combo box.
I am trying to fill a combo box using a dataset and data adapt. I am struggling too work out how to do it. I thought it would have been easy but I was wrong. i can set the text to read the first line of the colomn but nothing else. I was wondering if anyone could help me out with what I have to do. I think I have to increment inc and add a line underneath but I don't know how to do that
comboMaps.Text = datSet.Tables("TheLastShot").Rows(inc).Item("Maps")
I have a dataGridView in my program that displays stuff .The invoice No column has a combo box what I wanna do is when the form loads the All the invoice No's which r in the DB should be loaded into the combo box When I select the Invoice No using the combo box the rest should fill
this is what I did --
In form load wrote a code to fill the combo it din work
I tried but the combo box didnt fill
[code]....
I'll start off with a brief explanation of my situation. I'm doing my A-Level coursework project at the moment and am having some difficulty trying to figure something out. My project is a VB.NET Program that connects to a Database to display/add/delete/update records. At the moment I am having trouble with one particular thing which must be solved before I can move on (and the deadline is fast approaching).
I have a combo box which contains a list of different item types (Which match up to the item types used in the database, but it is not filled from the database). When the user selects one of these options, the list box below must fill with all items of that type that are in the database.
Unfortunately I'm at home so I can't get access to my coding, but I can try to explain what I've tried. I've tried so many things after trawling though what seems like endless amounts of tutorials to find an answer.
One thing that is used in pretty much all of them is the SQL string to select the needed records;
"SELECT ItemName FROM Stock WHERE ItemType = Anime"
Now, this has been used many different ways. I think the way that I'm trying at the moment is to create a new data set that contains the records that are needed for the search. There is already a data set that contains the whole table that is needed for this particular form. I think my most recent attempt was trying to copy the relevant information from the original data set to the new one, but I can't get any coding that isn't incorrect.
I am trying to fill my datagridview but I got an error, I probably missed out something in my code. The dataset gets filled allright, only when it comes to the line:[code]
View 2 Repliesits possible to develop an app that can open firefox or ie and fill form and submit... for example vb logging into my gmail a/c without any manual input!
View 4 RepliesI have written a 'windows' app, that uses some Adobe 'forms' that I created using Adobe Pro 9.0 they are certificates of completion. I can open them, but I want to pre-fill the fields in the form before opening them. Such that, all the person can do, is to print the form with their name/date/other-info.which 'references' I need to add? which properties to set? etc.?
View 1 RepliesI'm new to this forum and was wondering if somebody could help me out on the visual basic 2008 webbrowser filling iFrames.Here is an example iFrame below
<TD class=controlbar><TEXTAREA style="WIDTH: 500px; DISPLAY: none; HEIGHT: 350px" dir=ltr id=vB_Editor_001_textarea tabIndex=1 rows=10 cols=60 name=message>
I use firebird server for 2 years and I used this code
[Code]...
i would like to know something more relating to parameters. i have always been adviced to use parameters but i am bit confused as to how to use parameters while filling a dataset like if i am using a oledbcommand i can always use paramters but how do i parameterise the following :
dgMastDet.DataSource = Nothing
myBindingPenBase = Nothing
txtCd.DataBindings.Clear()
[code]....
i am using the above code to filter a list in the dgv as a help dialog for the selection of a master.my prob. is the now xFilter is to be typed in a regional language. so it is bound to have an ' as a character at some point or the other and if that comes in the char. then it will b giving me an error.. so how do i use it as a parameter ?
For example:
test is a variable
test = 1
How do I make that if test = 1 that a listbox fills with the items: red, blue, green, yellow?
If test = 1 Then
listbox1....
I have an array that is dinamic (0f course). I want to create a structure that can then accept values from the array. I want to use a loop (For Next) or Do While, but i am not sure of the Dinamic declaring of the structure variable or new parts.
Structure T_Results
Dim PlayerName As String
Dim RD1 As Integer
[Code].....
I am currently using VB 2008 and there is a form I'm using which contains a listview control. I am dynamically filling the listview with groups and items. After I fill it up, it is supposed to look like this:
[CODE]...
Each item is specific for each group. The problem I have is that when I maximize the form to full size, and everything expands, the items change positions into something like this:
[CODE]...
How can I make the listview keep the items in the "row" view always, instead of the "column" view whether I maximize or not?
I am trying to click a button after filling out a form in vb.net 2008. I have the following code but I cannot seem to get it to work.
WebBrowser1.Document.All("username").InnerText = TextBox1.Text
WebBrowser1.Document.All("password").InnerText = TextBox2.Text
WebBrowser1.Document.GetElementById("submit_button").InvokeMember("submit")
I am trying to fill in a simple login form and click submit. I am able to copy the information into the username and password fields but cannot seem to get it to click submit within the code.
Here is the html code for the submit button below:
<div id="submit_button">
<button type="submit" value="Login Now!" onmouseover="this.style.backgroundPosition='bottom';" onmouseout="this.style.backgroundPosition='top';" onclick="return SetFocus();">Login Now!</button>
</div>
Why this isn't working I cannot seem to figure it out.
I am entering data in a dataGridView, I have a column named with 6 characters.The first 3 characters are always "HHH"When I enter in this cell, Is there any way to put automatically these 3 characters and start to write in the fourth one?
View 2 RepliesUsing VB2008 How can we fill the datagrid with information from a stored procedure and a sp variable.We have a dataset named: DBnamesDataSet, a source: ShownameBindingSource and a adapter: Show_nameTableAdapter.
Stored procedure:
alter PROCEDURE [dbo].[show_name]
@name varchar(50)
AS
[code]....
I need to read data from text file to datagrid. I have a datagrid with 3 columns: Column1, Column2, Column3. I have two columns in my text file, eache is separated by double space. I need to make so that column1 from text file goes to column1 into datagrid and colunm2 from text file goes to column3 into datagrid. Column2 in datagrid will be filled with values from OPC server. So i made a simple
Dim mSr As StreamReader = New StreamReader("C:VBpirm.txt")
Dim mLine As String = Nothing
Dim mArray() As String
[Code]...
I have a main form "Parent" and another "child" form. When I am filling a textbox in the child form the mouse pointer disappears. Then I hit the tab key to jump to a combobox. At this time when I move the mouse, the pointer doesn't come up until I click the mouse button. This is annoying and the user of my program doesn't like it. How can I keep the mouse pointer always on top. NOte: although the main form has the parent property as true, the other child form are not defined as child forms.
View 2 RepliesI got a problem I need to search by First Name OR Surname. So the user can enter one or the other or BOTH.
So here's what I got I set two primary keys to try and find the row but I'm gettin all sorts of problems, for example when I set FirstName & Surname as primary key which you need to do to use the find method i get an error as it expects two values..
Dim da As New SqlDataAdapter
Dim con As New SqlConnection("Data Source=UserSQLEXPRESS;Initial Catalog=StudentTeacherDB;Integrated Security=True")
[Code]....
Im trying to fill my DataGridView with data where the Column "RefID" is equal to the tbRefID.text that is on the same form but its not working my code is as follows.
Public Sub New(ByVal lviQ As ListViewItem)
InitializeComponent()
Me.tbRef.Text = lviQ.SubItems(0).Text
[code]....
and the code for the FillByRef is
SELECT RefId, QuTask, QuCost
FROM quote_tasks
WHERE (RefId = 'tbRef.text')
all it does is add the 3 column header to doesnt add any data?
I have a small 10px by 10px image, and I want to use VB.NET to find out if that image is (an exact) part of a larger image.I thought a method of doing this would be to lock the bits of the larger image into memory and then loop through each pixel in the image and for each pixel, I could take the 10px by 10px section which is down and to the right of that pixel.. and then compare it to my smaller image.
This is the code I have so far:
'Lockbits of larger image to memory
Dim bmp As New Bitmap(Image.FromFile(System.AppDomain.CurrentDomain.BaseDirectory() & "picture.bmp"))
Dim pxF As PixelFormat = PixelFormat.Format24bppRgb
[code]....
when I'm looping through the 10 by 10 section and I find the R G B bytes for each pixel, how do I store this in my rawImage array so I can convert it to a back bitmap and compare it with my original small 10by10 image?
i wanted to link options selected from Comb box A (general) to specific options in combo box B (specific). I want to pick a word in Combo box A that has specific words/phrases in Combo Box B show. But not all the words to show in the combo box B if they aren't associated with the Word picked in Combo Box A. Ex.When "Soda" is picked in A, only "Coke, Sprite, Fanta" should be visible in combo box b, not everything else.This is the code i used to make the boxes, but i don't know how to link them.
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' fills the combo boxes with values
Me.xGeneralComboBox.Items.Add("Soda")
Me.xGeneralComboBox.Items.Add("Juice")
[code]....
How to use a databound combo box to display one field in the drop down, and another as the combo box text on roll up? Using VS 2005... For example, I have a datatable that has 2 fields. One called "ShortDesc" and one called "LongDesc". I want to be able to see the "LongDesc" column values in the drop down on the combo box. When I make a selection, I want the text in the combo box to read the corresponding "ShortDesc" value.
[Code]...
I am getting an error when i try to populate some combo boxes with a value, the combo box has values in and the right amount the code is getting the right number.
the error msg is "Object reference not set to an instance of an object."
Combo box 2 is filled based on a selection made in combo box 1 and a listview is populated based on the selection made in combo box 2.When the LostFocus event completes in combo box 1, it hits the LostFocus event in Combo Box 2 but it shouldn't. How do I prevent this from happening or if I can't prevent it, how do I work around it? The following is the code used.
Private Sub cboCategory_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboCategory.LostFocus
[code].....
Heres the InnerException:{"Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."}Stack Trace:
" at MyNetworkStream.HandleOrRethrowException(Exception e) at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at
[code].....
I've got some code like the following. I want it so that when I chose an item in 'select 1' it changes the in the second combo box but I'm not sure of the best way to go about it. Does it have to be AJax or can it be done with just Javascript?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
[code].....
How do you make the autocomplete feature on combo box in VB behave in the same way as one in VBA?
the VBA properties are as follows:
MatchStyle = fmMatchEntryComplete
MatchRequired = True
The VB properties are quite different and i havent got a satisfactory combination. I need it to suggest items from the list as i type but insist on a match with the list. However on VB forms, unlike VBA forms it doesnt show the suggestion in the combo box itself, but in a box beneath.