How do I Insert, Update delete using datagridview that is not bound to a data table?

Question

1.00/5 (3 votes)

See more:

VB

i have tried using datasource method but gives me login failed message.

Posted 1-Sep-14 20:24pm

Aiman Ali

Add a Solution

Comments

Sergey Alexandrovich Kryukov 2-Sep-14 2:35am

Datasource works perfectly, as well as insert, update and other operations on unbound DataGridView. If you screwed up something, it does not mean that we can know how, from your post. Your post is totally not informative. This is the same as asking "I cannot start my car's engine. How to fix it?"
—SA

Thanks7872 2-Sep-14 2:39am

In addition to that, i would say this is not the correct use of DataGridView at all.

Sergey Alexandrovich Kryukov 2-Sep-14 2:43am

I would not be so sure. We just know nothing about OP's use. (And if, by any chance, you think that unbound use is wrong, I can show you enough cases when this is the only reasonable way to use DataGridView. :-)
—SA

Thanks7872 2-Sep-14 2:45am

I agree with you, but it should be the last option when nothing works.

Sergey Alexandrovich Kryukov 2-Sep-14 2:51am

No, no. There are just very different things, when there is no a database of other standard-looking data source, nothing. Of database model is not relational. I have one such project, where database schema is based on Meta2Data and hence virtual metadata (schema) can be changed during runtime from the DataGridView (columns (part of schema, database attribute) dynamically added, removed). Yes, this is so exotic thing that not many can understand it, but this is a very interesting (and simple) concept which required unbound use.

Besides, you can use DataGridView just as a convenient container for input control (due to specific structure of input data). What would you bind there? And this is quite a legitimate example.

This is not because "nothing else works", but because unbound use is apparently right thing in first place.

Your statements are based on some quite standard setting of some pretty typical applications. Not all applications should be typical...

—SA

Aiman Ali 2-Sep-14 2:56am

plz let me how to use datagridview correctly

Aiman Ali 2-Sep-14 2:53am

I am new so take it easy. using datasource is pretty straightforward but if throws login failed even though i entered my sql authentication correctly. Plz help.

Sergey Alexandrovich Kryukov 2-Sep-14 11:18am

But that is unrelated to your question. You never asked about this problem. Can "taking it easy" help you? We can help only if you formulate the problem in adequate detail, ask proper question. You need it, not us.
—SA

Aiman Ali 5-Sep-14 2:25am

not helping

Sergey Alexandrovich Kryukov 5-Sep-14 9:42am

Exactly, not helping. The only one thing can help now: if you describe the problem precisely and ask some question(s).
Good luck,
—SA

Tino Fourie 24-Sep-14 15:06pm

Learn to store the rowID of your database row in your datagridview. This way you can directly access the row in your database when Updating or Deleting information in your DB without interrogating your database again.

For using DataSource, not sure how to because I don't use it in my applications.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)