Click here to Skip to main content
15,395,529 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: group by name for sum amount Pin
Dave Kreskowiak14-Nov-19 2:40
mveDave Kreskowiak14-Nov-19 2:40 
Questioncode project data base Pin
abuahmed20191-Nov-19 4:24
Memberabuahmed20191-Nov-19 4:24 
AnswerRe: code project data base Pin
Dave Kreskowiak1-Nov-19 5:00
mveDave Kreskowiak1-Nov-19 5:00 
QuestionSystem.IO.IOException HResult=0x80131620 When using NetworkStream.Read function Pin
fd975029-Oct-19 22:48
professionalfd975029-Oct-19 22:48 
AnswerRe: System.IO.IOException HResult=0x80131620 When using NetworkStream.Read function Pin
Richard MacCutchan29-Oct-19 23:09
mveRichard MacCutchan29-Oct-19 23:09 
GeneralRe: System.IO.IOException HResult=0x80131620 When using NetworkStream.Read function Pin
fd975029-Oct-19 23:23
professionalfd975029-Oct-19 23:23 
GeneralRe: System.IO.IOException HResult=0x80131620 When using NetworkStream.Read function Pin
fd975030-Oct-19 0:02
professionalfd975030-Oct-19 0:02 
QuestionHow to solve problem with datagrid and tabcontrol(vb.net) Pin
Member 1447080727-Oct-19 22:52
MemberMember 1447080727-Oct-19 22:52 
Error in exporting SHEET2
code to populate datagrid:
'For x = 0 To ds.Tables.Count - 1
'    Dim tp As New TabPage("TabPage" & x)
'    TabControl1.TabPages.Add(tp)
'    DataGridView(x) = New DataGridView
'    'Dim tabPagex As System.Windows.Forms.TabPage
'    tp.Controls.Add(DataGridView(x))
'    DataGridView(x).DataSource = ds.Tables(x)
'    DataGridView(x).Dock = DockStyle.Fill
'Next


Export to excel:
Dim xlApp, xlBook, xlSheet As Object
        xlApp = CreateObject("Excel.Application")
        xlBook = xlApp.Workbooks.Add
        xlSheet = xlBook.Worksheets()
        xlApp.Visible = True
        xlSheet = xlBook.Sheets("sheet1")
        Dim Cols As Integer
        For Cols = 1 To DataGridView1.Columns.Count
            xlApp.Cells(1, Cols) = DataGridView1.Columns(Cols - 1).HeaderText
        Next
        Dim i As Integer
        For i = 0 To DataGridView1.RowCount - 1
            Dim j As Integer
            For j = 0 To DataGridView1.ColumnCount - 1
                If Me.DataGridView1(j, i).Value Is System.DBNull.Value Then
                    xlApp.Cells(i = 2, j = 1) = ""
                Else
                    xlApp.Cells(i + 2, j + 1) = DataGridView1(j, i).Value.ToString
                End If
            Next
        Next
        xlApp.Sheets.Add(xlApp.Sheets("sheet1"))
        xlApp.Sheets("sheet2").Select()
        For Cols = 1 To DataGridView2.Columns.Count
            xlApp.Cells(1, Cols) = DataGridView2.Columns(Cols - 1).HeaderText
        Next
        For i = 0 To DataGridView2.RowCount - 1
            Dim j As Integer
            For j = 0 To DataGridView2.ColumnCount - 1
                If Me.DataGridView2(j, i).Value Is System.DBNull.Value Then
                    xlApp.Cells(i = 2, j = 1) = ""
                Else
                    xlApp.Cells(i + 2, j + 1) = DataGridView2(j, i).Value.ToString
                End If
            Next
        Next
        xlApp.Sheets.Add(xlApp.Sheets("sheet2"))
        xlApp.Sheets("sheet3").Select()
        For Cols = 1 To DataGridView3.Columns.Count
            xlApp.Cells(1, Cols) = DataGridView3.Columns(Cols - 1).HeaderText
        Next
        For i = 0 To DataGridView3.RowCount - 1
            Dim j As Integer
            For j = 0 To DataGridView3.ColumnCount - 1
                If Me.DataGridView3(j, i).Value Is System.DBNull.Value Then
                    xlApp.Cells(i = 2, j = 1) = ""
                Else
                    xlApp.Cells(i + 2, j + 1) = DataGridView3(j, i).Value.ToString
                End If
            Next
        Next

AnswerRe: How to solve problem with datagrid and tabcontrol(vb.net) Pin
Richard MacCutchan27-Oct-19 23:14
mveRichard MacCutchan27-Oct-19 23:14 
GeneralRe: How to solve problem with datagrid and tabcontrol(vb.net) Pin
Member 1447080730-Oct-19 17:33
MemberMember 1447080730-Oct-19 17:33 
GeneralRe: How to solve problem with datagrid and tabcontrol(vb.net) Pin
Richard MacCutchan30-Oct-19 22:58
mveRichard MacCutchan30-Oct-19 22:58 
QuestionVB Script stopped working on Windows 10 + Office 365 Pro Pin
Member 1463660627-Oct-19 21:29
MemberMember 1463660627-Oct-19 21:29 
AnswerRe: VB Script stopped working on Windows 10 + Office 365 Pro Pin
OriginalGriff27-Oct-19 21:33
mveOriginalGriff27-Oct-19 21:33 
GeneralRe: VB Script stopped working on Windows 10 + Office 365 Pro Pin
Member 1463660627-Oct-19 21:36
MemberMember 1463660627-Oct-19 21:36 
GeneralRe: VB Script stopped working on Windows 10 + Office 365 Pro Pin
OriginalGriff27-Oct-19 21:39
mveOriginalGriff27-Oct-19 21:39 
GeneralRe: VB Script stopped working on Windows 10 + Office 365 Pro Pin
Member 1463660627-Oct-19 22:28
MemberMember 1463660627-Oct-19 22:28 
GeneralRe: VB Script stopped working on Windows 10 + Office 365 Pro Pin
OriginalGriff27-Oct-19 22:41
mveOriginalGriff27-Oct-19 22:41 
GeneralRe: VB Script stopped working on Windows 10 + Office 365 Pro Pin
Member 1463660627-Oct-19 22:53
MemberMember 1463660627-Oct-19 22:53 
GeneralRe: VB Script stopped working on Windows 10 + Office 365 Pro Pin
OriginalGriff27-Oct-19 23:08
mveOriginalGriff27-Oct-19 23:08 
QuestionListbox event, ItemSelectionChanged, how to wait for last event, or cancel events Pin
jkirkerx24-Oct-19 7:36
professionaljkirkerx24-Oct-19 7:36 
AnswerRe: Listbox event, ItemSelectionChanged, how to wait for last event, or cancel events Pin
Dave Kreskowiak24-Oct-19 15:35
mveDave Kreskowiak24-Oct-19 15:35 
GeneralRe: Listbox event, ItemSelectionChanged, how to wait for last event, or cancel events Pin
jkirkerx25-Oct-19 10:56
professionaljkirkerx25-Oct-19 10:56 
Questionhow i create a video conference program Pin
Member 1462143013-Oct-19 8:09
MemberMember 1462143013-Oct-19 8:09 
AnswerRe: how i create a video conference program Pin
Dave Kreskowiak13-Oct-19 16:05
mveDave Kreskowiak13-Oct-19 16:05 
QuestionStepper Motor control code Pin
Member 1462018511-Oct-19 12:10
MemberMember 1462018511-Oct-19 12:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.