Click here to Skip to main content
15,917,174 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionError Provider! Pin
Deepasubramanian30-Aug-06 2:28
Deepasubramanian30-Aug-06 2:28 
AnswerRe: Error Provider! Pin
Stephen McGuire30-Aug-06 9:11
Stephen McGuire30-Aug-06 9:11 
QuestionHow do I write a script to Backup Outlook Express Groups Pin
Tom Moore30-Aug-06 2:15
Tom Moore30-Aug-06 2:15 
QuestionRemote Protocol Management Software Pin
wildfire232330-Aug-06 2:12
wildfire232330-Aug-06 2:12 
AnswerRe: Remote Protocol Management Software [modified] Pin
Dave Kreskowiak30-Aug-06 9:09
mveDave Kreskowiak30-Aug-06 9:09 
Questionrestore database Pin
md_refay30-Aug-06 2:05
md_refay30-Aug-06 2:05 
QuestionHow Microsoft does it? Pin
jayvardhanpatil30-Aug-06 0:36
jayvardhanpatil30-Aug-06 0:36 
QuestionExport Data To Excel Pin
obarahmeh30-Aug-06 0:26
obarahmeh30-Aug-06 0:26 
WTF | :WTF: Hi Every Body
I asked before you about the way to export the DataSet into Excel Sheet, but I still have a problem in this subject...The code which I use is the following:
dim tblname as DataTable

Dim ExcelApp As Excel.Application = New Excel.Application
Dim Workbooks As Excel.Workbooks = ExcelApp.Workbooks
Dim Workbook As Excel.Workbook = Workbooks.Add(System.Reflection.Missing.Value)
Dim Sheets As Excel.Sheets = Workbook.Sheets

Dim Worksheet As Excel.Worksheet = Sheets("Sheet1")

Dim RowsCount As Integer = tblname.Rows.Count
Dim ColsCount As Integer = tblname.Columns.Count

Dim ColsCounter As Integer
Dim RowsCounter As Integer

'Columns Header
For ColsCounter = 0 To ColsCount - 1
Worksheet.Cells(1, ColsCounter + 1) = tblname.Columns(ColsCounter).ColumnName.ToString
'First Row for Columns Header
Next

For RowsCounter = 0 To RowsCount - 1
For ColsCounter = 0 To ColsCount - 1
Worksheet.Cells(RowsCounter + 2, ColsCounter + 1) = tblname.Rows(RowsCounter)(ColsCounter)
'Start With the Second Row Because First Row for Columns Header
Next
Next

ExcelApp.Visible = True
ExcelApp.UserControl = True

Note: After many searches over the Internet, I have found that the reason for the error in the previous code is named Late Binding, and I think that this is the main reason for the problem is what I said about the Late Binding. Is there any body know about this problem and the solution about it?

Simsem
AnswerRe: Export Data To Excel Pin
Stephen McGuire30-Aug-06 9:04
Stephen McGuire30-Aug-06 9:04 
GeneralRe: Export Data To Excel Pin
obarahmeh30-Aug-06 19:42
obarahmeh30-Aug-06 19:42 
GeneralRe: Export Data To Excel Pin
Stephen McGuire31-Aug-06 2:19
Stephen McGuire31-Aug-06 2:19 
GeneralRe: Export Data To Excel Pin
obarahmeh2-Sep-06 0:19
obarahmeh2-Sep-06 0:19 
QuestionVisual Basic 6 DataGrid Problem Pin
udithaphp29-Aug-06 22:37
udithaphp29-Aug-06 22:37 
QuestionNeed a code to close the application after specific time Pin
Neo_Ali29-Aug-06 22:34
Neo_Ali29-Aug-06 22:34 
AnswerRe: Need a code to close the application after specific time Pin
CWIZO30-Aug-06 1:09
CWIZO30-Aug-06 1:09 
GeneralRe: Need a code to close the application after specific time Pin
Neo_Ali30-Aug-06 20:38
Neo_Ali30-Aug-06 20:38 
GeneralRe: Need a code to close the application after specific time Pin
CWIZO30-Aug-06 21:51
CWIZO30-Aug-06 21:51 
AnswerRe: Need a code to close the application after specific time Pin
Kanniah30-Aug-06 4:18
Kanniah30-Aug-06 4:18 
Questionis it possible to add ghostscript code to vb.net aaplication Pin
kannan m29-Aug-06 22:16
kannan m29-Aug-06 22:16 
AnswerRe: is it possible to add ghostscript code to vb.net aaplication Pin
Dave Kreskowiak30-Aug-06 5:11
mveDave Kreskowiak30-Aug-06 5:11 
QuestionSpell Check Pin
Sinchan Nikam29-Aug-06 22:13
Sinchan Nikam29-Aug-06 22:13 
AnswerRe: Spell Check Pin
Marc Soleda30-Aug-06 11:24
Marc Soleda30-Aug-06 11:24 
JokeRe: Spell Check Pin
Dave Sexton31-Aug-06 4:36
Dave Sexton31-Aug-06 4:36 
AnswerRe: Spell Check Pin
S Douglas5-Sep-06 0:39
professionalS Douglas5-Sep-06 0:39 
AnswerRe: Spell Check Pin
Suelinda_W7-Sep-06 11:01
Suelinda_W7-Sep-06 11:01 

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.