I am trying to connecting Access DataBase to C#,
my data base hase 3 table.
in c# when I configure data adapter and run
Expand|Select|Wrap|Line Numbers
- SELECT account.*
- FROM account
Expand|Select|Wrap|Line Numbers
- SELECT account.ID, account.name, account.family, fish.bankname AS Expr2, fish.accountid, fish.fishid, bank.banknumber AS Expr3,
- bank.bankname AS Expr1, bank.bankid AS Expr4
- FROM ((account INNER JOIN
- fish ON account.ID = fish.accountid) INNER JOIN
- bank ON fish.bankname = bank.bankname)
Expand|Select|Wrap|Line Numbers
- "oleDbDataAdapter1.InsertCommand.CommandText = "INSERT INTO account(name,family) VALUES ('" + nameTextBox.Text + "','" + familyTextBox.Text + "')"; "
"Object reference not set to an instance of an object.".
I attach my program.
thanks