using (var com = new SqlCommand("GetJobs", con))

// Uses store procedure.

com.CommandType = CommandType.StoredProcedure;

// Pass jobId to store procedure.

gdvData.DataSource = com.ExecuteScalar();

string sql1 = string.Format("SELECT job_id, job_desc, min_lvl, max_lvl FROM jobs WHERE job_id = @jobId");

using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLCONN1"].ToString()))

using (var com = new SqlCommand(sql1, con))

// Pass jobId to sql statement.

gdvData.DataSource = com.ExecuteReader();

gdvData.DataBind();