how to use this tools print prieview, print setup, print ,date time picker

Question

4.00/5 (1 vote)

See more:

dear sir i want to printprieview ,the selected items from data grid view and also to print the selcted items with title provided by me and date i have searched lots of querry showing this results but they very much confusing ,and another thing is that i have use datetimepicker for selecting date but when i select the date and when date is saved its in dd-mm-yyyy hh-mm-ss so when i searched in output usng date no records are found bcoz it searches date which is in string format i want to use date in my form with only dd-mm-yyyy values stored
i have written commands in sql for date is {[DATE] [nvarchar](40) NULL,}and in c# i am binding date as

C#

{
   dateTimePicker1.DataBindings.Clear();
   dateTimePicker1.DataBindings.Add("Text", dv, "DATE");
}

for save date on save button

C#

{
cmd = new SqlCommand("insert into REGISTRY values(@CUSTUMER,@DATE)",con);
cmd.Parameters.Add("@DATE", SqlDbType.NVarChar, 20);
cmd.Parameters["@DATE"].Value = dateTimePicker1.Value;
}

please it would be very great if you help me i am new to software programing and i am getting how to solve it.

Posted 4-Aug-12 20:25pm

adnanhakim110

Updated 4-Aug-12 21:05pm

Tarun Mangukiya

v2

Add a Solution

Comments

Christian Graus 5-Aug-12 2:40am

If you're new to software programming, and you want to be a programmer, learn C# properly before you start to worry about things like SQL and printing. If you ask enough questions here, you can probably cobble together some code that runs, although you won't understand it. That's not the path to being a programmer.

adnanhakim110 5-Aug-12 3:03am

sir i know the c# language but sir there are some silly mistakes and some lack of exprience thats why i connected to codeproject for gaining the information from the senior developers ,iknow code for print preview and print setup but i want to prnt from data grid view wch is not happening

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)

Tarun Mangukiya · Answer 1 · 2012-08-04T20:52:00

Solution 1

I think that you can use this.

C#

cmd.Parameters["@DATE"].Value = String.Format("dd-mm-yyyy",dateTimePicker1.Value);

And read more about SQL and Strings. It will help you...

Thanks.

Posted 4-Aug-12 20:52pm

Tarun Mangukiya

Comments

adnanhakim110 14-Aug-12 2:09am

thank you sir for your help but sir i have tried the code but sir instead of saving the date in dd-mm-yyyy format the the the data only shows dd-mm-yy which is in ""in your answer no date is saved

Tarun Mangukiya 14-Aug-12 9:13am

Try this answer:
http://www.codeproject.com/Questions/188662/how-to-insert-date-in-SQL-SERVER-2008-using-C-NET

It is solved...

Tarun Mangukiya · Answer 2 · 2012-08-04T21:02:00

Solution 2

For Print and PrintPreview you can refer this articles...

Basic Text and Image Printing[^]

And

DataGridView Print/Print Preview Solution - Part II[^]

They will help you.

Thanks.

Posted 4-Aug-12 21:02pm

Tarun Mangukiya