how to remove time portion from the date field in the print preview page

Question

0.00/5 (No votes)

See more:

hello,

in my application i wanted to print the contents of a data gridview which contains some columns like name, address,date etc...so for taking print i am using print document option and all the fields are coming in the print preview page also, but the problem is in the date field dates are coming along with a system generated time like 1988-02-05 12:0000AM, i wanted to avoid this time portion what is the solution for that in the grid view it is 1988-02-05 only at the time of printing only it is coming like that

Thanks
Ginnas

Posted 18-Apr-13 23:22pm

ginnas

Add a Solution

Comments

CHill60 19-Apr-13 5:43am

How are you populating the cells that contain a datetime on the datagridview? If you format them correctly first they should appear in the preview in that format

4 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)

tumbledDown2earth · Answer 1 · 2013-04-19T03:27:00

Solution 1

for formtting the string you can use DateTime.ToShortDateString();

Posted 19-Apr-13 3:27am

tumbledDown2earth

Comments

ginnas 19-Apr-13 10:12am

thanks

here the problem only at the time of displaying in the print preview page,in the database and in the grid view and all displaying in correct format

Regards
Ginnas

Sisir Patro · Answer 2 · 2013-04-19T04:26:00

Solution 2

HI,

Use the string.Format() or variable.Tostring("dd/mm/yyyy");

This will help you...
Thanks

Posted 19-Apr-13 4:26am

Sisir Patro

Ganesh Kumar007 · Answer 3 · 2013-12-07T22:59:00

Hi Ginnas,

I have added comments for you to understand the Code well .

Before binding it to the Grid View or Data Grid
// Get Clone of Data (only structure)

C#

   DataTable mydt = dt.Clone();

          //Convert the datetime column to string
          foreach (DataColumn column in mydt.Columns)
          {
              if (column.DataType == typeof(System.DateTime))
              {
                  column.DataType = typeof(System.String);
              }
          }

          //copy the data iterating through row and column
          for (int i = 0; i < dt.Rows.Count; i++)
          {
              // Add a new data row
              DataRow dr = mydt.NewRow();
              for (int j = 0; j < dt.Columns.Count; j++)
              {
                  //if not datetime copy directly
                  if (dt.Columns[j].DataType != typeof(System.DateTime))
                  {
                      dr[j] = dt.Rows[i][j];
                  }

//if datetime convert to string, split by ' ' and get the first element of the resulting array.
                  else
                  {
                      dr[j] = Convert.ToString(Convert.ToString(dt.Rows[i][j]).Split(' ')[0]);
                  }
              }
              // add data row to the table
              mydt.Rows.Add(dr);

              mydt.AcceptChanges();
          }



          GridView1.DataSource = mydt;

joginder-banger · Answer 4 · 2013-12-07T23:21:00

Solution 4

You can also changed format of time like that DateTime.Now.ToString("yyyy/dd/mm");

DateTime.Now.ToString("dd/mm/yyyy");

Posted 7-Dec-13 23:21pm

joginder-banger