aksay

Imports System.Data.OleDb Public Class salesorderdetails Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='tables.accdb'") Dim apdt As New OleDbDataAdapter("select * from Customer_details", con) Dim sod1 As New OleDbDataAdapter("select * from Sales_Order_Details", con) Dim apdt1 As New OleDbDataAdapter("select * from Sales_Order", con) Dim dt As New DataTable("Customer_details") Dim dt1 As New DataTable("Product_details") Dim dt2 …

i want to show records from other tables but this error occurs [CODE]Sub fillorderdetail() conn.Open() Dim adpt As New SqlDataAdapter("select * from orderdetail", conn) Dim ds As New DataSet adpt.Fill(ds, "orderdetail") DataGridView2.DataSource = ds.Tables("orderdetail") conn.Close() End Sub [/CODE]

i am working on a project for booking management system for photographers.. can anyone suggest some tables and content for the project....!