Is there a method summary snippet? - C# Discussion Boards

Re: How to handle a User Control Event ?

Pankaj Nikam19-Mar-09 7:21

19-Mar-09 7:21

Thanks for the Answer. Can you tell me how to expose the button ? Do you mean that I should add the button on the control at runtime ?

Always Keep Smiling.
Yours Pankaj Nikam

Re: How to handle a User Control Event ?

DaveyM6919-Mar-09 0:04

DaveyM69

19-Mar-09 0:04

If you need to be able to set Accept and Cancel you can't do it with the designer.

In the user control create readonly properties for Accept and Cancel buttons

[Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
public IButtonControl AcceptButton
{
    get { return button1; }
}
[Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
public IButtonControl CancelButton
{
    get { return button2; }
}

then in the host form you can set in code

AcceptButton = userControl11.AcceptButton;
CancelButton = userControl11.CancelButton;

If you want it through the designer then you can only have one button. Just make the user control also derive from IButtonControl and implement it to use the button in question.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: How to handle a User Control Event ?

dan!sh 19-Mar-09 2:27

dan!sh

19-Mar-09 2:27

Wow...didn't knew this thing. If had the same issue, I would have exposed the button to the form. This would have made the purpose of having a user control go in vain. It's one thing I learnt today. Thanks.

जय हिंद

Re: How to handle a User Control Event ?

DaveyM6919-Mar-09 2:53

DaveyM69

19-Mar-09 2:53

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: How to handle a User Control Event ?

Pankaj Nikam19-Mar-09 7:19

Pankaj Nikam

19-Mar-09 7:19

Thanks a lot for this one...I will surely try this one. And what about the event handler ? Can you help me ?

Always Keep Smiling.
Yours Pankaj Nikam

Re: How to handle a User Control Event ?

DaveyM6919-Mar-09 7:33

DaveyM69

19-Mar-09 7:33

There's a few ways this can be done. The easiest is just to subscribe in the user control and raise a new event each time.

using System;
using System.ComponentModel;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class UserControl1 : UserControl
    {
        public event EventHandler Button1Clicked;
        public event EventHandler Button2Clicked;

        public UserControl1()
        {
            InitializeComponent();
            button1.Click += new EventHandler(button1_Click);
            button2.Click += new EventHandler(button2_Click);
        }

        protected virtual void button1_Click(object sender, EventArgs e)
        {
            EventHandler eh = Button1Clicked;
            if (eh != null)
                eh(this, e);
        }

        protected virtual void button2_Click(object sender, EventArgs e)
        {
            EventHandler eh = Button2Clicked;
            if (eh != null)
                eh(this, e);
        }

        [Browsable(false),
        DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
        public IButtonControl AcceptButton
        {    
            get { return button1; }
        }

        [Browsable(false),
        DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
        public IButtonControl CancelButton
        {    get { return button2; }
        }
    }
}

You now have userControl11.Button1Clicked and userControl11.Button2Clicked events available in your host form like any other control's events.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: How to handle a User Control Event ?

Pankaj Nikam19-Mar-09 7:38

Pankaj Nikam

19-Mar-09 7:38

DaveyM69 wrote:
You now have userControl11.Button1Clicked and userControl11.Button2Clicked events available in your host form like any other control's events.

Thank you very very much Smile | :)

Always Keep Smiling.
Yours Pankaj Nikam

Is there a method summary snippet?

12Code18-Mar-09 18:32

12Code

18-Mar-09 18:32

Hi, Does anyone know how to insert a method summary Snippet or any shortcut key,

/// <summary><br />
/// MyFunction method<br />
/// <summary><br />
private void MyFunction()<br />
{<br />
}<br />

or

Is there a way to create such a snippet?

Kelvin

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