How to write all code in class file and retrieve them all on button click in asp.net using c#

Question

0.00/5 (No votes)

See more:

i want to declare all parameters in class file that is contained in app code folder. Also i want connection to be open and close in a single class file only. only on button click i want to execute all methods and events. my primary aim is to insert records in database and get them back on gridview. but i also want to keep code behind and class file different . my code in clas file is as follows:

C#

using System.Data.SqlClient;

public class Class1
{
    private int _Event;
    private int _EmpId;
    private string _EmpName;
    private int _Salary;
    private string _City;

    public int Event
    {
        get { return _Event; }
        set { Event = value; }
    }

    public int EmpId
    {
        get { return _EmpId; }
        set { EmpId = value; }
    }

    public string EmpName
    {
        get { return _EmpName; }
        set { EmpName = value; }
    }

    public int Salary
    {
        get { return _Salary; }
        set { Salary = value; }
    }

    public string City
    {
        get { return _City; }
        set { City = value; }
    }

    public Class1()
    {
        SqlConnection connect = new SqlConnection();
        SqlCommand command = new SqlCommand();
        command.Parameters.Add("@EmpId", SqlDbType.Int).Value = a;
        command.Parameters.Add("@Emp_name", SqlDbType.NVarChar).Value = b;
        command.Parameters.Add("@Salary", SqlDbType.Int).Value = c;
        command.Parameters.Add("@City", SqlDbType.NVarChar).Value = d;
        connect.Open();
        command.ExecuteNonQuery();
        command.Connection.Close();
    }

code in aspx.cs is as:

C#

protected void Button1_Click(object sender, EventArgs e)
   {
       Class1 obj = new Class1();

       int a = Convert.ToInt32(txtEmpId.Text);
       string b = txtEmpName.Text;
       int c = Convert.ToInt32(txtSalary.Text);
       string d = txtCity.Text;

but in class file a,b,c,d are showing error that a etc does not exist in current context.Why? what is problem ?

Posted 7-Jun-13 1:33am

Rambo_Raja

Updated 7-Jun-13 1:37am

Prasad Khandekar

v3

Add a Solution

1 solution

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)

Prasad Khandekar · Answer 1 · 2013-06-07T01:44:00

Hello R,

How do you expect Class1 instance to know value of a,b,c,d. What you should be doing in your code behind is

C#

protected void Button1_Click(object sender, EventArgs e)
{
    Class1 obj = new Class1();

    obj.EmpId = Convert.ToInt32(txtEmpId.Text);
    obj.EmpName = txtEmpName.Text;
    obj.Salary = Convert.ToInt32(txtSalary.Text);
    obj.City = txtCity.Text;
    obj.Save();
}

And change your Class1 as

C#

using System.Data.SqlClient;
 
public class Class1
{
    private int _Event;
    private int _EmpId;
    private string _EmpName;
    private int _Salary;
    private string _City;
 
    public int Event
    {
        get { return _Event; }
        set { Event = value; }
    }
 
    public int EmpId
    {
        get { return _EmpId; }
        set { EmpId = value; }
    }
 
    public string EmpName
    {
        get { return _EmpName; }
        set { EmpName = value; }
    }
 
    public int Salary
    {
        get { return _Salary; }
        set { Salary = value; }
    }
 
    public string City
    {
        get { return _City; }
        set { City = value; }
    }
 
    public void Save()
    {
        SqlConnection connect = new SqlConnection();
        SqlCommand command = new SqlCommand("YOUR INSERT QUERY GOES HERE");
        command.Parameters.Add("@EmpId", SqlDbType.Int).Value = EmpId;
        command.Parameters.Add("@Emp_name", SqlDbType.NVarChar).Value = EmpName;
        command.Parameters.Add("@Salary", SqlDbType.Int).Value = Salary;
        command.Parameters.Add("@City", SqlDbType.NVarChar).Value = City;
        connect.Open();
        command.ExecuteNonQuery();
        command.Connection.Close();
    }
}

Regards,