|
Is possible showing persian date in datagridview which connected to an sql
database ?
if there is any way please help me
majid
|
|
|
|
|
Sure, where are you stuck?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I get data with following code from a table which contains a date type field :
con = New SqlConnection("server=(local);database=pers;Trusted_Connection=True;")
con.Open()
datd = New SqlDataAdapter("select * from perInfo ", con)
datd.Fill(ds, "perInfo")
DataGridView1.DataSource = ds.Tables("perInfo")
I have my date type field shown in gerigorian but I want to display it in persian date in my datadridview.
what I must to do to convert this gerigorian date to persian date in my
datagridview?
thanks
majid eskandarian
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
What is the error?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
error is in second line and say
"not a valid calender for the given culture"
"parameter name: value"
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
|
|
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 
If you can't read my code, try converting it here[^]
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
What do you think?
modified 16-Jul-14 13:58pm.
|
|
|
|
|
Yes you can write this as a service or you can write it as a Console application and run it from Scheduled Tasks.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
A web-service or a windows-service? The latter should not display a UI.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
