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

narasiman rao

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Dhiman13y ago
Use this in your query.

SELECT (CONVERT(VARCHAR(4),DATEPART(DAY, GETDATE()))+' '+ DATENAME(month, getdate())) AS DATE
0
Sudhakar Chaudhary13y ago
       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;
        }
0