hey.. i will post the codes below. i used this code.. but when i connect to the database, my authorization box still comes out.. is there anyway i can solve it??



visual basic code:


Dim myConnection As SqlConnection
Dim myConnectString As String = "data source=(local);Integrated Security=true;database=test;User ID=sa;Password="
Dim myCommand As SqlCommand

Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
crv.DisplayGroupTree = False

Dim myconnection As New SqlConnection(myConnectString)

Dim daT1, daT2 As SqlDataAdapter
Dim DataSet1 As DataSet

myconnection.Open()

daT1 = New SqlDataAdapter("Select * from tbltest", myconnection)
DataSet1 = New DataSet
daT1.Fill(DataSet1, "tbltest")

Dim rpt As New test
rpt.SetDataSource(DataSet1)
crv.ReportSource = rpt

myconnection.Close()

End Sub