Click here to Skip to main content
15,912,329 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: subtracting decimal values in textboxes Pin
BORN...again!14-Sep-05 21:18
BORN...again!14-Sep-05 21:18 
QuestionCom ports Pin
Anonymous14-Sep-05 9:39
Anonymous14-Sep-05 9:39 
AnswerRe: Com ports Pin
Steve Pullan14-Sep-05 14:31
Steve Pullan14-Sep-05 14:31 
QuestionDataGrid Help Pin
Killian8514-Sep-05 9:32
Killian8514-Sep-05 9:32 
AnswerRe: DataGrid Help Pin
shoaibnawaz14-Sep-05 20:58
shoaibnawaz14-Sep-05 20:58 
AnswerRe: DataGrid Help Pin
dptalt16-Sep-05 2:43
dptalt16-Sep-05 2:43 
AnswerRe: DataGrid Help Pin
Gulfraz Khan16-Sep-05 7:24
Gulfraz Khan16-Sep-05 7:24 
Questionspecific cell in dataset Pin
PAEC14-Sep-05 8:30
PAEC14-Sep-05 8:30 
I have a dataset that was filled with 15 rows of 7 columns from an SQL database. The desired row in the dataset is selected from a dropdownlist combobox. How do I select the different columns within the row? More specific, if the combobox selection is index 2, how do you access the value of App from the dataset?

Dataset Layout:
DID Dist Num App HR Sec SIS

My code so far:
Dim myCMD As OleDbCommand = New OleDbCommand
Dim myAdapter As OleDbDataAdapter = New OleDbDataAdapter
Dim dsDistrict As DataSet = New DataSet
Dim objDistrict As DataView
Dim intDistrictIndex As Integer
Dim MZKApp As String
Dim MZKHR As String
Dim MZKSec As String
Dim MZKSIS As String

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
myConn.ConnectionString = "Provider=" & …
myConn.Open()
myCMD.CommandText = "SELECT * FROM GTWDistricts ORDER BY Num"
myCMD.Connection = myConn
myAdapter.SelectCommand = myCMD
dsDistrict.Clear()
myAdapter.Fill(dsDistrict, "GTWDistricts")
cbDistrict.DataBindings.Clear()
objDistrict = New DataView(dsDistrict.Tables("GTWDistricts"))
cbDistrict.DataBindings.Add("text", objDistrict, "Dist")
cbDistrict.DataSource = objDistrict
cbDistrict.ValueMember = "DID"
cbDistrict.DisplayMember = "Dist"
cbDistrict.SelectedIndex = 0
SetDBNames()
myConn.Close()

Private Sub SetDBNames()
MZKApp =
MZKHRFin =
MZKSecur =
MZKSIS =
End Sub
Confused | :confused:
QuestionRequest for help Pin
gbaii14-Sep-05 7:16
gbaii14-Sep-05 7:16 
AnswerRe: Request for help Pin
Christian Graus14-Sep-05 11:33
protectorChristian Graus14-Sep-05 11:33 
AnswerRe: Request for help Pin
Gulfraz Khan16-Sep-05 7:29
Gulfraz Khan16-Sep-05 7:29 
AnswerRe: Request for help Pin
gbaii16-Sep-05 7:31
gbaii16-Sep-05 7:31 
QuestionFrozen Window Pin
johnjsm14-Sep-05 4:12
johnjsm14-Sep-05 4:12 
AnswerRe: Frozen Window Pin
Dave Kreskowiak14-Sep-05 4:38
mveDave Kreskowiak14-Sep-05 4:38 
QuestionConnection String Pin
kenexcelon14-Sep-05 4:06
kenexcelon14-Sep-05 4:06 
AnswerRe: Connection String Pin
shoaibnawaz15-Sep-05 20:05
shoaibnawaz15-Sep-05 20:05 
QuestionThe underlying connection was closed: The remote name could not be resolved. Pin
LeeOvEngland14-Sep-05 3:57
LeeOvEngland14-Sep-05 3:57 
QuestionSQL Restore and Backup Pin
kenexcelon14-Sep-05 3:48
kenexcelon14-Sep-05 3:48 
AnswerRe: SQL Restore and Backup Pin
Dave Kreskowiak14-Sep-05 4:27
mveDave Kreskowiak14-Sep-05 4:27 
AnswerRe: SQL Restore and Backup Pin
No-e14-Sep-05 4:32
No-e14-Sep-05 4:32 
AnswerRe: SQL Restore and Backup Pin
| Muhammad Waqas Butt |14-Sep-05 23:49
professional| Muhammad Waqas Butt |14-Sep-05 23:49 
GeneralRe: SQL Restore and Backup Pin
kenexcelon15-Sep-05 3:37
kenexcelon15-Sep-05 3:37 
QuestionCrystal Report Viewer Border Color Change Pin
prathiba_naresh14-Sep-05 3:42
prathiba_naresh14-Sep-05 3:42 
QuestionHow do set another folder than \bin for my assemblies when "Local Copy"... Pin
MaWeRic14-Sep-05 1:27
MaWeRic14-Sep-05 1:27 
QuestionDataAdapter.Update Pin
Adnan Yousuf14-Sep-05 0:09
Adnan Yousuf14-Sep-05 0:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.