Combobox Hell

Question

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

Manikavelu Velayutham · 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 khan · Answer

Thanks...I will try to work out with it.....and then get back to u....bye....

Manikavelu Velayutham · Answer

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 khan · Answer

Can u explain a bit of it as i m new to .net.....

javed khan · Answer

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 Velayutham · Answer

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.