Member Avatar for kool.net

Hiiiii,
In my code i have to open mysql connection on all forms,
but i dnt wnt to do that,
actually i want at the time of log in I connect to datav=base & open connection then use this open connection on all forms
and when i logout then close this connection.
But if I do that then its not working on each forms because for execute queries it needs a open connection on own form.
So can anyone help me.....
Thanks in advance

  • 2 Contributors
  • 1 Reply
  • 169 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by MeSampath
Member Avatar for MeSampath

Hi,

Few thoughts;

1) Use DataSets.
2) Instead of execute non queries, try to have datatables.

Once all the data is loaded into the dataset, you can connect the database and push the data.

Good luck.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.