hello friend i solved your problem in few second
Your question is " how to connect sql server with vb.net"
Soln:- you add following cede in your project at the load_Form.
dim ds as new dataset
dim dr as datareader
dim cb as commandBuilder
dim da as dataadapter
public Form1_load (byval e as object system e as sender) form_load
sFileName = DownloadReport(sReportName, m_strReportDir)
provider= "sqloledb:user=sa:password:initial Catolog=<as your="" name="">,data sourse=<...........>"
intCounter = objReport.DataDefinition.ParameterFields.Count
If intCounter = 1 Then
If InStr(objReport.DataDefinition.ParameterFields(0).ParameterFieldName, ".", CompareMethod.Text) > 0 Then
intCounter = 0
I hope this coding is working properly........
don't send any Reply for thankyou............