I didn't understand your mean but if you say that I must explain for you
what persiancalender is .It begin from gerigorian 2/21/621 and each year
include 365 days and first six month of year has 31 days and five month of year has 30 days and the last month has 29 days after each three years last month of year will have 30 days.so I said it starts on march 21 .
But if you say I must define a persian calender and set into datetimeformat.calender I have done this and if I must show persiancalender in other way please tell me How.
I have a requirement to convert multiple XML files to Excel files using VBScript. I have used the below script to convert the XML files, but on creation of the Excel files I encouter this:
(a)The column names are getting created with the full path like "/Report/Answers/Answer/Answer"
(b)There are additional fields for aggregation like "/Report/Answers/Answer/Answer/#agg"
(c)The column names are displayed in the reverse order i.e. bottom to top level.
The Script is as mentioned below:
Dim xlApp, xlWkb, SourceFolder,TargetFolder,file
Set xlApp = CreateObject("excel.application")
set fs = CreateObject("Scripting.FileSystemObject")
xlApp.Visible = false
'Process each file in SourceFolder
for each file in fs.GetFolder(SourceFolder).files
'Open file in SourceFolder
Set xlWkb = xlApp.Workbooks.Open(file)
'Concatenate full path. Extension will be automatically added by Excel
FullTargetPath=TargetFolder & "\" & BaseName
'Save as XLS file into TargetFolder
xlWkb.SaveAs FullTargetPath, xlNormal
Set xlWkb = Nothing
Set xlApp = Nothing
Set fs = Nothing
Kindly let me know your inputs to modify the code to display the column names alone and also to remove the agg columns that are generated.
Recently i build a small application for generate report from Sybase Anywhere. I build it in visual studio 2010 with VB.NET and use rdlc file to display report. I has a receipt printer which connect to PC by serial port.
I want to send image file such bitmap or jpg ...and if possible, i'd like to send pdf file to this printer by click on a button to print directly to printer without show printdialog. I want to send print command directly to printer and without put printer name in code also.
So please kindly to help me. Thank you advanced for all answers.
You only need the print dialog to allow the user to make choices about which printer to use, paper size, number of copies etc. If you want to do it direct then you just need to set all the relevant parameters in your program. As to driving the printer directly through the serial port, you need to get a copy of the printer's technical documentation to see what commands to send it and what format the data is required to be in, e.g raw, postscript etc.
I need to be able to book email jobs, and have an app run the jobs on the date and time required.
All my web servers are server 2012 core, with minimum GUI for now.
Back a couple of years ago, I would of just wrote the program as an Windows App.
I was wondering if technology wise and if my skills are good enough, if it's possible to write a windows service that will check a SQL server database for email jobs, and do the work.
I see Windows Store Apps in Visual Studio, but I'm not to sure about it.
I guess a a service, I can't connect to it to query it for data or statistics, and I would have to rely upon the database for that information, so the web application can book the jobs and access the results.
The Windows Task Scheduler is almost certainly the way to go. Write a console application to check the database, process any outstanding jobs, and then exit. You can then schedule it to run using the schtasks command[^] (or the GUI, if it's available in Server Core).
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer