Trying to populate a Dataagrid in Visual Basic Express (5), datagrid never populates Below is the code I am using, I get the recordset records and use RsCheck to validata there are 91 records, and can loop through data, but can not get the Recordset to bind with the datagrid.
[Code]...
I 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 asked this question before but didn't get any help. I am going to try to rephrase it a bit.
I have 5 input boxes; let's call them chck1, chck2, chck3, chck4, and chck5.Each input box has an associated checkbox, let's call them chckbox1, chckbox2, chckbox3, chckbox4, chckbox5. These are in a section called '*Step 3****
THe spec is that if you enter a number into one of the input boxes and check the associated checkbox in Step 3, the number gets populated into the corresponding box in step 4.
For instance, if i check a checkbox called chckbox1 and enter a number into chck1 in step3, that number gets populated into chck_amt in step 4 as long as the checkbox next to the inputbox in step3 is checked.
If a number is entered in any of the boxes in step 3 but the associated checkbox is not checked, the number doesn't get populated into the corresponding box in step4.The issue that I have so far is that if I check a box FIRST before entering a number, the corresponding box in step4 gets populated.
If, however, I enter a number into a box in step3 BEFORE checking the associated checkbox, that number does NOT get populated into the corresponding box in step4.Does anyone know how to ensure that whether a number is entered first in step3 or a box is checked first, as long a box is checked, that number needs to get populated into the corresponding box in step4.
[Code]...
I have tested the code for the DataSet and DataAdaptor and both work fine, and as test was able to place the MaxRows variable into one of the text boxes on my form so I know thats all ok. But I am now trying to use the function below to copy the 1st cell of each row into a combo box to populate the options and comes up with a null exception error but cant get my head around it.
[Code]...
i know how to do this in vb.net? to populate datagrid in vb.net?like in the vb6
View 1 RepliesI'm working on a project for personal use to make my life as an IT administrator a little bit easier. (Yea right)So basically, i'm creating a windows application with a form. On this form, it has a button, and a listview.When they click this button, it will load all "Windows XP run commands" into the list view. I also, have a on-click event to capture a click on certain lines in which it will automatically open said run command, or shortcut.
Here is an example of what I am working with so far. (It populates correctly, and the clicking event works like a charm. However, i'm just looking for a better way to clean this code up, or maybe, a better way to go about everything).Once done, I will populate this to the codebank if there isn't another similar thing out there.
On to the code:This is what I have for the form_load event
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
With ListView1
.View = View.Details 'Changes the view to "detailed" view
.LabelEdit = True 'Allow user to edit text
[code]....
I want to populate my asp:table with the contents from my SQL query. The page loads but with nothing in the table.
<%@ Page Title="stuff"Language="vb" AutoEventWireup="false" MasterPageFile="~/Site1.Master" CodeBehind="stuff.aspx.vb" Inherits="WebApplication1.WebForm1" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Net.Mail" %>
[Code] .....
I'm trying to populate a list box with XML so that when the user clicks on a list item it them populates with the next set of elements.
View 1 RepliesI'm trying to populate a combo box with some data from a xml document, but so far all i'm getting is this error message in the combo box[code]...
View 2 RepliesI have my mysql query selected fields (item_code, item_name, item quantity, item_selltype, item_selldetail) but some of these fields are variants.
Dim sqlConn As String = ("SELECT item_code, item_name, item_quantity, item_selltype, item_selldetail FROM qa_items")
Dim objDataAdapter As New MySqlDataAdapter(sqlConn, objConn)
[Code]....
I have created a sub that I am using over and over again. However, I am not able to get the values from the database. Screen shots and code attached. I need a second pair of eyes, can't seem to figure out what is wrong.
Form Load
vb
'Populate the drop down lists
PopulateDropDownListFromDB(cboReferrerType, "ReferrerType", "ReferrerName")
[Code]....
I select first value from a combobox1 but combobox2 was not populated corresponding to value selected from first one. Again I select same value now combobox was populated
View 2 Repliesthe information displays in the datarepeater correctly when loading the form, but i can not get new data to be displayed, (when saved to the database) no matter what i try. I think it is just beyond me.here is the code for which i import the initial data into the datarepeater:
Function test()
Dim bsStaff As New BindingSource
Dim dtStaff As New DataTable()
[code].....
In vb 6 I have on my form two listboxes I also have a dao data control called Data1 My database is in access and is called SampleDB.mdb
My code in VB 6 is as follows
Private Sub Form_Load()
Dim RI As String
Dim CurrentDB As String
[code].....
This simple code populates both List1 and List2?
I have a Report I created with Visual Studio's VB.Net ( I guess this makes my report embedded), which I can select a date range like starting and ending date but the drop-down listbox for the Name is empty and I have to type a name into it to work. I need to be able to choose the name because I won't know who is on the list.
View 1 RepliesI have a parent table called users which stores all the user info with a prime key field called ID. Now in the child table which has a seperate foreign key associated with the ID field in the parent table.
What I would like to do is be able to populate the foreign key once once the user uploads data into the child table with the user ID it has.
So far I have created the associated foreign key with ID field in the user table and also programmly through data-relation related the table but now sure on how to get the value from the relation.
The foreign key in the child table is called 'U_ID' as shown in the snipet velow.
[code]...
I don't have access to VB.NET right now so I can't test this value:Dim lst As New List(Of String)(cookieValue.Split("$"c))i got this from another question , but was wondering if A. The list will populate correctly and B. What does the c represent?
View 2 RepliesI am trying to populate a web from from a SQL table.
Public Class userDetails
Public address1 As String
Public address2 As String
Public city As String
[code].....
however, there are like 50 fields in the User db, and it seems like a lot of retyping...
I have created a connection string, and i am populating a dropdownlist with an ID from a sql database.I want to be able to click on a ID from the dropdownlist and run a query to populate a gridview with data. I have made the dropdownlist autopostback = Enabled. I am not getting an error.
Here is my code:
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlContracts.SelectedIndexChanged
Dim ds As New DataSet
[code]....
Since there doesn't seem to be any way to load old VB6 (ActiveReports) reports in .Net, I need to recreate dozens of reports in .Net. I'd like to do this in the least painful way possible.In VB6, the original authors simply did something like this for every report:
adoConn.ConnectionString = globalConnectionObject.ConnectionString
adoConn.Source = ReportFunctions.GetAllUsers()
GetAllUsers() returns an SQL string which selects a bunch of fields; those fields are then used in the report.Now:How can I do something similar in .Net (either using the built-in Crystal Reports, or the built-in "Microsoft Reporting Technology")?I can't get "Database Expert" to recognize globalConnectionObject (an ADODB.Connection object); and if I fill a dataset and do
report.SetDataSource(dataSet)
It tells me "The report has no tables."How do I populate a Crystal Reports report!? (the connection string/data location is not known at compile time)
I am new to Visual Basic and I'm trying to make a simple combo box that automatically populates from dataset. The table is from BaseMaterial with the column Material.
View 5 RepliesI am trying to display an ID which is a primary key in my table by selecting the corresponding name in my table. the names have been saved in a combo box and depending on the name selected the textbox will display that Id. the code I have so far only gets the names from sql server but doesnt show the corresponding id in the textbox. I have been searching and cant find anything similar to this.
this is the code for combobox. i placed it in the formload
[Code]...
I am trying to display an ID which is a primary key in my table by selecting the corresponding name in my table. the names have been saved in a combo box and depending on the name selected the textbox will display that Id. the code I have so far only gets the names from sql server but doesnt show the id in the textbox.
this is the code for combobox. i placed it in the formload
Public Sub RtnCmbVal()
Dim conn As SqlConnection
Dim str As String = "select ConsultantId, FullName from Derma_Consultants"
[Code].....
Dim RsCheck As Integer
Dim SelectedRecord As String
Dim StrSql As String
Dim Cn As New ADODB.Connection
[code]....
I have this form Customer which is designed with labels, textboxes and comboboxes. I want to populate them by way of databinding. How can i do this??
View 7 Repliescreating a 2-dimensional array (6,7) and populate it with some info located in a txt file.The txt file contains a list of customers and transactions, so the info is alphanumeric.
How should I organize the data in the txt file? What is the loop that I need to read the file and populate the array in an organized way?
I have a database containing the tables afdelinginfo,afdeling en personeel in afdelinginfo is information about departements stored like webdesign etc in afdeling is stored who is working in which departement and personeel stores the information on the persons I have a treeview which I'd like to populate the with the departements from afdelinginfo and in every departement node as child node the names of the persons working there. this is what I've tried:
#Region "personeel management Queries" Private Sub fillTree(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Declare variables and objects Dim strConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\bedrijf.accdb;Persist Security Info=True;Jet OLEDB:Database Password=miniemen"
[Code]...
I have a form with one combo box and text box and buttons. please refer the snapshot with i have attached.I have the following code:
My Stored Procedure for inserting the data:
/*
Name: usp_InsertBranchSetup
[code]......
I can understand since .ini files are pretty outdated, but I'll explain. I have a combo box, and inside the combobox I want it to display the names in a section of the .ini file. So say my .ini file contains the following:
[SECTION1]
Name = Billy
Lastname = Bob
Inside the combobox I wan't it to display the items "Name ", and "Lastname " only, not the section or the values.
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.