Click here to Skip to main content
15,904,828 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Prevent user from pasting into combo box Pin
Thomas Stockwell19-Aug-05 8:44
professionalThomas Stockwell19-Aug-05 8:44 
GeneralVBA Excel to SQL Server Pin
paulanthony17-Aug-05 22:46
paulanthony17-Aug-05 22:46 
GeneralRe: VBA Excel to SQL Server Pin
Mandar Patankar18-Aug-05 5:56
Mandar Patankar18-Aug-05 5:56 
GeneralRe: VBA Excel to SQL Server Pin
paulanthony18-Aug-05 6:03
paulanthony18-Aug-05 6:03 
GeneralRe: VBA Excel to SQL Server Pin
ulchris18-Aug-05 10:02
ulchris18-Aug-05 10:02 
GeneralHelp with Crystal Reports, desperetaly in need of help Pin
korso_rogan17-Aug-05 22:24
korso_rogan17-Aug-05 22:24 
GeneralComboBox Bind Problem Pin
Greeky17-Aug-05 21:32
Greeky17-Aug-05 21:32 
GeneralFormatting 1 field in excelsheet Pin
ybasha17-Aug-05 19:54
ybasha17-Aug-05 19:54 
Hi there,

I have a code which check for the url and return me the output in excel file the problem is i got a identifier in my data base which is '000002435' but while transfer into excel i get only '435' any suggestion here is the code snippet
With Excel
.SheetsInNewWorkbook = 1
.Workbooks.Add()
.Worksheets(1).Select()
For intColumn = 0 To ds.Tables(0).Columns.Count - 1
.Cells(1, intColumn + 1).Value = ds.Tables(0).Columns(intColumn).ColumnName.ToString
Next
'For displaying the column value row-by-row in the the excel file.
Dim o As Object
For intRow = 0 To ds.Tables(0).Rows.Count - 1
For intColumnValue = 0 To ds.Tables(0).Columns.Count - 1

.Cells(intRow + 2, intColumnValue + 1).Value = ds.Tables(0).Rows(intRow).ItemArray(intColumnValue).ToString

Next
Next
.ActiveWorkbook().SaveAs("C:\excel\excelsheet_output.xls")
.ActiveWorkbook.Close()
End With


Wink | ;)

regards
cyus
GeneralRe: Formatting 1 field in excelsheet Pin
Steve Pullan18-Aug-05 19:39
Steve Pullan18-Aug-05 19:39 
GeneralGet the binary content from a VC dll. Pin
rushing17-Aug-05 19:44
rushing17-Aug-05 19:44 
GeneralCreating an sql adapter,datatable and populating the fields of a grid Pin
mcupryk17-Aug-05 17:19
mcupryk17-Aug-05 17:19 
GeneralRe: Creating an sql adapter,datatable and populating the fields of a grid Pin
Christian Graus17-Aug-05 17:52
protectorChristian Graus17-Aug-05 17:52 
GeneralRe: Creating an sql adapter,datatable and populating the fields of a grid Pin
Anonymous17-Aug-05 19:20
Anonymous17-Aug-05 19:20 
GeneralRe: Creating an sql adapter,datatable and populating the fields of a grid Pin
Christian Graus18-Aug-05 14:49
protectorChristian Graus18-Aug-05 14:49 
QuestionGet list of machines in LAN? Pin
Jimmy Huynh17-Aug-05 16:46
Jimmy Huynh17-Aug-05 16:46 
AnswerRe: Get list of machines in LAN? Pin
Mohamad Al Husseiny17-Aug-05 16:50
Mohamad Al Husseiny17-Aug-05 16:50 
AnswerRe: Get list of machines in LAN? Pin
Steve Pullan17-Aug-05 17:26
Steve Pullan17-Aug-05 17:26 
AnswerRe: Get list of machines in LAN? Pin
Anonymous17-Aug-05 17:54
Anonymous17-Aug-05 17:54 
GeneralCalendar control in Access forms Pin
Anonymous17-Aug-05 12:43
Anonymous17-Aug-05 12:43 
GeneralRe: Calendar control in Access forms Pin
Anonymous17-Aug-05 12:44
Anonymous17-Aug-05 12:44 
GeneralUsing IS in Select Case Pin
dotnetCarpenter17-Aug-05 10:02
dotnetCarpenter17-Aug-05 10:02 
GeneralRe: Using IS in Select Case Pin
Steve Pullan17-Aug-05 15:00
Steve Pullan17-Aug-05 15:00 
GeneralRe: Using IS in Select Case Pin
dotnetCarpenter22-Aug-05 4:26
dotnetCarpenter22-Aug-05 4:26 
GeneralPrinting Array of Bytes to File Pin
ChemmieBro17-Aug-05 7:55
ChemmieBro17-Aug-05 7:55 
GeneralRe: Printing Array of Bytes to File Pin
BammBamm17-Aug-05 8:49
BammBamm17-Aug-05 8:49 

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.