how to join 2 tables in a data set - C# Discussion Boards

First Prev Next

Re: Is there a method summary snippet?

Abhijit Jana18-Mar-09 18:39

Abhijit Jana

18-Mar-09 18:39

You can create your own custom code snippet in VS.
Creating and Using IntelliSense Code Snippets[^]

cheers,
Abhijit
CodeProject MVP

Shortcut keys and macros

12Code18-Mar-09 17:35

12Code

18-Mar-09 17:35

I'm using VS2008 to develop C# applications.

Where can i find all the shortcut key of VS2008?

Perhaps, the experience programmers can share with me the useful shortcut keys or macro which can improve coding productivity.

Kelvin

Re: Shortcut keys and macros

Abhijit Jana18-Mar-09 18:21

Abhijit Jana

18-Mar-09 18:21

8kelvin wrote:
I'm using VS2008 to develop C# applications.

Where can i find all the shortcut key of VS2008?

Here[^] is an good article from Code project.

cheers,
Abhijit
CodeProject MVP

Re: Shortcut keys and macros [modified]

12Code18-Mar-09 19:01

12Code

18-Mar-09 19:01

Very helpful tips, thanks Abhijit Jana. Thumbs Up | :thumbsup:

Kelvin

modified on Thursday, March 19, 2009 1:17 AM

Re: Shortcut keys and macros

Pankaj Nikam18-Mar-09 18:35

Pankaj Nikam

18-Mar-09 18:35

8kelvin wrote:
I'm using VS2008 to develop C# applications.

Where can i find all the shortcut key of VS2008?

Check this link Visual C# 2008 Keybinding Reference Poster[^]

Re: Shortcut keys and macros

12Code18-Mar-09 19:17

12Code

18-Mar-09 19:17

I got the 101 C# Samples from the redirect link too.
Thanks, Pankajkumar Nikam. Thumbs Up | :thumbsup:

Kelvin

Re: Shortcut keys and macros

Pankaj Nikam18-Mar-09 19:36

Pankaj Nikam

18-Mar-09 19:36

8kelvin wrote:
Thanks, Pankajkumar Nikam.Thumbs Up

You are welcome 8kelvin Smile | :)

Always Keep Smiling.
Yours Pankaj Nikam

how to join 2 tables in a data set

Nine_18-Mar-09 17:31

Nine_

18-Mar-09 17:31

Hi all
I have 2 tables in the same data set like this:

string sqlCus="select * from Customers";
string sqlOrder="select * from Orders";

SqlDataAdapter daCus=new SqlDataAdapter(sqlCus,conn);
SqlDataAdapter daOrder=new SqlDataAdapter(sqlOrder,conn);

DataSet ds=new DataSet();
daCus.Fill(ds,"Customers");
daOrder.Fill(ds,"Orders");

now I want to get the OrderID column in Orders table and ContactName (CustomerName) in the Customers table according to the CustomerID column in the Orders table then show both column in a DataGridView control, how to do that?

note: not use stored procedure and Linq

Re: how to join 2 tables in a data set

tech60318-Mar-09 19:06

tech603

18-Mar-09 19:06

You could do one query and join the tables on the query

string sql = "select ContactName, Orders.OrderID from Customers Left Outer Join Order ON CustomerID = Order.CustomerID";

The above should work, you may just have to change the column names to what you want. You could also add an Order by statement in the end of that if you wanted.

This link may help you in the future with joining tables in sql queries.

http://en.wikipedia.org/wiki/Join_(SQL)[^]

hope that helps you.

Matthew Vass
QA Analyst
mvass@hostmysite.com
http://www.hostmysite.com?utm_source=bb[^]

Re: how to join 2 tables in a data set

Nine_19-Mar-09 1:29

Nine_

19-Mar-09 1:29

Thank you for your answer, but what I wanted to know is how to join 2 tables in the same data set using data relation. I do know how to join 2 tables using sql's select command, but this one is not.
Could you please point me out for this?

Thanks

Re: how to join 2 tables in a data set

tech60319-Mar-09 3:06

tech603

19-Mar-09 3:06

I'm sorry the first answer did not help you, I'm guessing you have a reason to populate two separate datasets and then parse through them to get your info.

You may want to look at this article, it explains how to use select/sort things using your dataset and a datatable.

http://msdn.microsoft.com/en-us/library/system.data.datatable.select.aspx[^]

