string da=datePicker1.SelectedDate.ToString().Split(' ')[0];
//MessageBox.Show(da);
string dat = da.Split('/')[1];
if (dat.Length == 1)
{
dat = "0" + dat;
}
string y = da.Split('/')[2];
string mont = null;
int mon = int.Parse(da.Split('/')[0]);
switch (mon)
{
case 1:
mont = "Jan";
break;
case 2:
mont = "Feb";
break;
case 3:
mont = "Mar";
break;
case 4:
mont = "Apr";
break;
case 5:
mont = "May";
break;
case 6:
mont = "Jun";
break;
case 7:
mont = "Jul";
break;
case 8:
mont = "Aug";
break;
case 9:
mont = "Sep";
break;
case 10:
mont = "Oct";
break;
case 11:
mont = "Nov";
break;
case 12:
mont = "Dec";
break;
}
char[] y1 = y.ToCharArray();
string y2 = y1[2].ToString() + y1[3].ToString();
string daSearch = dat + "-" + mont + "-" + y2;