Add 3 fields(editable)which user can update del and save all data in database

Question

1.00/5 (1 vote)

See more:

i need help in displaying folder contents in gridview in which data will NOT be constant.after displaying contents add 3 fields sequence,format,delay to the same grid which will be editable & user can insert update delete and save all this data in database.

problem is not able to save data from user input for sequence & delay and everything must be displayed in one gridview no buttons,lables,textbox nothing hence on which event what should be done and how to save user input data?

What I have tried:

Here is my code for displaying folder contents:

C#

DataTable table = new DataTable();
table.Columns.Add("File Name");
table.Columns.Add("Sequence");
table.Columns.Add("Delay");

for (int i = 0; i < files.Length; i++) {
    FileInfo file = new FileInfo(files[i]);
    table.Rows.Add(file.Name);
}
dataGridView1.DataSource = table;

Posted 1-Feb-17 22:53pm

NazneenSayed

Updated 2-Feb-17 1:46am

CHill60

v3

Add a Solution

Comments

Richard MacCutchan 2-Feb-17 5:10am

What is the problem?

NazneenSayed 2-Feb-17 7:02am

not able to save data from user input for sequence & delay and everything must be displayed in one gridview no buttons,lables,textbox nothing hence on which event what should be done and how to save user input data?

CHill60 2-Feb-17 7:07am

What have you tried already to do all of that?

NazneenSayed 2-Feb-17 7:23am

i tried creating a function and through that update and delete but now as there is no primary key and everything must be at runtime after displaying data from a particular folder i am literally stuck.

Richard MacCutchan 2-Feb-17 7:45am

So what aspects of managing a database do you have a problem with?

NazneenSayed 2-Feb-17 7:49am

after i display contents from folder two fields are vacant user inputs data how should i save it from grid which event what should be done and as there is no primary key how to delete update data without unique id ? i even tried adding a field as primary key code was up and running but now things changed and this runtime thing i am not able to save data into database.

Richard MacCutchan 2-Feb-17 7:52am

You need to look at the DataGridView class to decide which events you want to use to take action. You also need to look at your database schema to see how the data should be saved. This is not a Quick Answers problem, more something you need to research and discuss with your colleagues and/or manager.

NazneenSayed 2-Feb-17 7:57am

actually the project has many modules of import,exportexcel,zip etc i have accomplished everything except this runtime user input of data and saving it to the database.so i researched alot saw many threads and posts but nothing worked for me so far so i thought to give this a try as just saving data into database is remaining.

Richard MacCutchan 2-Feb-17 8:00am

There are many articles and tutorials available that explain the details of managing databases .

#realJSOP 2-Feb-17 7:25am

Are you sure your user name should include the word "xpert"?

NazneenSayed 2-Feb-17 7:29am

its company's id which i am using. i am just a novice john changed successfully anyway.

1 solution

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)

CHill60 · Answer 1 · 2017-02-02T01:45:00

From the comments it would appear that you are not allowed another control for the User to decide when to save the data from the dataGridView.

This leaves you with only a few choices of when you can update the database.

I suggest doing the initial inserts/updates when you populate the datagridview. Any user edits could be done in the RowValidated event (or at a push the CellValidated event.

Note this is validated not validating

I don't understand your comment about primary key and there is insufficient information in the question to help you further. Do come back if you run into problems with the insert/update code but you will have to use the Improve question link to share that code.