Populate only year from datetime data from accessto listview

Nirmal G

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

2 Replies

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

Nirmal G13y ago
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 < dr.FieldCount; i++)
{
itmX.SubItems.Add(dr.GetValue(i).ToString());
}

listView1.Items.Add(itmX);
listView1.Items.Add("\n");
}



}

catch (Exception ex)
{
MessageBox.Show(ex.Message);

}
finally
{
cs.Close();
}
}
0
Anurag Sarkar13y ago
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.
0