Visual Basic

Re: showing persian date in datagridview when programming by vb.net 2005

18-Jul-14 10:35

The "proper" way is to set the CultureInfo of the thread. Just google CultureInfo and .Net.

There are only 10 types of people in the world, those who understand binary and those who don't.

majid eskandarian18-Jul-14 11:31

Re: showing persian date in datagridview when programming by vb.net 2005

18-Jul-14 11:31

I do what you say by following code :

con = New SqlConnection("server=(local);database=pers;Trusted_Connection=True;")
            con.Open()
            Me.datd = New SqlDataAdapter("select * from perInfo", con)

            Dim commandBuilder As New SqlCommandBuilder(Me.datd)

            Dim table As New DataTable()
            table.Locale = System.Globalization.CultureInfo.InvariantCulture
            Me.datd.Fill(table)
            Me.bindingsource1.DataSource = table
            Me.DataGridView1.DataSource = Me.bindingsource1

but yet didn't work.

modified 18-Jul-14 17:40pm.

ZurdoDev18-Jul-14 11:38

Re: showing persian date in datagridview when programming by vb.net 2005

18-Jul-14 11:38

No, the thread. See, http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.currentculture(v=vs.110).aspx[^]

There are only 10 types of people in the world, those who understand binary and those who don't.

majid eskandarian18-Jul-14 14:52

Re: showing persian date in datagridview when programming by vb.net 2005

18-Jul-14 14:52

hi I use following code and it's works when I use hijri or any other calender but when I use it for persian calender it has runtime error:

Dim defCult As CultureInfo = CultureInfo.CreateSpecificCulture("fa-IR")
       defCult.DateTimeFormat.Calendar = New PersianCalendar
       Thread.CurrentThread.CurrentCulture = defCult
       Thread.CurrentThread.CurrentUICulture = defCult
       Try
           con = New SqlConnection("server=(local);database=pers;Trusted_Connection=True;")
           con.Open()
           Me.datd = New SqlDataAdapter("select * from perInfo", con)

           Dim commandBuilder As New SqlCommandBuilder(Me.datd)
           Dim table As New DataTable()
           table.Locale = System.Globalization.CultureInfo.InvariantCulture
           Me.datd.Fill(table)
           Me.bindingsource1.DataSource = table
           Me.DataGridView1.DataSource = Me.bindingsource1

can any body help me?

modified 18-Jul-14 20:59pm.

ZurdoDev18-Jul-14 15:49

Re: showing persian date in datagridview when programming by vb.net 2005

18-Jul-14 15:49

What is the error?

There are only 10 types of people in the world, those who understand binary and those who don't.

majid eskandarian18-Jul-14 20:55

Re: showing persian date in datagridview when programming by vb.net 2005

18-Jul-14 20:55

error is in second line and say
"not a valid calender for the given culture"
"parameter name: value"

ZurdoDev19-Jul-14 2:43

Re: showing persian date in datagridview when programming by vb.net 2005

19-Jul-14 2:43

You haven't shown what PersianCalendar is so you'll need to debug it.

There are only 10 types of people in the world, those who understand binary and those who don't.

majid eskandarian20-Jul-14 3:09

Re: showing persian date in datagridview when programming by vb.net 2005

20-Jul-14 3:09

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.
thanks

Richard MacCutchan20-Jul-14 7:07

Richard MacCutchan

20-Jul-14 7:07

You should read the notes in http://msdn.microsoft.com/en-us/library/system.globalization.persiancalendar(v=vs.110).aspx[^], which describe how to use (and more importantly, how not to use) the Persian Calendar in .NET.

Re: showing persian date in datagridview when programming by vb.net 2005

ZurdoDev20-Jul-14 10:31

Re: showing persian date in datagridview when programming by vb.net 2005

20-Jul-14 10:31

http://social.msdn.microsoft.com/Forums/vstudio/en-US/4768d48e-aa04-4c15-b688-a58fa4373bc9/persiancalendar-as-currentculture?forum=netfxbcl[^]

See if this helps you get through it.

