CODEWITHSUNDEEP
c#asp.netsql-serverclass
Sridhar
Sridhar

Reputation: 149

How to write connection string in class file using c#?

I have created registration form in asp.net web application and created database in sqlserver.

My button click event are:

protected void btnSubmit_Click(object sender, EventArgs e)
{
    string fname = txtFirst.Text;
    string lname = txtLast.Text;
    string middle = txtMiddle.Text;
    string dob = txtDOB.Text;                     
    string add1 = txtAdd1.Text;
    string add2 = txtAdd2.Text;
    string dateofjoin = txtDateofjoin.Text;

    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Employee"].ToString());
    con.Open();

    SqlCommand cmd = new SqlCommand("EmployeeRegister", con);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@firstname", fname);
    cmd.Parameters.AddWithValue("@lastname", lname);
    cmd.Parameters.AddWithValue("@middlename", middle);
    cmd.Parameters.AddWithValue("@dateofbirth", dob);
    cmd.Parameters.AddWithValue("@address1", add1);
    cmd.Parameters.AddWithValue("@address2", add2);
    cmd.Parameters.AddWithValue("@dateofjoin", dateofjoin);
    cmd.Parameters.AddWithValue("@active", CheckActive.Checked ? "1" : "0");
    cmd.ExecuteNonQuery();
    con.Close();                      
}

so I have created the Connection.cs file,In that i wanna write the connection string on class file and call it on button click event so is that possible?

Upvotes: 2

Views: 1716

Answers (2)

sanatsathyan
sanatsathyan

Reputation: 1763

In your connection.cs class, do :

public class Connection
{
    public static readonly string ConnectionString = "your connection string here";
}

And do the button click event like: 

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string fname = txtFirst.Text;
        string lname = txtLast.Text;
        string middle = txtMiddle.Text;
        string dob = txtDOB.Text;
        string add1 = txtAdd1.Text;
        string add2 = txtAdd2.Text;
        string dateofjoin = txtDateofjoin.Text;

        SqlConnection con = new SqlConnection(Connection.ConnectionString);
        con.Open();

        SqlCommand cmd = new SqlCommand("EmployeeRegister", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@firstname", fname);
        cmd.Parameters.AddWithValue("@lastname", lname);
        cmd.Parameters.AddWithValue("@middlename", middle);
        cmd.Parameters.AddWithValue("@dateofbirth", dob);
        cmd.Parameters.AddWithValue("@address1", add1);
        cmd.Parameters.AddWithValue("@address2", add2);
        cmd.Parameters.AddWithValue("@dateofjoin", dateofjoin);
        cmd.Parameters.AddWithValue("@active", CheckActive.Checked ? "1" : "0");
        cmd.ExecuteNonQuery();
        con.Close();

    }

Upvotes: 0

NnN
NnN

Reputation: 463

Try like this

string connectionString ="Your connection string comes here";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand cmd = new SqlCommand("EmployeeRegister", connection);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@firstname", fname);
    cmd.Parameters.AddWithValue("@lastname", lname);
    cmd.Parameters.AddWithValue("@middlename", middle);
    cmd.Parameters.AddWithValue("@dateofbirth", dob);
    cmd.Parameters.AddWithValue("@address1", add1);
    cmd.Parameters.AddWithValue("@address2", add2);
    cmd.Parameters.AddWithValue("@dateofjoin", dateofjoin);
    cmd.Parameters.AddWithValue("@active", CheckActive.Checked ? "1" : "0");
    cmd.ExecuteNonQuery();
}

Upvotes: 1

Related Questions