private void btnViewTicketTemplate_Click(object sender, EventArgs e) { try { DbBehavior.DbConnectionString = txtDbConnectionString.Text; var query = string.Format( "SELECT \r\n" + "[TicketTemplateId] \r\n" + ",[PlayTypeId] \r\n" + ",[Name] \r\n" + ",[Value] \r\n" + ",[TourneyTemplateIdList] \r\n" + ",[Refundable] \r\n" + "FROM [rb_crm_dev].[dbo].[TicketTemplates] \r\n"); var form = new FrmViewFromQuery(query); form.Show(); } catch (Exception ex) { AddLog("ViewPlayers Exception : ", ex.ToString()); } }
private void btnViewPlayers_Click(object sender, EventArgs e) { try { DbBehavior.DbConnectionString = txtDbConnectionString.Text; var query = string.Format( "SELECT \r\n" + "[UserName] \r\n" + ",[AccountId] \r\n" + ",[NickName] \r\n" + "--,[ServiceProviderId] \r\n" + "--,[Rank] \r\n" + "--,[Name] \r\n" + "--,[Email] \r\n" + "--,[RegistrationDate] \r\n" + "--,[RegistrationIP] \r\n" + "--,[Address1] \r\n" + "--,[Address2] \r\n" + "--,[City] \r\n" + "--,[State] \r\n" + "--,[ZipCode] \r\n" + "--,[Country] \r\n" + "--,[Phone] \r\n" + "--,[ChatLocked] \r\n" + "--,[ChatLockExpireDays] \r\n" + "--,[PlayLocked] \r\n" + "--,[PlayLockExpireDays] \r\n" + "--,[AccountLocked] \r\n" + "--,[AccountLockExpireDays] \r\n" + "--,[GGPoint] \r\n" + "--,[TourneyMoney] \r\n" + "--,[ImageLocked] \r\n" + "--,[SuperUser] \r\n" + "--,[LoginName] \r\n" + "FROM [rb_crm_dev].[dbo].[Players] \r\n" + "WHERE 1=1 \r\n" + "AND [ServiceProviderId] = '1432EEC3-7431-EFCF-8B58-BBF351EB0E40' \r\n" + "ORDER BY SUBSTRING(NickName, 1, 1), LEN(NickName), NickName \r\n"); var form = new FrmViewFromQuery(query); form.Show(); } catch (Exception ex) { AddLog("ViewPlayers Exception : ", ex.ToString()); } }