Combobox Hell

javed khan

Hi All,

I have ap problem related to database and combobox..
i have a combo box which retrives the number of UserID from Database as
1
2
3
4
5
6
7
8
Now what i need to do is , if i select 3 from Combobox, then Userid1 ,Userid2, UserID3,
Should get selected and if 2 then Userid1 and userId2 Sholuld get selected from database...
Its very urgent...plz...help :(
Thanks in advance

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham16y ago
Accepted answer
We cant write stored procedures in MS Access.
But we can achieve it in two ways.
1. You can connect the ms access database in sql server, and then you can write your stored procedure.
2. If the above is not possible, just use the sql queries in command text and execute it. Hope you know about command text option in .net
Please mark it as accepted answer, if my posts is helpful
javed khan16y ago
Thanks...I will try to work out with it.....and then get back to u....bye....
Manikavelu Velayutham16y ago
Just go through this link. It has few sample code that will help you to work out the command text and also to create stored queries in ms access
http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1
http://www.java2s.com/Code/VBAPI/System.Data.Odbc/OleDbCommandCommandText.htm
javed khan16y ago
Can u explain a bit of it as i m new to .net.....
javed khan16y ago
Thankyou so much for ur co-orperation.
but the problem is that i m using ms-acess database.....is it possible to write store procedure for it in ms access..... if yes then how...is there any other method...
Thankyou.
Manikavelu Velayutham16y ago
Write your database retreival code in OnSelectedIndexChanged event of the combox box. You have to pass the number of userid as a parameter to a stored procedure, based on that retrieve the users from the database. Just handle it in your stored procedure.