public DataTable Date_Select_ByDate(String vendorName,String d1,String d2)
{
DateTime D1=Convert.ToDateTime(d1);
DateTime D2=Convert.ToDateTime(d2);
DB_Connection();
DataSet DS = new DataSet();
string Date_All = "";
Date_All = "SELECT VendorName,CONVERT(char(10),OrderDate, 103) AS OrderDate,CONVERT(char(10),OrdDate, 103) AS OrdDate FROM Lib_selectperioprintdetails where VendorName='"+vendorName+"' OrderDate between '" + D1 + "' and '" + D2 + "'";
SqlDataAdapter DA = new SqlDataAdapter(Date_All, con);
DA.Fill(DS);
DataTable DT = DS.Tables[0];
return DT;
}