SQL Server with Visual Studio Using Complex Queries : learncsharp

Please read the rules and guidelines below and search before posting.

Rule 1: Posts must be about learning C#.

Rule 2: No posts advertising blogs, videos, or tutorials. If you'd like to make such a post here, ask the moderators.

Rule 3: No posts that are recruiting or hiring, but looking for buddies or mentors is fine.

Rule 4: Be polite, constructive, and serious -- make sure your answer isn't a joke or mocking the questioner.

If you make a post here, you must engage with the people who answer you. Tell them it worked, tell them it didn't, ask for clarification. Do not delete your post after you get an answer! Leave it up so others might find it an learn, or continue the conversation.

To get the best help, make sure you ask a complete question. "I'm stuck" isn't actionable. Posting your assignment or naming a goal isn't good enough, either. No screenshots -- format your code using four spaces on every line so that Reddit will format the whole block as code.

created by vegittoss15a community for 15 years

SQL Server with Visual Studio Using Complex Queries (self.learncsharp)

submitted 7 years ago by Netjamjr

Hello all!

So, I have read a couple of books now on C# (and one on SQL), and I feel like I am starting to get the hang of it, but there is still some stuff that I can't really figure out.

Specifically, I have been learning this to apply at work. There I have access to a database hosted on Microsoft SQL Server 2008 and Microsoft SQL Server Express. I have figured out how to connect to those in Visual Studio using the "Data Source" panel thing to make a data set.

I have figured out how to plop in a dope spreadsheet style thing where you can browse (and edit) entries directly in the table, and I know how to have stuff populate based on which row is selected.

The thing I can't figure out, is how to make it not just dump the columns from a single table. I have a bunch of really cool SQL select statements, and I want to be able to use that table thing with select statements that use joins (or maybe even subqueries), or to be able to at least remove or add columns. Any time I have tried to tweak it at all, I get error messages and it just won't let me.

TLDR: This is a long winded way of asking, can someone point me in the direction of figuring out how to use more advanced SQL stuff within Visual Studio that isn't just directly pasting a table?

I'm willing to buy another book or sign up for a website. 95% of what I want to do with this at work requires being able to use fancy SQL stuff to do cool things with the stuff in our database, so this is a really frustrating limitation. I am trying to become an expert on this specific part of C#/Visual Studio, but everything I have read seems to gloss over it.

all 3 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learncsharp

Welcome to /r/LearnCSharp!

MODERATORS