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

Question

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 <table> set <column> = <value> where <column> = <value> 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

Sam Hobbs · Answer

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 Patel · Answer

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 Farr · Answer

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.

Gary · Answer

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