datagridvew date format issue

Question

0.00/5 (No votes)

See more:

I want that from my datagridview only the date should pass from expiry date column to the database.but with the date.time is also going.And in database data type of that column is datatime.and on form i am converting that column value to string format........so please help me out with this problem

Posted 11-Mar-12 4:47am

thakurajay93

Add a Solution

2 solutions

Solution 2

The DataGridView does not have a DateTime column. But a DateTimePicker control can be hosted in DataGridView cell. An example is given here

http://msdn.microsoft.com/en-us/library/7tas5c80.aspx[^]

In this example in the constructor of CalenderCell the Format of DataTime is set to short date format.

C#

public CalendarCell()
: base()
{
    // Use the short date format.
    this.Style.Format = "d";
}

Posted 11-Mar-12 16:35pm

ProEnggSoft

Comments

thakurajay93 12-Mar-12 1:24am

thanks again for the help.But not getting properly.so i have pasted the code ..

private void button3_Click(object sender, EventArgs e)
{
string prodname = null,pack = null,md = null,ed = null,batchno = null,per = null;
double mrp = 0.0d,rate = 0.0d,tamt = 0.0d;
int aq = 0, bq = 0;
SqlConnection conn = new SqlConnection();
connection obj = new connection();
conn.ConnectionString = obj.getconnstring();
SqlDataReader rdr = null;
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
prodname = Convert.ToString(dataGridView1.Rows[i].Cells[0].Value);
pack = Convert.ToString(dataGridView1.Rows[i].Cells[1].Value);
mrp = Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value);
md = Convert.ToString(dataGridView1.Rows[i].Cells[3].Value);
ed = Convert.ToString(dataGridView1.Rows[i].Cells[4].Value);
batchno = Convert.ToString(dataGridView1.Rows[i].Cells[5].Value);
aq = Convert.ToInt32(dataGridView1.Rows[i].Cells[6].Value);
bq = Convert.ToInt32(dataGridView1.Rows[i].Cells[7].Value);
rate = Convert.ToDouble(dataGridView1.Rows[i].Cells[8].Value);
per = Convert.ToString(dataGridView1.Rows[i].Cells[9].Value);
tamt = Convert.ToDouble(dataGridView1.Rows[i].Cells[10].Value);

try
{
conn.Open();
SqlCommand cmd = new SqlCommand("Insert into sales_order values('" + clientid + "','" + textBox3.Text + "','" + textBox5.Text + "','" + dateTimePicker2.Value + "','" + textBox8.Text + "','" + prodname + "','" + pack + "','" + mrp + "','" + md + "','" + ed + "','" + batchno + "','" + aq + "','" + bq + "','" + rate + "','" + per + "','" + tamt + "')", conn);
SqlCommand cmd1 = new SqlCommand("insert into Grand_total_client values('" + clientid + "','" + textBox3.Text+"','"+textBox11.Text+"','"+textBox10.Text+"')", conn);
SqlCommand cmd2 = new SqlCommand("update stock set qty = qty - " + aq + " where batch_no = '" + batchno+"'", conn);
SqlCommand cmd3 = new SqlCommand("delete from stock where qty=0", conn);
cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cmd3.ExecuteNonQuery();

}
//catch (Exception e1) { }
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
MessageBox.Show("Data updated Successfully", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
if (this.dataGridView1.DataSource != null)
{
this.dataGridView1.DataSource = null;
}
else
{
this.dataGridView1.Rows.Clear();
}
}
}

thakurajay93 12-Mar-12 1:25am

md and ed are the expiry date manufacture date

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)

ProEnggSoft · Accepted Answer · 2012-03-11T05:34:00

The .NET DateTime structure stores both the Date and Time as given on http://msdn.microsoft.com[^]
"the DateTime value type represents dates and times with values ranging from 12:00:00 midnight, January 1, 0001 Anno Domini"
Similarly the DataBase DateTime type also stores both Date, Time.

It is only the format in which you want to display in TextBox, DataGridView, etc. for which you can use one of the format specifier to show the Date, as shown here

http://msdn.microsoft.com/en-us/library/system.globalization.datetimeformatinfo.shortdatepattern(v=vs.80).aspx[^]