Visual Basic

Steven J Jowett wrote:

like an mdi child would remain on top of an mdi parent.

Dim newForm As New Form2()
newForm.Show(Me)

sikhan555 wrote:

I want to checked that the Value in InvoiceNo is must enter unique, i try so many things but i was unable.

SELECT invoiceNumber FROM Invoices WHERE invoiceNumber = @userEnteredNumber

ahzarmokhli wrote:

there are more then 2000 control in one page

<br />
'Open in Excel<br />
        Dim myExcel As New Microsoft.Office.Interop.Excel.Application()<br />
        Dim workBook As Microsoft.Office.Interop.Excel.Workbook<br />
        Dim workSheet As New Worksheet<br />
<br />
        Try<br />
<br />
            If myExcel Is Nothing Then<br />
                'Failed to load Excell Object<br />
            Else<br />
<br />
                workBook = myExcel.Workbooks.Open("C:\myfile.xls", 0, True, 5, "", "", True, XlPlatform.xlWindows, "\t", False, False, 0, True, 1, 0)<br />
                workSheet = workBook.ActiveSheet<br />
<br />
                workSheet.Cells(1, 1) = "My value"<br />
<br />
                workBook.Close()<br />
<br />
            End If<br />
<br />
<br />
        Catch ex As Exception<br />
            'Handle Exception<br />
        End Try<br />
<br />
        myExcel.Close()<br />