2
Contributors
4
Replies
5
Views
10 Years
Discussion Span
Last Post by Jx_Man
0

first you have make a module to connected vb.net with sqlserver.

you can add this code in module :

Imports System.Data
Imports System.Data.SqlClient

Module ModuleName
Public conn As SqlConnection

Public Function GetConnect()

conn = New SqlConnection("server = ServerName;database = DatabaseName;Trusted_Connection = yes")

Return conn
End Function
End Module

you can changes ModuleName,ServerName n DatabaseName with your own.

after you built a module you can call that modul in your form code.
ex :
Dim conn As SqlConnection
conn = GetConnect ()
you will use Conn to open connection (conn.open) and close connection (conn.Close).

0

I have made project with vb access. How i will make report of vb. Plz help me .

Thanks Nazrul

0

hi,
you mean that u want to make report using access as your database or you make report direct from access and use vb sintax.

actually you must using crystal report to make reporting.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.