private void GetServerAliasDetail() { try { tServerName.Text = ""; tServerRole.Text = ""; using (DataStuff sn = new DataStuff()) { DataTable dt = sn.GetServerAliasDetail(cbServerName.Text); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { tServerName.Text = row["ServerName"].ToString(); tServerRole.Text = row["ServerRoleDesc"].ToString(); } } } } catch { } }