Hi!!!
convert the dropdownlist selected value
like
DateTime dt;
dt = Convert.ToDateTime(ddl.selectedvalue)";
void ddlfunction()
{
confunction();//your connectionstring
con.Open();
MySqlCommand cmd = new MySqlCommand("select PurchaseCode from tblPurchasedInfo where VendorCode='" + vcode + "' and BillNo='" + ddlBillNo.SelectedValue + "' and PurchaseDate='" + dt + "'";)", con);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ddl.Items.Add(dr["Column_Name"].ToString());
}
con.Close();
I write this code in notepad so make correction on it!!