Database Management C#

Question

1.00/5 (1 vote)

See more:

Hi!

I create a database table following this video www.youtube.com/watch?v=3w2JkLcp-UA&feature=related

I want to add the cells and return the result in a textbox with a button!

Is this possible?

Help plz!!

Thnx!

Posted 22-Mar-12 16:13pm

lalaou

Updated 22-Mar-12 16:23pm

RaisKazi

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 22-Mar-12 22:42pm

How can you imagine adding a cell to a table? :-)
--SA

3 solutions

Solution 1

Yes. It is possible. Need help with anything else?

Posted 22-Mar-12 16:38pm

Wes Aday

Comments

lalaou 22-Mar-12 22:42pm

Yes.need help to do it!!sry but i am totally beginner in C#!

[no name] 22-Mar-12 22:49pm

Help to do what exactly? What code have you written to accomplish what you want to do? Do you even know what it is that you want to do? Do you get errors in your code? What have you search for?

I take it from the minimal information that you provided that you want to query information from your database and display the results in a textbox?

1 connect to the database.
2 query the information that you want to display.
3 textbox.text = whatever you want to display.

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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2012-03-22T16:41:00

Databases of database tables do not have "cells" you can add. They have "record" or "rows" which you can add or remove. The notion of "cell" belong to the domain of UI controls. It can be an object of a grid, a (data) grid view, a list view (with) columns which (more or less loosely) used to represent database tables obtained as a result of queries.

[EDIT]

Basically, you need to use ADO.NET. For starters, I highly recommend this CodeProject article:
Using ADO.NET for beginners[^].

Another article on Insert/Update/Delete with ADO.NET:
Simple ADO.NET Database Read, Insert, Update and Delete using C#.[^].

I hope it will help you to get started.

—SA

ProEnggSoft · Accepted Answer · 2012-03-22T17:03:00

The video link given in your question shows each record of the database in a detail view. As I understand from your question you want to display all the records from database like in excel spreadsheet, and able to edit the data in individual cells. If this is the case then you can use DataGridView control for windows forms
An example is given here
http://www.dotnetperls.com/datagridview-tutorial[^]
http://www.youtube.com/watch?v=4VNE0OuLbgo[^]
http://www.youtube.com/watch?v=FYD3892SBQw[^]
Help regarding the DataGridView control can be found here
http://msdn.microsoft.com/en-us/library/k39d6s23.aspx[^]

Database Management C#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0