11-01-20, 03:01 AM
شغلت الكود وطلعتلي مشكلة
Dim da As SqlDataAdapter
Dim dt As DataTable
da = New SqlDataAdapter("Select Case nom_tiers From tiers INNER Join affaires ON affaires.id_aff=tiers.id_aff WHERE tiers.id_aff=@id", Connection)
dt = New DataTable
da.Fill(dt) رسالة خطا "System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'From'.'"
DataGridView2.DataSource = dt
ممكن الحل او اين المشكل
Dim da As SqlDataAdapter
Dim dt As DataTable
da = New SqlDataAdapter("Select Case nom_tiers From tiers INNER Join affaires ON affaires.id_aff=tiers.id_aff WHERE tiers.id_aff=@id", Connection)
dt = New DataTable
da.Fill(dt) رسالة خطا "System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'From'.'"
DataGridView2.DataSource = dt
ممكن الحل او اين المشكل