C#

Abdul Rahman Hamidy wrote:

how can i add identity column into the select statement

Abdul Rahman Hamidy wrote:

Note: I am only talking of make insert statement

OleCmd.CommandText=sqlCmdBuilder.GetInsertCommand().CommandText;
//add params here using for loop
OleCmd.ExecuteNonQuery();

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