Imports System.Data.SqlClient Public Class Form1 Dim cnx As New SqlClient.SqlConnection("Server=.\SQLExpress;AttachDbFilename=C:\zaka\WindowsApplication1\WindowsApplication1\bd1.mdf;Database=bd1;Trusted_Connection=Yes;") Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim mastr As String = "select * from client" Dim cmd As New SqlClient.SqlCommand(mastr, cnx) Dim dr As SqlClient.SqlDataReader cnx.Open() cmd.CommandType = CommandType.Text dr = cmd.ExecuteReader Dim tbl As New DataTable tbl.Load(dr) DataGridView1.DataSource = tbl dr.Close() cnx.Close() End Sub End Class
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim sFolder As String = Application.ExecutablePath Dim lPos As Short = sFolder.LastIndexOf("") sFolder = sFolder.Substring(0, lPos) Dim cnx As New SqlClient.SqlConnection("Server=.\SQLExpress;" & _ "AttachDbFilename=" & sFolder & "\bd1.mdf;" & _ "Database=bd1;Trusted_Connection=Yes;")