How do I programatically retrieve and update data within an .mdf database within my solution

Hi All.

Am hoping you can help out a beginner here. I am using VS 2008 express, with C#.net.

I have created a DB via the IDE and it is connected to a set of field on my form. I want to be able to update the data within the database, and selected to update the form programatically...ie based on events within the program.

I have a beginners book that shows some very basic DB stuff, but nothing programatically...ie using update set = where = etc.

Will I need to create a new DB class that takes care of all DB interaction, even though the DB is not remote, ie I am automatically connected via the solution.

I hope this makes sense and you can push me in the right direction.

Many Thanks
Gary

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
Look at the Data Walkthroughs. Do not do them in the order that are shown; the order they are shown seems random. The beginner stuff is not at the beginning. Do the walkthroughs that look useful to you.

Note that there are things called TableAdapters. They are very useful and they get created for you by the IDE. Unfortunately they are not documented very well, but other wise the IDE will do very much for you. You need to get more books; the thing you need to look for is one that describes TableAdapters as well as many other database things, including business layers and business objects.
Kirtan Patel16y ago
Friend,

Creating Separate Class for Performing DB operation is called BLL (Business Logic Layer) thats good thing if you do it :)

but its not necessary if you have very small application.

if my answer helps you then check "do you like this answer" check box :)

and for updating database you can do code like below

private void button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection("Connection String Here");

            con.Open();

            SqlCommand comm = new SqlCommand("update tablename set field1=value where id=1", con);

            comm.ExecuteNonQuery();

            con.Close();

        }
Jeff Farr16y ago
So are you looking just for the interface to update a DB?

Create your command with variables
tSql = "SELECT statement FROM Where ....."

create your connections, command and reader then do an execute:
sqlConn.Open();
reader.Close();
mc = new SqlCommand(tSql, sqlConn);
reader = mc.ExecuteReader();

There is another option to use LINQ, but I perfer to use the good old fashioned way.
Gary17y ago
Bump.....

Sorry guys, but I am really interested to hear your opinions on this.