DataGrid Select,Delete and Update Operation

Question

1.00/5 (2 votes)

See more:

hi! First of all I need know how Can ı do select delete and update operation on Datagrid shortcut.

I fill data like this

C#

sql_cmd = sqLiteConnection1.CreateCommand();
            string CommandText = "Select * From PLU";
            DA = new SQLiteDataAdapter(CommandText, sqLiteConnection1);
            DS4.Reset();
            DA.Fill(DS4);
            DT = DS4.Tables[0];
            dataGridView4.DataSource = DT;
            sqLiteConnection1.Close();

DA:DataAdapter, DS4:DataSet, DT:DataTable

Can anybody help me?

Posted 27-Mar-13 4:09am

OsmanAydogan

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Mar-13 10:16am

How about just reading the MDSN documentation on this control?
—SA

OsmanAydogan 27-Mar-13 10:52am

What MSDN Documentation?

Sergey Alexandrovich Kryukov 27-Mar-13 10:56am

Did you ever pressed F1 for help? :-)
—SA

OsmanAydogan 27-Mar-13 11:01am

Come on!:D

Sergey Alexandrovich Kryukov 27-Mar-13 11:08am

OK, your English is good enough :-)
Than you know what is MSDN documentation, right. Why not using it?
—SA

OsmanAydogan 27-Mar-13 11:13am

Ok Ok ı'll try it but :D

Sergey Alexandrovich Kryukov 27-Mar-13 11:16am

Great. Come close to the solution and please ask more specific question in case you are stuck.
Good luck.
—SA

OsmanAydogan 27-Mar-13 11:35am

Ok Sergey but I have a problem?
exactly I dont know what is my problem?
What should ı say? :S

Sergey Alexandrovich Kryukov 27-Mar-13 11:48am

You need to formulate it the way anyone could be able to find end. Use the debugger to see what's going on.
If you can show the code, is should be comprehensive and build. So make a very short code focusing on only on problem. Explain what it does and what is should do but fail. Something like that.
—SA

OsmanAydogan 27-Mar-13 12:55pm

ok

[no name] 27-Mar-13 10:31am

What is a "Datagrid shortcut"?

OsmanAydogan 27-Mar-13 10:52am

Datagrid! Datagrid!
what is the datagrid shortcut? hmm its wrong sorry! I dont know very well english.

Sergey Alexandrovich Kryukov 27-Mar-13 10:57am

It's OK. You still can read the above question. First of all, provide fully qualified type name for "DataGrid", tag your UI library or application type.
—SA

[no name] 27-Mar-13 11:14am

Besides that... you do not do CRUD operations on the datagrid. You would do your CRUD operations on your database. Just like you are doing with this SELECT on your SQL Lite database.

OsmanAydogan 27-Mar-13 11:18am

CRUD Operation?

Maciej Los 27-Mar-13 15:05pm

DataGrid is WinForm or Web control? It's very important to define it.

OsmanAydogan 28-Mar-13 3:59am

WinForm

2 solutions

Solution 2

Your question is not well-formed and it's hard to answer it...

Quote:
The DataGridView control[^] provides a powerful and flexible way to display data in a tabular format. You can use the DataGridView control to show read-only views of a small amount of data, or you can scale it to show editable views of very large sets of data.

You can extend the DataGridView control in a number of ways to build custom behaviors into your applications. For example, you can programmatically specify your own sorting algorithms, and you can create your own types of cells. You can easily customize the appearance of the DataGridView control by choosing among several properties. Many types of data stores can be used as a data source, or the DataGridView control can operate with no data source bound to it.

More about: DataGridView class[^]
DataEntry in the DatagridView control[^]

So, you can't "select delete and update operation on Datagrid shortcut" - whatever it means.

To manipulate data, you need to use ADO.NET[^].

Quote:
ADO.NET separates data access from data manipulation into discrete components that can be used separately or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results.

More about:
Overview of ADO.NET[^]
Writing Common Code for .NET Framework...[^]
ADO.NET Sample Application[^]

Please, read these articles, then ask a question again (if any).

Posted 27-Mar-13 22:28pm

Maciej Los

Add a Solution

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)

YAIR-I · Accepted Answer · 2013-03-27T07:56:00

Hi,

First I want to say that the better way to do what you need is with the dataset (XSD) object.
You can add one threw the add -> new item... and then chose dataset.
In the past I did it like you do now but it is much easier to manage the tables and their boundings (datagrid, combobox, etc') with the dataset.

Second the code that you look for is this:

SQL

SqlCommandBuilder b = new SqlCommandBuilder(_sdataadapter);
_sdataadapter.Update(_sdatatable);

After you do all the things you need (add, update , delete) run this and it will update your data base.

usually it is preferred to do those operation separately it works fine together,