Data Accessing vai Stored Procedures

String cs = "Data Source=.\\SQLExpress; Initial Catalog= AdventureWork"
using (System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection())
{
con.Open();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "EmployeeByState"; //name of the stored procedure

cmd.Parameters.Add("@StateProvinceCode", System.Data.SqlDbType.NChar,3);
cmd.Parameters["@StateProvinceCode"].Value = "WA"; //passing parameters to the SP
using (System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader())
{
gridview1.DataSource = reader;
gridview1.DataBind();
}
}