C#

switch(cbSearch.SelectedItem.ToString())
{
    case "Lastname":
        cmd = new SqlCommand("SPSearchRmiInfoLastname", conn);
        cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Lastname", txtSearch.Text);
            break;
    case "Firstname":
            cmd = new SqlCommand("SPSearchRmiInfoFirstname", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@Firstname", txtSearch.Text);
            break;
}
conn.Open();
Search.Clear();

SqlDataReader drd = cmd.ExecuteReader();
while(drd.Read())
{
    Search.Rows.Add(new object[] {drd[0], drd[1], drd[2], drd[3]});
    sbp.Text = Search.Rows.Count+" records found.";
}
dg.DataSource = Search;

drd.Close();
conn.Close();