Hi All,

    I encountered some problems, See details below:

how get date in c# dateTimePicker control,i need date only.such as:2011-10-15 (yyyy-month-day).

Can not immediately update the data in treeView1_NodeMouseClick event.

see code below:

private void treeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            dataGridView1.DataSource = "";  
         try
            {
              
                string AccessAddress = System.IO.Path.GetFullPath("PSRecord.mdb");
                //con = new OleDbConnection(@"provider=microsoft.ace.oledb.12.0;persist securityInfo=false;data source=" + AccessAddress);
                con = new OleDbConnection(@"provider=microsoft.jet.oledb.4.0;data source=" + AccessAddress);
                con.Open();
                cmd = new OleDbCommand("select * from Record  where driver='" + treeView1.SelectedNode.Text.ToString() + "'", con);
                ds = new DataSet();
                adapter = new OleDbDataAdapter(cmd);
                adapter.Fill(ds);
                dataGridView1.DataSource = ds.Tables[0];

            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.ToString());
            }
            finally
            {
                con.Close();
            }
        }

i need help now,Thanks!