How can i write code using ADO.Net for sql database connection like ADO. In ADO just 3 line u can access the database, but ADO.Net, more than 3 lines of coding we required. please let me the simplest method to access the database.

Drog the SqlConnection from Data Tab & drop it to ur form. then set the connection in vistual mode.

I think u can NOT find the easy way from this!

Always:),
Hovik Melkomian.

you can write the Global.asax.vb
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)Application.Contents("conn") = ("Data Source=IP;Initial Catalog=DataBaseName;uid=username;pwd=password")
  or
Application.Contents("conn") = ("Data Source=Your instance name;Initial Catalog=database name;Integrated security=true")
End Sub

and you can write forms button1.Click
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim con As New SqlClient.SqlConnection
        con = New SqlClient.SqlConnection(Application("conn"))
        con.Open()
    ......
    ......
        con.close()
end sub

Hi kulasekar,

There is no Detail where you want to access.
It will diff for windows based form and web based form.

You can do in Three ways.
1. Create a link in server explorer for the DataTable.
   And drag and drop the table you can get the records from dataset.
2. Open Data in design mode Drag the sqlDataAdaptor complete the Wizard with your Sql Quiery and Datatable.
   Right Click the DataAdaptor Create a Dataset and Use it.
3. in Runtime.
   Create A conn Obj set conn String 'conn
   Create a Command Obj set Sql Quiery. 'cmd
   Create a DataReader Obj set command Obj.ExcuteReader. 'dr
   Conn.Open
   While dr.Read
---------------
----------------
   End While
   Dr.Close
   Conn.Close

I hope this may help to you.

Thanks and Regards
Venki


Difficult can be done immediately. But Impossible will take some more time.

Oh My God! I don't think that connect to database make you can cry!

he he

L.V.L

You can connect the database by using a wizard. Using the wizard you have drag a SqlConnection from tool to the form and follow instructions.
In case you want to connect at runtime then you have to use –

        Dim myConnectString As String = "Provider…………"
        Dim myConnection As New SqlClient.SqlConnection(myConnectString)
        myConnection.Open()