locked
Get data from SQL Server Database in network... RRS feed

  • Question

  • Hi,
        I'm a newbie in Visual Basic and my second project is to get data from SQL Server Database connected in network. For example i want to get the data from October 1 to October 31. And also how to connect it in my database. Should i create an SQL query for this?..please help me..

    Best Regards,
    Nethan
    Wednesday, November 19, 2008 4:30 AM

Answers

  • Read the ADO.NET tutorial to know how to work with the SQL database in your application. You need to use Sqlconnection to setup the connection the remote SQL server. Then use the SqlCommand to fetch the data with the T-SQL statement. As far as I know, Jeff has some code sample about database access in his web site. Check its source code for your reference.


    Monday, November 24, 2008 7:22 AM
    Moderator