There are only 10 types of people in the world, those who understand binary and those who don't.

Eddy Vluggen18-Jul-14 5:15

Eddy Vluggen

18-Jul-14 5:15

Member 10954619 wrote:
Is possible

Yes.

Member 10954619 wrote:
if there is any way please help me

With which piece exactly? Do you already have the code to load "some" data into a grid? If not, then you might want to start with the documentation[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: showing persian date in datagridview when programming by vb.net 2005

ZinsatPak27-Jul-14 23:46

ZinsatPak

27-Jul-14 23:46

Try with something like this with link query:

var persianDates = (from f in db.Fadb
select new PersianDateTime(f.date)).ToList();

so , u can convert from date to persian date in your gridview.

how to covert multiple XML files to Excel Files using VB Script

prevase17-Jul-14 23:22

prevase

17-Jul-14 23:22

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")
Const xlNormal=1
SourceFolder="c:\temp\XMLfiles"
TargetFolder="c:\temp\XLSfiles"

'Hide Excel
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)
'Get Filename
BaseName= fs.getbasename(file)
'Concatenate full path. Extension will be automatically added by Excel
FullTargetPath=TargetFolder & "\" & BaseName
'Save as XLS file into TargetFolder
xlWkb.SaveAs FullTargetPath, xlNormal
'Close file
xlWkb.close
next

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.

print a file via serial port printer without print dialog

Member 1030446816-Jul-14 16:44

Member 10304468

16-Jul-14 16:44

Dear all members,

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.

Re: print a file via serial port printer without print dialog

Richard MacCutchan16-Jul-14 22:48

Richard MacCutchan

16-Jul-14 22:48

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.

build a windows service in vb to run on server core 2012 with minimum GUI

jkirkerx16-Jul-14 7:41

Re: build a service in vb to run on server core 2012 with minimum GUI

16-Jul-14 7:41

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.

What do you think?

modified 16-Jul-14 13:58pm.

Dave Kreskowiak16-Jul-14 7:48

Dave Kreskowiak

16-Jul-14 7:48

Yes you can write this as a service or you can write it as a Console application and run it from Scheduled Tasks.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: build a service in vb to run on server core 2012 with minimum GUI

jkirkerx16-Jul-14 7:55

Re: build a service in vb to run on server core 2012 with minimum GUI

16-Jul-14 7:55

That was fast!

Thanks for the confirmation.

I'll give the service a try first and see how it goes.
So I guess I am planning this correctly by using the database as a central place to store jobs and results.

Now I can quote the job. Thanks

PIEBALDconsult16-Jul-14 7:53

PIEBALDconsult

16-Jul-14 7:53

Yeah, what Dave said, or do it all within Sql Server -- an agent job that executes an SSIS package.

You'll never get very far if all you do is follow instructions.

Re: build a service in vb to run on server core 2012 with minimum GUI

jkirkerx16-Jul-14 8:06

Re: build a service in vb to run on server core 2012 with minimum GUI

16-Jul-14 8:06

SSIS Package sounds complicated. I need to read up on that first, I did 5 minutes on it just now.

Would that help me with finding the connection string for the SQL Server? since this is a centralized service or console app. And the mail server coordinates.

I guess that's my next question or questions.

Thanks for the confirmation

PIEBALDconsult16-Jul-14 8:26

PIEBALDconsult

16-Jul-14 8:26

jkirkerx wrote:
finding the connection string for the SQL Server

It would be running within the Sql Server instance, so that would not be an issue.

jkirkerx wrote:
And the mail server coordinates

You can make that configurable.

jkirkerx wrote:
SSIS Package sounds complicated

They can be, but what you need may be very simple -- it could be as simple as having it execute a stored procedure in the database.

You'll never get very far if all you do is follow instructions.

Re: build a service in vb to run on server core 2012 with minimum GUI

Eddy Vluggen16-Jul-14 7:55

Eddy Vluggen

16-Jul-14 7:55

A web-service or a windows-service? The latter should not display a UI.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: build a service in vb to run on server core 2012 with minimum GUI

jkirkerx16-Jul-14 7:58