I download the CaptureAndPrintMSChart project (http://www.codeproject.com/KB/cpp/capture\_and\_print\_mschart.aspx) & tried, the MsChart working fine but when I try to print, I have the error MSChart.EditCopy(); **Bitmap chartCapture = (Bitmap) Clipboard.GetDataObject().GetData("Bitmap", true);** chartCapture.Save("Image.Jpeg"); - The error says that: The ExecutionEngineException was unhandled By the way, I use the Visual Studio 2005 (Prof.), I think that is the reason (it did converted before I ran the project) Can someone show me how to modify it? Thank for any help :doh:

modified on Friday, October 24, 2008 3:48 PM

In VB.net when we define DaySel as: Dim DaySel As Date then when we use the command totaldays = DaySel.DaysInMonth(DaySel.Year, DaySel.Month) it will response the corresponding days of the selected month (28 or 29 or 30 or 31 days) However when I define in VC# System.DateTime DaySel = default(System.DateTime); - I only can get DaySel.DayOfWeek or DaySel.DayOfYear Anyone can show me how to get the total days of the selected month? Thank for nay help :doh:

Unfortunately I had MS Access database instead, but when I used VB.net then I defined Decimal type is OK! Also I can not re-define the database differently, because other applications are still using them (VC++) Any new suggestion? Thank

I have to get the price (currency) from a database table, but I can not assign double & Decimal variable to it, which define type I should use?

I did try & have small error from Item, but I think I can fix it by using array for the column. Thanks,

I did try before & had 2 errors: cnt = dt.Rows.Count; DataRow rows = default(DataRow); foreach (DataRow rows in dt.Rows) Total += rows.Item("Total"); By any chance you know how to fix them? What I need to get values from column 'Total' of those selected row Thanks :doh:

I have the following VB.net codes: da = New OleDbDataAdapter(strSQL, dbConn) dt = New DataTable da.Fill(dt) Dim rows As DataRow cnt = dt.Rows.Count() If cnt > 0 Then For Each rows In dt.Rows Total += rows.Item("Total") Next End If I changed to these C#: da = new OleDbDataAdapter(strSQL, CGlobal.dbConn); dt = new DataTable(); da.Fill(dt); cnt = dt.Rows.Count; DataRow rows = default(DataRow); if (cnt > 0) { foreach (rows in dt.Rows) Total += rows.Item("Total"); } And I have the error in in above, can anyone help to correct my C#? Thank :doh:

I have to use HTM form instead of ASP script, there is an input <% If VerifyPending = true Then %> <% Else %> <% End If %> In my HTM it does not accept <% to insert VB script 1. Do I need include some thing to make the HTM accept the above VB script? 2. If not how can I convert into HTM form? Note: VerifyPending is VB script only use to return TRUE or FALSE, FormatDate is a VB script to return a new Date Thank to any help :doh:

Please see the comments on Can I use VB.net and XML to read/write a MS access database in the web-site? about 2 pages after this page. I post 2 questions because the first one I mentioned about using XML ... but what I try to find out which is the best way to write/read MS Access database in my Web-host! How do you think?

Thanks for detail explains, I think I have to change our approaches and start the way as you suggested Thanks :)

I have web-pages & MS Access database in my web-host (http://www....), is there easy way to use VB.net to access it without using FTP? If possible, please provide valid links or sample codes. Thanks :doh:

- 4 years ago, my friends said that using XML to access information directly through the Web is much better than using program (FTP) to download files (read information) then upload files (write information). - In my question, I did mention that XML does not access directly to MS Access database, but through an .ASP file. In that ASP file, the Request XML commands will be handled and it will connect to MS Accesss database to read/write information ... then it will Response back to the Client I hope that I explain mt question well enough. There might be a better way to access data trhough the WEB without Download/Upload files through FTP?

Let say I have a web-site http://www.TrialXML.com, in that site I have a folder \database and my MS Access database file Trial.mdb having a table Purchasing and having 2 columns: Part & Value In the main folder (www), I do have the Link_XML.asp that can handle XML (Reponse & Request) will be used from the Client to access the Trial.mdb Is there any sample codes or links that I can use to write code in VB.net using XMLDOM to read/write data to the Trial.mdb through Link_XML.asp? Thanks in advanced, :doh:

It works Many thanks :-D

Can someone show me how to copy an existed Excel file (ie: c:\temp\oldFile.xls) to a new Excel file (ie: c:\temp\newFile.xls)? Thank in-advanced :doh:

Hi Dave, It works! I am awared of your comments, however the existed files that has columns with spaces being done long time ago & I am not allow to remove spaces Many thanks :-D

I am able to use SQL commands to access any table & any columns in MS access (or in Excel) table. However, when I try to search columns with spaces (ie: Employee IDNumber, Employee Name, ...) then I have errors If I change to Employee_IDNumber, Employee_Name then it is OK Dim m_sModification As String = "UPDATE [Table Name$] SET Employee_Name = 'Jonny White' WHERE Employee_IDNumber = '12345678'" Dim conn1 As New System.Data.OleDb.OleDbConnection(m_sConnection1) conn1.Open() But I have the MS Access (or Excel) tables having Column Headers with spaces between, I try to avoid changing all of them with xxxxx**_**xxxxx Do we have other ways to deal with this issue? Thank in-advanced :doh:

modified on Thursday, April 3, 2008 10:34 AM

Thank for the explaination, now I know why it has not work! Would you kindly provide some links to use the Excel object model. I appreciate a lot! Many thanks

I am able to create a table with some columns in an Excel file & I can add or read data from those columns. But when I try to add a new column (NewInfo) with the following codes ... I had an error "Invalid operation" after line cmd.CommandText = "ALTER TABLE ..." Dim conn1 As New System.Data.OleDb.OleDbConnection(m_sConn1) conn1.Open() Dim cmd As New System.Data.OleDb.OleDbCommand() cmd.Connection = conn1 cmd.CommandText = "ALTER TABLE EmployeeData ADD NewInfo VARCHAR(20) NULL" cmd.ExecuteNonQuery() conn1.Close() Might someone show me what is wrong? Thank in-advance :confused:

Hi Dave, Thank for the link, I am able to do what I posted Thank for help :-D