Hi there,
I'm using microsoft visual studio 2005, with c# code. I recently downloaded GemBox which is a spreadsheet for excel. I can pass parameters through textboxes, comboboxes, labels...etc and display it on cells in excell. But now Im calling parameters directly from the database...I would like to know how to display it in excel...Here is part of the code I'm working on: (How can I make it work?)
ExcelFile ef = new ExcelFile();
ef.LoadXls("C:/Invoice.xls");
ExcelWorksheet ws = ef.Worksheets[0];
string sqlq = " SELECT Guest.GuestID, Guest.GuestFirs tName, Guest.GuestLast Name, Guest.GuestAddr ess, Guest.GuestEmai l, Guest.Country, Guest.GuestPhon e, Sales.GuestID, Sales.Date, Sales.Quantity, Sales.SaleItem, Sales.SalePrice , Sales.SaleTotal , Sales.SaleDisco unt, FROM Guest Sales LEFT JOIN GuestID Sales ON Guest.GuestID = Sales.GuestID WHERE Guest.GuestID && Sales.GuestID = @GuestID ";
myCommand.Comma ndText = sqlq;
myCommand.Param eters.Add("@Gue stID ", SqlDbType.Int). Value = 12345;
myCommand.Param eters.Add("@Gue stFirstName ", SqlDbType.VarCh ar).Value = ws.Cells["D13"].Value;
myCommand.Param eters.Add("@Gue stLastName ", SqlDbType.VarCh ar).Value = ws.Cells["D13"].Value;
myCommand.Param eters.Add("@Gue stAddress ", SqlDbType.VarCh ar).Value = ws.Cells["D14"].Value;
myCommand.Param eters.Add("@Gue stEmail ", SqlDbType.VarCh ar).Value = ws.Cells["D15"].Value;
myCommand.Param eters.Add("@Cou ntry ", SqlDbType.VarCh ar).Value = ws.Cells["H15"].Value;
myCommand.Param eters.Add("@Gue stPhone ", SqlDbType.DateT ime).Value = ws.Cells["D16"].Value;
myCommand.Param eters.Add("@Dat e ", SqlDbType.DateT ime).Value = ws.Cells["M13"].Value;
myCommand.Param eters.Add("@Qua ntity ", SqlDbType.Int). Value = ws.Cells["C19"].Value;
myCommand.Param eters.Add("@Sal eItem ", SqlDbType.VarCh ar).Value = ws.Cells["D19"].Value;
myCommand.Param eters.Add("@Sal ePrice ", SqlDbType.Money ).Value = ws.Cells["L19"].Value;
myCommand.Param eters.Add("@Sal eTotal ", SqlDbType.Money ).Value = ws.Cells["M19"].Value;
myCommand.Param eters.Add("@Sal eDiscount ", SqlDbType.VarCh ar).Value = ws.Cells["L38"].Value;
0 1168 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Allison Bailey |
last post by:
Hi Folks,
I'm a brand new Python programmer, so please point me in the right
direction if this is not the best forum for this question....
I would like to open an existing MS Excel spreadsheet and extract
information from specific worksheets and cells.
I'm not really sure how to get started with this process.
I ran the COM Makepy utility from my PythonWin (IDE from ActiveSTate),
|
by: EMW |
last post by:
How can I put everything that is in a datagrid into a SQL server database
(which should be readable by an PocketPC program)?
There is probably a simple solution for it, but as always it is difficult to
find it in the jungle of MSDN.
thanks!
Eric
|
by: ctkevin |
last post by:
I am an experienced Access user but recently moved an Access database
to the web for my employer.
We use a host that does not allow the use of data access pages.
Is there anyway to pre-build a query and/or report in Access that could
generate an Excel download? I was thinking of using a macro, but I
have no idea how to invoke the macro.
Thanks in advance!
|
by: Powerguy |
last post by:
Hi all,
I've spent countless hours trying to get this silly EXCEL process to
close once I have used it. If anyone can help it would really REALLy
be appreciated! Below is my code-
Dim t As Integer
Dim testCount As Boolean
testCount = False
For t = 0 To UserListView.Items.Count - 1
|
by: RickH |
last post by:
..Cells(1,y).GetType ownly shows instead of .Value, .Copy, etc.
The code below is derived from samples, it should work, but I've messed up
somewhere...
Imports System.Windows.Forms
Imports Office = Microsoft.Office.Core
Imports Excel = Microsoft.Office.Interop.Excel
Imports MSForms = Microsoft.Vbe.Interop.Forms
' Office integration attribute. Identifies the startup class for the
| |
by: Agnes |
last post by:
I can export the data to an excel(quit slow , for 5k records, It need
20mins)
Now, my problem is how can I join another table from another database ?
"select I.invno,I.company,C.telno,C.faxno from invoice I,company C where
I.company = C.company"
Thanks a lot
Dim Excel As New Excel.Application
Dim intColumn, intRow, intColumnValue As Integer
Dim strExcelFile As String
Dim strFileName As String
|
by: alexia.bee |
last post by:
Hi all,
In some weird reason, excel instance won;t die if i remove the comment
from 4 lines of setting values into struct.
here is a snipcode
public System.Collections.Generic.List<frmMain.sDBTest>
LoadTestSet(string TestSetFile,
System.Collections.Generic.List<frmMain.sDBTestDBviewList)
|
by: DennisBetten |
last post by:
First of all, I need to give some credit to Mahesh Chand for providing me with an excellent basis to export data to excel.
What does this code do:
As the title says, this code is capable of extracting all tables and it's data from any given database! I was searching the net for a program like this, but I didn't come accross any (free) versions. So I decided to write it myself.
To get this code to work, you need to add a reference to...
|
by: randyse |
last post by:
Hello all,
This is my first post, please let me know if I've missed any relevant data or guidelines.
I'm using Access 2003 for the database and Excel 2003 for the reporting to avoid having everyone reading the reports install the snapshot viewer. I'm also porting this application to SQL Server/ASP.NET eventually, and there is not a way to install reporting services on the server, so my hope is to use Excel there as well.
I'm using two...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |