Calling a function from a button

Question

0.00/5 (No votes)

See more:

Hi, I have a Windows Form Application. I have a function which uses Linq to SQL to find the records I want but I don't know how to call this function in my button.click event so that the click function will launch my other function.

Also, in my button.click event I will need to set the textBox1.Text value to the sql statement but how would that be done?

C#

namespace InsertParameter
{
public partial class Form1 : Form
{
    LinqtoSqlDataContext linqStud = new LinqtoSqlDataContext();

    public Form1()
    {
        InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
        // how do I call the below function here???
    }

    public Exception searchCity(Student student, string searchCity)
    {
        try
        {
            if (string.IsNullOrEmpty(searchCity))
            {
                MessageBox.Show("Please enter a value");
            }
            else
            {
                var City = from stud in linqStud.Students
                           where stud.City == searchCity
                           select stud;

                dataGridView1.DataSource = City;

            }
            return null;
        }
        catch (Exception ex)
        {
            return ex;
        }
    }
}
}

Thanks

Nick

Posted 4-Jul-13 5:17am

Makin6425

Add a Solution

Comments

[no name] 4-Jul-13 11:21am

private void button1_Click(object sender, EventArgs e)
{
searchCity(instanceOfStudent, "some city");
}

JeremH 4-Jul-13 11:27am

Hi,

can you set a breakpoint in your clickevent to see that your event is ok. After you can call all method.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-07-04T05:23:00

It depends on how you are going to get the student parameter - but since your method doesn't actually use it...for the moment, you can just use a null:

C#

private void button1_Click(object sender, EventArgs e)
{
    Exception ex = searchCity(null, "New York");
    if (ex != null)
    {
        throw(ex);
    }
}

Makin6425 · Accepted Answer · 2013-07-04T05:23:00

update - here is the finished solution:

C#

public partial class Form1 : Form
    {
        LinqtoSqlDataContext linqStud = new LinqtoSqlDataContext();

        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Student student = new Student();
            string city = textBox1.Text;

            searchCity(student, city);
        }

        public Exception searchCity(Student student, string searchCity)
        {
            try
            {
                if (string.IsNullOrEmpty(searchCity))
                {
                    MessageBox.Show("Please enter a value");
                }
                else
                {
                    var City = from stud in linqStud.Students
                               where stud.City == searchCity
                               select stud;

                    dataGridView1.DataSource = City;

                }
                return null;
            }
            catch (Exception ex)
            {
                return ex;
            }

Calling a function from a button

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0