hey i m jashmin,
i m making project on c#.net VS2010. i want backup to excel from c#............will u give some tips or stuff plz i want to make report from database...........
jashmin
0
Newbie Poster
Recommended Answers
Jump to PostHi Jashmin welcome here.
You could search this site or google: example http://social.msdn.microsoft.com/Forums/en/csharpgeneral/thread/ef11a193-54f3-407b-9374-9f5770fd9fd7
Jump to PostOPENROWSET is a SQL Server database command.
'Microsoft.Jet.OLEDB.4.0' is telling the command what database driver to use.
'Excel 8.0....' is telling the command where the output goes.
'SELECT ...' is the command that selects the data from the database.
All 11 Replies
ddanbe
2,724
Professional Procrastinator
Featured Poster
Hi Jashmin welcome here.
You could search this site or google: example http://social.msdn.microsoft.com/Forums/en/csharpgeneral/thread/ef11a193-54f3-407b-9374-9f5770fd9fd7
jashmin
0
Newbie Poster
hey i m not able to do............plz help me........
means i have purchase form when it working in vs2010,purchase table which is store in database...nw i kept 1 button report in c#.net,vs2010 on click......i want all purchase data in excel 20007.i want all d backup in excel from c#.net using sql20008 database
jashmin
0
Newbie Poster
plz any one help me
Momerath
1,327
Nearly a Senior Poster
Featured Poster
jashmin
0
Newbie Poster
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT Name, Date FROM [Sheet1$]')
SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs
GO
hey plz explian me wht is OPENROWSET.THIS IS TAABLE OR WHT???
'Microsoft.Jet.OLEDB.4.0' IS this any varchar ??
'Excel 8.0;Database=C:\testing.xls;' isthis varchar??
'SELECT Name, Date FROM [Sheet1$]' hey whts dis???
jashmin
0
Newbie Poster
hey plz dont get angree .............but i m not getting.......
Momerath
1,327
Nearly a Senior Poster
Featured Poster
OPENROWSET is a SQL Server database command.
'Microsoft.Jet.OLEDB.4.0' is telling the command what database driver to use.
'Excel 8.0....' is telling the command where the output goes.
'SELECT ...' is the command that selects the data from the database.
jashmin
0
Newbie Poster
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT Name, Date FROM [Sheet1$]')
SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs
GO
Database=C:\testing.xls;', /dis is sqlserver path wich is displayed when we will start sql......
jashmin
0
Newbie Poster
.but tell me i have to write dis query in sql2008 and execute..............??
99% sure i have to write in sql but here c#.net is in between sql2008,excel.........
means i m keping button on form of vs2010.....i want to click on button that will fetch d data from database and it will displaty on excel.
jashmin
0
Newbie Poster
rly........
Momerath
1,327
Nearly a Senior Poster
Featured Poster
What code have you written for your button? Do you know how to connect to a database and run a query?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.