protected void btnTest2_Click(object sender, EventArgs e) { SqlProcedures UrpSqlProcedures = new SqlProcedures(); Instruction instruction = UrpSqlProcedures.LoadInstructions(1); lblTest2.Text = instruction.Body; }
public static void SetSingleSubscriptionInstalledDB(string DBName, string mainServiceName, string password, string subscriber, string procedureName, SqlParameterCollection testProcedureParameters) { SetAdminInstalledDB(DBName, mainServiceName, password); Subscription subscription = new Subscription( mainServiceName, subscriber, CommonTestsValues.SubscribedProcedureSchema, procedureName, testProcedureParameters); SqlProcedures sqlProcedures = new SqlProcedures(serviceAccessDB); sqlProcedures.InstallSubscription(subscription); }
public static void SetTwoSubscriptionInstalledDB(string DBName, string mainServiceName, string password, string firstSubscriber, string firstProcedureName, SqlParameterCollection firstTestProcedureParameters, string secondSubscriber, string secondProcedureName, SqlParameterCollection secondTestProcedureParameters) { SetSingleSubscriptionInstalledDB( DBName, mainServiceName, password, firstSubscriber, firstProcedureName, firstTestProcedureParameters); Subscription subscription = new Subscription( mainServiceName, secondSubscriber, CommonTestsValues.SubscribedProcedureSchema, secondProcedureName, secondTestProcedureParameters); SqlProcedures sqlProcedures = new SqlProcedures(serviceAccessDB); sqlProcedures.InstallSubscription(subscription); }
protected void btnTest_Click(object sender, EventArgs e) { SqlProcedures UrpSqlProcedures = new SqlProcedures(); if (UrpSqlProcedures.TestConnection()) { lblTest.Text = "urpDB connection established"; DataSet testData = new DataSet(); //testData = UrpSqlProcedures.LoadAdministrator(); StringBuilder sbTest = new StringBuilder(); for (int i = 0; i < testData.Tables[0].Rows.Count; i++) { sbTest.Append(testData.Tables[0].Rows[i][1] + "\n"); } lblTest.Text = sbTest.ToString(); } else { lblTest.Text = "Connection Failed to Open"; } }