C#

Abdul Rahman Hamidy wrote:

i want to migirate all sql server tables data into ms access.

Rajesh Koriya wrote:

But I get Error "Login failed for user(sa)".

Anil709 wrote:

That code is to print the content from only one rich text box control

private int checkPrintFirstControl;
private int checkPrintSecondControl;
bool firstControlDone = false;
private void printDocument1_BeginPrint(object sender, System.Drawing.Printing.PrintEventArgs e)
        {
            checkPrintFirstControl = 0;
            checkPrintSecondControl = 0;
        }

private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
        {
            //Verify if your First control is printed or not
            if (!firstControlDone)
            {
                // Print the content of First RichTextBox. Store the last character printed.
                checkPrintFirstControl = FirstrichTextBox.Print(checkPrintFirstControl, FirstrichTextBox.TextLength, e);

                // Check if you are done with printing the first RichTextBox
                if (checkPrintFirstControl >= FirstrichTextBox.TextLength)
                    firstControlDone = true;
                //Setting this because you have to print second control
                e.HasMorePages = true;
            }
            else
            {
                checkPrintSecondControl = SecondrichTextBox.Print(checkPrintSecondControl, SecondrichTextBox.TextLength, e);

                // Check for more pages for the first RichTextBox
                if (checkPrintSecondControl < SecondrichTextBox.TextLength)
                    e.HasMorePages = true;
                else
                {
                    e.HasMorePages = false;
                    firstControlDone = false;
                }

            }

        }

Anil709 wrote:

it could print either first text box data or from second text box data

Britt Adams wrote:

using Dynamic Data and Entities for managing usernames, passwords, resources and such.

Britt Adams wrote:

database encrypted and when the data is loaded decrypt it

public class EncryptDecryptClass
    {
        public static string Encrypt(string valueToEncrypt)
        {
            byte[] byteArray = System.Text.ASCIIEncoding.ASCII.GetBytes(valueToEncrypt);

            string encryptedString = Convert.ToBase64String(byteArray);

            return encryptedString;

        }

        public static string DecryptString(string encryptedString)
        {
            byte[] byteArray = Convert.FromBase64String(encryptedString);
            string decryptedString = System.Text.ASCIIEncoding.ASCII.GetString(byteArray);
            return decryptedString;
        }

    }