C# + DB help me!

Question

arcticM

13 Years Ago

I need to make UI in C# that works with an SQL DB.
I thought piece of cake! I imported my DB files to the Visual Studio (add->existing item
->browes and add)
I dragged the tables to my Forms & there were automaticly buttons like New, Delete, Save, next record,previous record, etc...
so I was able to add rows and delete rows but then I realized I can't update rows!!
what am I supposed to do? write something in LINQ?? (I don't know linq) or write update query in SQL (how do I connect the query to the C# code)? I heard something about Dataset instead of LINQ but I can't figure out what that means either :(

ok so I'm totally lost. please help?

c#

Edited 13 Years Ago by arcticM because: n/a

4 Contributors
4 Replies
117 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by kvprajapati

CrappyCoder 22 Light Poster

13 Years Ago

If you dragged the table onto your form then a datasource will have been added automatically with the relevant INSERT, UPDATE and DELETE routines already created

http://www.asp.net/data-access/tutorials/querying-data-with-the-sqldatasource-control-vb

Edited 13 Years Ago by CrappyCoder because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

alc6379 120 Cookie... That's it Team Colleague · Answer 1 · 2010-12-10T03:03:59+00:00

Try checking out this tutorial:

http://msdn.microsoft.com/en-us/library/bb655884(VS.90).aspx

arcticM · Answer 2 · 2010-12-10T13:30:48+00:00

I did all that already. I have the connection..the question now is how to work with it, in terms of updating existing records in the DB using sql query..or something else..

kvprajapati 1,826 Posting Genius Team Colleague · Answer 3 · 2010-12-10T15:34:39+00:00

>what am I supposed to do?

What did you expect it to do? Purchase some good books and to start learning .net framework and C# language. Post the work you have done someone will help you with the places you are stuck.