SqlConnection con = new SqlConnection("Data Source=SERVER; Integrated Security=SSPI;persist security info=True;Initial Catalog=DBNAME;"); string empId=Request.QueryString["eid"].ToString(); SqlCommand cmd=new SqlCommand(string.Format("SELECT EmpName FROM empTable WHERE empId='{0}'",empId),con); con.Open(); string empName = Convert.ToString(cmd.ExecuteNonQuery()); con.Close();