date to be saved in the format of date month in data base.

Question

Saving the record into data base from data grid view.in that date to be saved in the format of date month in data base.

code as follows;

sql = "insert into Tb_SCh_TIme_Table(Date,Session,Course,Faculty_Code)" + " values ('" + Convert.ToDateTime(datagridView.Rows[i].Cells[0].Value.ToString()) + "', '" + int.Parse(datagridView.Rows[i].Cells[1].Value.ToString()) + "', '" + datagridView[j, i].Value.ToString() + "','" + datagridView.Columns[j].HeaderText.ToString() + "')";

through the above query it is saving to the data base.

in database Date is stored in the format such as 1/7/2013 12:00:00 AM.

but i want the the date to be stored in the format of 1 jan only.

the above format of date and month(Month to be character format)

Convert.ToDateTime(datagridView.Rows[i].Cells[0].Value.ToString()

Saving the record into database from data grid view using csharp

from the above query how to do.

output as follows;

Date
1 jan
8 jan
3 Feb

like that to be saved in the data base.

how to do.please help me.

Nitin Dhiman · Answer

Use this in your query. SELECT (CONVERT(VARCHAR(4)DATEPART(DAY GETDATE()))+' '+ DATENAME(month getdate())) AS DATE

Sudhakar Chaudhary · Answer

private void button1_Click(object sender EventArgs e) { string date = dataGridView1.Rows[0].Cells[0].Value.ToString(); DateTime dt =StringToDate( date); string moth_year = dt.ToString(ddMMM); MessageBox.Show(moth_year); } public static DateTime StringToDate(string value) { IFormatProvider formatProvider = new CultureInfo(en-GB); DateTime dt = DateTime.Parse(value formatProvider); return dt; }