i have made a database in sql+. it has a database. there is a table project. its columns are p_id,p_name,p_manager.
i have inserted 5 rows in above table.
in d front end in vb6 i have a form . please help me with the code such that my p_id is a combobox. wen i select my p_id then the corresponding p_name and P_manager should be displayed in text box on the form. please help!
'Try this code
sql = "SELECT * FROM YOUR TABLE WHERE P_ID = " & YourTextBox & "
cmd = New oledb.oledbcommand(sql,con) 'cmd = command. con = connection
dr = cmd.executereader 'This would be your data reader
textboxPName = dr("p_name")
textboxPManager = dr("p_manager")
ok. if you want to put all the ID in the combobox.
put this into your Form Load Event.
sql = "SELECT p_id FROM YOURTABLE"
cmd = New Oledb.OledbCommand(sql,con)
dr = cmd.executereader
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...
Write a C program that should create a 10 element array of random integers (0 to 9). The program should total all of the numbers in the odd positions of the array and compare them with the total of the numbers in the even positions of the array and indicate ...