Connecting to datadase

Question

Hi all I want to ask if there is a wizard through the visual studio to build a form for inserting data in a database without building the SQL statments. I mean likeworking with Ms. Access forms and tables. I saw retrive data from database with right-click on the table name in the data connection. Regards...

wasim_frhat · Answer

Thanks This is really simple. Now I prepared DataAdapter with SQL query with two parameters. The Query is: Select * from tblX where (XDate between ? And ?); I built a date grid to bind it with the dataset of the dataAdapter. The two parameters come from two dateTimePickers controles. My problem is how to set to the adapter command the two perameters. Please help. Regards...

write2jey · Answer

Yes there's. For starters look for Server Exploerer from the View menu under VStudio.NET You'll see your DB Server there. This should give you a head start - if you need more info. do a search - this is really simple.