I'm making a questback in Windows forms (VB). I've succesfully setup the MySQL-database, and made connection with everything needed. I've also manage to populate a DataTable called tblAlt for the alternatives for the question.Then I try to populate each radiobutton with rows from the DataTable.Here's what I tried:
For Each row In tblAlt.Rows
If tblAlt.Rows.IndexOf(row) = 0 Thenof the table).
[code]....
1) My program has 3 groupboxes each consisting 3 radiobuttons. Based on what is checked in the first box, and then what the user chooses in the second box, I either need to hide the 3 box and choose one option, or keep it showing for the user to select an option. The hiding is because based on the previous choices, there is only one option for the user in the 3rd box, and so I don't want to confuse the user nor waste their time. So I when the user selects radiobutton1, I need to hide groupbox3 and select radiobutton2.This is what I have previously attempted and it didn't work.
[code]...
How can I select the radiobutton using code like shown above?2) My second question is regarding scanning strings. I have 2 output strings. They either print a device or a message saying why the user doesn't get an output. At the end of the code, I need to scan through the strings until I get to a space and then store that as a string. How does one go about doing this?
I populate a datatable from a database. The table is sorted by the first column.
Then I add some new rows to the table. After that I sort the table with pgds.Tables(0).DefaultView.Sort = "firstcolumnname"
The new added rows are listed after the originally ordered rows and not in the right order.
I am trying to build a DataTable to populate a DataGrid in VB.NET. The columns will be the username and then question from an exam. Each row will be the answers by user for each question.
So it would look something like this:
Username | What is your favorite color? | What is your favorite book?
-------------------------------------------------------------------------
Joe Blue The Hobbit
Fred Red The Road
[Code].....
That works great and gives me a table that has the needed columns, but I am stuck as to how and get each users answer and put it under the appropriate column.
I tried adding rows in the same loop, but that just adds all of the answers under the first column.
This is my GET Method to get my data from my DataTable
Private Function GetData() As PagedDataSource
' Declarations
Dim dt As New DataTable
[code].....
I've got two lists, ones a DataTable, the others an array list. I want to populate a CheckBoxList with the contents of the DataTable, and check any entries that exist in the array list:
Heres the DataTable that will populate the checkboxlist with the product column:
index product
1 Prod1
3 Prod2
5 Prod3
[Code]....
I'm trying to populate a List with a column of a DataTable in order to later convert it to a AutoCompleteStringCollection later. Is there a neater way to do it than the "good old" For Each?
Is there a way to use myDataTable.Rows.CopyTo for this task?
I 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[code]...
I want to modify this function to populate an array with each item in the database.
View 3 RepliesHow do i populate datatable with listview. . . .i have tried this code but it doesnt give the items that contained in listview to datatable. .
dt.Rows.Add(ListView1.Items("Quantity"), ListView1.Items("Description"), ListView1.Items("Price"), ListView1.Items("Total"))
Probably a very dumb question but I have a program whereby I create and populate an in memory datatable, which I then add to a data-set. I then run a couple of updates on the dataset and need to know how to then send these updates down into the in memory datatable :Here is a mock up of the code structure following the creation and population of the table :
[Code]...
There's a thread that i'd read wherein you reply regarding on shortcut on populating a listview with databatable or dataset, but i forgot it. How did you populate a listview with datatable or dataset with just one line.
In datagridview .DataSource how about in listview ?
I have a DataTable that has a hierarchyid data type column pulled from SQL Server. Is it possible to use the column to easily populate a treeview object in Visual Studio 2008?
View 7 RepliesPart 1 of what i want to do is on the Load Event of my form i want to look at an excel worksheet and populate a data table with the data found in the first two columns of the worksheet.
Essentially column 1 is Descriptions and column 2 is pricing
Part 2 of what i need to do is that when a user selects a description from the combo box it populates a text box with the appropriate pricing.
After doing some reading into this all i have seen is some threads on how to use Jet4.0 to link and grab the data but it is my understanding that Jet doesnt work with 64 bit OS.
Nonetheless I need to figure out a way to accomplish my end goal and make it as universal a solution as possible (ie. i do not want it to only run on 64 bit or 32 bit machines)
I've populated my DataTable will all the results from a SQL search. Upon a button click I want to populate a combobox with all the results where a condition is met. My DataTable as a column called UserID and I want to add all results where the UserID is equal to a set value (for example 12). I can do this to add all results and I guess I could add a if statement inside this to be If Entry.Tag = 12 Then but is there a better way?
[Code]...
I am trying to populat a treeview with nodes that are the values of a column in a datatable. I have managed to get the correct number of nodes but the text is not displayed next to the nodes, there is just a 3 shape but the other way round and with square corners shown.
The code is below. I would like to have these parent nodes populated on the form load and then (i think this is what i have read) to be quicker i would like to then load the childnodes once a parent node has been selected, as i don't want to load the whole database on form load or when the form is refreshed.
Here is the code with more dtails below:
[Code]...
I 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?
Handling multiple radiobuttons, only one should be selected in group
View 2 RepliesIm trying to use a CheckboxList Control to Store Yes and No and i noted there its a property on the control
"Selection Mode" One/MultiSelect/MultiSelect Extended
i set One expecting it to allow only one item being select at the same time but it doesnt work as expected, my question is there its another property to achieve this without having to code the event?.
i could do it by coding the event but, im tired of coding stuff that really isnt needed, since there are routines for that on VB.NET.
I want to group RadioButtons, but I don't want to use the visible control GroupBox. Is there something like the Java ButtonGroup in VB.NET?
View 3 RepliesI have yet another question. I have set up a series of radioButtons to create a menu of choice for a class project and am trying to set it up so that there would hypothetically be a discount on a purchase of two or more t-shirts, I have the coding set up so that if any one item is checked and the calculate button is clicked, then the dollar value or "total" will show up, however I am not able to set up a total for more that one item, it clears the previous "total" and sets up a new total for the most recent t-shirt value checked.
[Code]...
How do I get all the radiobuttons to be unchecked when program is run? Right now there is always one button that is checked. Using VB2008. [URL]
View 9 Repliesit's about a program mode, i want to hide all except one tabpages if i check the "standard"-radio button.
When i check "advanced" the tabpages should be visible again.
"standard" is radiobutton1, "advanced" is radiobutton 2
My assignment is to get the Get Monthly Income (Num1)Get Monthly Home Rent/Mortgage (Num2) Get Other Monthly Payments (alimony, child support, student loans) (Num3) Display Allowable Monthly Car Payment Display Maximum Car Value (interest rate based on credit) (answer) Public Class Form1
[Code]...
I have a panel on my GUI with radio buttons. When I run the code to determine which is the checked radio button from that panel, the code runs fine, but the panel disappears from the GUI after that. Here is the code I have to determine the checked radio button:
Dim rbName = (From r As RadioButton In Panel1.Controls.OfType(Of RadioButton)() Where r.Checked Select r.Name)
System.Console.WriteLine(rbName.First)
I have tried using:
Panel1.Visible = True
and also
Panel1.Show()
Panel1.Refresh()
but it doesn't show the panel again. I tried the same thing for individual radio buttons such as RadioButton1.Visible = True and it doesn't work.
How do you pass one radiobutton from form 2 to form 3? Iv tried:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Form2.rbtnPatterned.Checked = True Then
rbtnPatterned.Show()
End If
But that doesn't work. The radiobutton selected in form 1 doesn't appear in form 2....
Is it possible to use CheckBoxes to act as RadioButtons for Yes or No options?
View 6 RepliesIs there any way to use RadioButtons without any GroupBox or Panel or anything else?
View 39 RepliesI'm making a basic game in Visual Basic, and I have a form called "Level1". In Level1, you press a button, and it pops up a dialog (I made the dialog, which is just called "Dialog"). The dialog has an empty label because once you press a button in Level1, in the click event, the label text is set, along with the RadioButton text. The Label is a question such as "What is 10 x 10?" and the RadioButtons display possible answers. Below the RadioButtons, is a Submit button that the user clicks once a RadioButton is selected. The thing is, I only have one dialog box because the game has 5 levels and 9 buttons per level, so I don't want to make 45 separate dialog boxes. Is there a way I can make the Submit button click event in the click event of the first button in Level1?
Private Sub q1Btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles q1Btn.Click
Reset() 'Setting text for label and radiobuttons to ""
'Setting text for label and radiobuttons
[code]....
I wanted to have one choice enabled to the user(radio box) in two Groupboxes, is that possible? Is looping the why i should do it?
Public Class Form1
Inherits System.Windows.Forms.Form
Dim version As String
[code]....