how to connect data base in vb.net

[nandhanvijay]

hi every

am trying to connect data base in vb.net but am unable to connect. As per the book am following that says to connect to data base go to tools menu connect to data base option. u will get data link property . But am not getting that . Am getting add connection from which i can able to select the data base like oracle or sql but not able to move further. When i click test button. your test connection is fail. am not able to get data adapter in the tool bod only then i can connect to data base. plz help in connecting data base.

[Plater]

Be sure to get the address or location of the sql database correctly
Sometimes MSSQL won't be sitting at "localhost" it will be "localhost/someotherword".

[parag100]

dont oflow wizard method.

try coding .it is worthwhile. ofllow any standard books on .NET or
MSDN help .

[klaydze]

what data base you are using? is it sql server or oledb or ms access? try this line of code in connecting your database.

USING SQL SERVER

dim con as new sqlconnection(Server="localhost"; Database="your dbase" User ID="sa"; pwd=")

USING OLEDB

dim con as new OLEDB.OLEDBCONNECTION("Provider=Microsoft.Jet.OLED B.4.0; Data Source="your dbase.mdb")
NOTE: make sure your database is in the bin folder of your program.

if there is a problem post it asap.