Populate only year from datetime data from accessto listview

Question

Hi All I tried many links but I am unable to find a solution. Request your expertise for the below queries: 1. I have a listbox where dates from the database are populated. I want only year to be displayed in the listbox. Please advise. 2. This is the current select statement : str = select partyname from casetab WHERE jdate=' +listJDate.SelectedItem.ToString() + '; How do I convert string to datetime in select statement so I can add in the listbox selectIndexChanged event. Please advise. -- NG

Nirmal G · Answer

I am unable to populate data to listview from database :( Below is my code: private void button1_Click_1(object sender EventArgs e) { OleDbConnection cs = new OleDbConnection(); cs.ConnectionString = (@Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\lms\ssc.accdb;); try { listView1.Items.Clear(); cs.Open(); OleDbCommand cmd = cs.CreateCommand(); //cmd.CommandText = (SELECT judgement FROM casetab WHERE partyname=' + listView1.SelectedItems.ToString() + '); cmd.CommandText = (SELECT judgement FROM casetab); OleDbDataReader dr = cmd.ExecuteReader(); ListViewItem itmX; while (dr.Read()) { itmX = new ListViewItem(); itmX.Text = dr.GetValue(0).ToString(); for (int i = 0; i { itmX.SubItems.Add(dr.GetValue(i).ToString()); } listView1.Items.Add(itmX); listView1.Items.Add(
); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cs.Close(); } }

Anurag Sarkar · Answer

Choose the format that is yyyy for year and dd-MM-yyyy for whole date and for month it will be MMM. listJdate.Selectteditem.TOstring(yyyy); Thanks.