connection from microsoft sql to visual basic 2005

[badrat]

Hi to all! i'm a newbie here, i've created a GUI in Visual Basic 2005 and i used MS SQL's query analyzer to create a database, is there any way for me to connect the GUI to my SQL database but my saved file is .sql? hmm,

[Phil Weber]

Yes, you can connect your GUI to your SQL database. I don't understand what you mean, however, by "my saved file is .sql." Can you be more specific about what you want to accomplish?

[Hack]

.sql is typically what the file extension is when a query from Query Analyser is saved as a text file. Is that what you are referring to badrat?

[Hack]

Also, are you familiar with the SQLConnection Class in VB.NET?

[badrat]

yah, it is what i'm exactly asking, so .sql is the text file or the query that i did in the query analyser, so means to say that where can you find the database? to link from the GUI? i'm using Visual Basic 2005.

[badrat]

Also, are you familiar with the SQLConnection Class in VB.NET?

i'm not too sure with using sqlconnection class in VB.NET

[Hack]

yah, it is what i'm exactly asking, so .sql is the text file or the query that i did in the query analyser, so means to say that where can you find the database? to link from the GUI? i'm using Visual Basic 2005.

Typically an SQL Server database is stored on a network file server or web server.

In order to access it your code has to programmatically connect to it. That is where the SQLConnection class comes in handy.

[Hack]

i'm not too sure with using sqlconnection class in VB.NET

Are you saying you do know what it is but you just don't know how to use it?

[badrat]

Are you saying you do know what it is but you just don't know how to use it?

yup, i'm so lost right now, i had my tables in my visual project but i don't know how to link the data over at my table or specifically in putting what codes at the tables source codes.