Expiration Time out VB.Net

88 Views Asked by At

I'm turning an SQL Request in my application which is very big and need a lot of traitement. When I execute the request in SQL server, it takes time, but I have the result, but when I execute it in my application, after many seconds, it gives me an error of Time out Expiration.

Here is my VB.Net Button:

Private Sub Button6_Click(sender As Object, e As EventArgs) Handles Button6.Click
    Dim str As String = "Data Source=----;Initial Catalog=----;Persist Security Info=True;User ID=---;Password=---"
    Dim con As New SqlConnection(str)
    Dim com As String = " ma Requête"
    Dim Adpt As New SqlDataAdapter(com, con)
    Dim ds As New DataSet()
    Adpt.Fill(ds, "Organisation")
    DataGridView1.DataSource = ds.Tables(0)
End Sub

Can anyone help?

0

There are 0 best solutions below