User Profile

sigridish · Nov 28 '11, 05:19 AM

i already know how to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet. can you guys help me?

this is my code for saving

Code:

Public Sub saveExcelFile(ByVal FileName As String)
            Dim xls As New Excel.Application
            Dim sheet As Excel.Worksheet
            Dim i As

...

sigridish · Nov 24 '11, 05:08 AM

hi all! i have two combo box in my program

one has the subteam for example if you click the 1st combo box, the items would be
A1
A2
A3
A4
A5
what i want to happen is that if i chose A1 only the members of team A1 would appear in my combo box2. and by that, you need an sql statement. but how do i code that? can someone help me?

sigridish · Nov 17 '11, 01:32 AM

Code:

Dim lvitem
Dim iCount As Integer
Dim iLoop As Integer
Dim query3 = New SqlCommand
query3.Connection = New SqlConnection("SERVER=localhost;UID=root;DATABASE=test")
iCount = lvLogs.Items.Count()
If Not lvLogs.Items.Count = 0 Then
Do Until iLoop = lvLogs.Items.Count
 
LvItem = lvLogs.Items.Item(iLoop)
With LvItem
query3.CommandText = "insert into wer(CustomerName,SalesGroup,CustomerType,TypeOfIndustry,RM,SeniorRM)

...

sigridish · Nov 10 '11, 04:39 AM

Code:

Dim iCount As Integer
        Dim iLoop As Integer
        Dim query3 As New MySqlCommand
        Dim lvitem


        ConnectDatabase()
        cona.Open()
        iCount = lvLogs.Items.Count


        If Not lvLogs.Items.Count = 0 Then
            Do Until iLoop = lvLogs.Items.Count.ToString

                lvitem = lvLogs.Items.Item(iLoop).ToString

...

User Profile

Profile Sidebar

save listview data to same excel file but different sheet

how to filter in combo box

save data in sql using listview

error in object reference not set to an instance of an object