How we can get only date from SQL table

Question

0.00/5 (No votes)

See more:

i select the table data from SQL server using store procedure and load this data to my C# application that containing a GridView. It take Alos time with data but in gridview Only date is shown And when i take a print of this gridview 12:00 this time Also include in date colum in printpriview..
Colume name "EmDate" datatype "Datetime"
I want only date is print.
Please Any one Help me.
Thanks in advance

What I have tried:

Its My Store Procedure

ALTER PROCEDURE [dbo].[USP_Selec_Custtomer_Record] 
AS
BEGIN
	SELECT 
	   [CustomSr]			as 'sr'
	 , DateWork = CONVERT(date, DateWork, 103)		      
      ,[EmpolyName]			as 'Empoly Name'
      ,[EmID]				as 'Empoly ID'
      ,[CustomerName]		as 'Customer Name'
      ,[PhoneNo]			as 'Phone No '
      ,[CustomAddress]		as 'Customer Address'
      ,[CashType]			as 'Cash Type'
      ,[LumSum]				as 'LumSum Amount'
      ,[TotalToPay]			as 'Total to pay'
      ,[RemainingBalnce]	as 'Remaining Amount'
  FROM [dbo].[Customer_Records]

Its my C# Code i use Print Document Control to take Print. This line take print of Date.

e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[1].Value.ToString(), new Font("Arial", 16), Brushes.Black, 120, ysp);

Posted 16-Mar-18 17:57pm

Fahid Zahoor

Updated 17-Mar-18 19:23pm

Add a Solution

Comments

Bryian Tan 17-Mar-18 0:07am

is EmDate refering to DateWork column?

Fahid Zahoor 17-Mar-18 1:42am

Yes

Bryian Tan 17-Mar-18 1:56am

Can the DateWork be string on the application side? if yes, try something like

DateWork = convert(VARCHAR(10), DateWork, 103)

or return a new column StrDateWork = ...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-03-16T21:02:00

Solution 1

Don't convert it at all in SQL - return the whole DATETIME value, then process it in your presentation language:

decimal d = (decimal) CustomerDetilsdataGridView.Rows[i].Cells[1].Value;
e.Graphics.DrawString(d.ToString("dd/MM/yyyy"), new Font("Arial", 16), Brushes.Black, 120, ysp);

Or

decimal d = (decimal) CustomerDetilsdataGridView.Rows[i].Cells[1].Value;
e.Graphics.DrawString(d.ToString("d"), new Font("Arial", 16), Brushes.Black, 120, ysp);

which will give you the short form date fro that computer's locale.

Posted 16-Mar-18 21:02pm

OriginalGriff

Updated 16-Mar-18 23:35pm

v2

Comments

Fahid Zahoor 17-Mar-18 5:22am

This error is occuer and ToString underLine By read color line
"Return a string that represent the current object. No over Load for method ToString takes 1 Arguments"
Tell me what i do next???

OriginalGriff 17-Mar-18 5:28am

Show me exactly the code you used.

Fahid Zahoor 17-Mar-18 14:42pm

if (NumberOfItemPrintedSoFar <= CustomerDetilsdataGridView.Rows.Count)
{

e.Graphics.DrawString(""+p, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, new Point(23, ysp));
// e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[0].Value.ToString(), new Font("Arial", 16), Brushes.Black, 23, ysp);
e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[1].Value.ToString() , new Font("Arial", 16), Brushes.Black, 120, ysp);
//e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[3].Value.ToString(), new Font("Arial", 16), Brushes.Black, 330, ysp);
e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[4].Value.ToString(), new Font("Arial", 16), Brushes.Black, 440, ysp);
e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[9].Value.ToString(), new Font("Arial", 16), Brushes.Black, 640, ysp);
ysp += 30;
p++;
}

OriginalGriff 17-Mar-18 5:34am

Ah! You're using a DataGridView - answer updated.

Fahid Zahoor 17-Mar-18 10:52am

Yes I'm Using Data GridView

dkamble 10358990 · Answer 2 · 2018-03-17T19:24:00

Solution 2

CONVERT(nvarchar(10), DateWork, 103);

Posted 17-Mar-18 19:24pm

dkamble 10358990

Comments

Fahid Zahoor 18-Mar-18 2:09am

Yes I'm using this. Now Paroblem is that only Date is Shown in GridView But when i take the print 12:00 this Time is also add to all the records...