Also you will most likely have to do a dataset copy then dataset.add to add the columns to the copied dataset in order to get the results you want. Not sure if this is exactly what your looking for but hope this points you in the right direction.

Matthew Vass
QA Analyst
mvass@hostmysite.com
HostMySite.com

Windows Media Player control - suppress full screen

Christian Graus18-Mar-09 16:51

Christian Graus

18-Mar-09 16:51

If I double click on the windows media player control, it goes full screen. Any way to stop this behaviour ?

Christian Graus

Driven to the arms of OSX by Vista.

Re: Windows Media Player control - suppress full screen

ABitSmart18-Mar-09 18:05

ABitSmart

18-Mar-09 18:05

Tried this -> MSDN forum[^]?

Deploy N-Tier Application...

Illegal Operation18-Mar-09 12:26

Illegal Operation

18-Mar-09 12:26

Hi,

I have build an N-Tier Application based on the tutorial on this website http://blogs.microsoft.co.il/blogs/bursteg/archive/2008/02/10/how-to-build-an-n-tier-application-with-wcf-and-datasets-in-visual-studio-2008.aspx[^]

How can I publish my application including the WCF Service?

Illegal Operation

Message Removed

18-Mar-09 10:59

N_tro_P

18-Mar-09 10:59

Message Removed

Re: Get an IntPtr to an Image

Christian Graus18-Mar-09 11:05

Christian Graus

18-Mar-09 11:05

You can read my image processing articles, they all do it.

Christian Graus

Driven to the arms of OSX by Vista.

Message Removed

18-Mar-09 11:31

N_tro_P

18-Mar-09 11:31

Message Removed

Re: Get an IntPtr to an Image

Christian Graus18-Mar-09 12:27

Christian Graus

18-Mar-09 12:27

Collin Jasnoch wrote:
Stream tStream = new FileStream(imgPtr, FileAccess.Read);//Can I do this???
ImageTransfer.EnqueueImageStream(tStream);

Not sure if you can do this. But, the rest looks right.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Get an IntPtr to an Image

0x3c018-Mar-09 21:11

0x3c0

18-Mar-09 21:11

Image handle != File handle. That's why the filestream constructor fails.

Out of curiosity though, couldn't you just convert tempImage to a Bitmap, then call GetHbitmap?

How to connect Oracle to my C# program

E_Gold18-Mar-09 10:59

E_Gold

18-Mar-09 10:59

Hi how can i connect Oracle to my C# program ?
thank's

Re: How to connect Oracle to my C# program

EliottA18-Mar-09 11:03

EliottA

18-Mar-09 11:03

Not with google, that's for sure.[^]

Check out the CodeProject forum Guidelines[^]

Identifying which user is running a process?

bbranded18-Mar-09 9:55

bbranded

18-Mar-09 9:55

I can successfully build a list of processes and threads; but I'd like to be able to identify which user is running a process.

Does anyone have any insight into how to do this?

Thanks,

Matt Brown

Re: Identifying which user is running a process?

Anthony Mushrow18-Mar-09 10:29

Anthony Mushrow

18-Mar-09 10:29

This link seems promising: http://benreichelt.net/blog/2006/01/31/get-process-user-name/[^]

There's even an article on it at here: http://www.codeproject.com/KB/cs/processownersid.aspx[^]

Google has most of the insight, its always quicker to do a quick search than to post a topic.

My current favourite word is: Delicious!

-SK Genius

Game Programming articles start -here[^]-

Re: Identifying which user is running a process?

bbranded18-Mar-09 10:39

bbranded

18-Mar-09 10:39

Thanks for the info.

I had come across other example using win32_process, but I felt like it should be easier than this = there should be a method in a .NET class in system.diagnostic that I should be able to use to query for the username of a process.

But, I guess, I could be wrong Laugh | :laugh:

Thanks!

Matt Brown

Need Advice about Inserting

soulidentities18-Mar-09 9:00

soulidentities

18-Mar-09 9:00

Hi all
I dont know whether I am asking stupid ques or not but Can anyone advice me about some Insert in windows application.
I have 500000 data to insert in a database.
What will be most efficient way to do it?

Should I use ADO.NET or LINQ or in a proceduse or View....

By your advice I will start my coding Wink | ;)

I am a Beginer...
Thanks
Big Grin | :-D

Last Visit: 31-Dec-99 18:00 Last Update: 29-Apr-24 10:59

Refresh

ᐊ Prev 1...5443 5444 5445 544654475448 5449 5450 5451 5452 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.