Free asp.net web hosting Advertise with us

Login         Members       Shared Hosting   |                       Upgrade   |   Advertise   |   Tutorials   |  

Home » Resources » code to connect Sql Server Database



ASP.NETADO.NETWeb ServicesRemotingVisual Studio 2005
Error BankInterview QuestionsTips & TricksXMLHTML
Jscript/JavascriptIISWindowsGeneral
Submit Resource or code snippet   ... and get surprise gifts ASP.NET web hosting   Win Digital camera, ASP.NET Books, Free softwares!!

code to connect Sql Server Database

23 Feb, 2008
Author: Mohd.Shafiullah
Karim City College
Summary
commect Sql Server Database
.NET Classes used :
  • data.sqlclient
    		•



    Dim con As New Data.SqlClient.SqlConnection
           Dim com As New Data.SqlClient.SqlCommand
           Dim reader As Data.SqlClient.SqlDataReader
           Dim flag As Boolean
           con.ConnectionString = "connection string"
           con.Open()
           com.Connection = con
           com.CommandType = Data.CommandType.Text
           com.CommandText = "Select * from tablename"
           reader = com.ExecuteReader








    Feedbacks about this page from members:
    - No Feedbacks yet !! -
     
    Submit Feedback        View All Feedbacks




    Total members: 250846
    Average new registrations per day (in last 7 days): 10


    New Registration: Open

    Register Now




    Talk to Webmaster
    Tony John

    Facebook
    Google+
    Twitter


    Advertise   Privacy Policy   Terms of use   Contact Us

    SpiderWorks Technologies Pvt Ltd.
    All Rights Reserved.