if you are saving Date as string/varchar in the database, first you better change the column type to Date or DateTime. then you can declare parameter as below
SqlCmd.Parameters.Add("@ZDATE_LOAN", System.Data.SqlDbType.DateTime);
since you have DateTime parameter now
SqlCmd.Parameters["@ZDATE_LOAN"].Value
will be a DateTime value or null value. you better check for null first and then call
SqlCmd.Parameters["@ZDATE_LOAN"].Value.ToString("MMMM, dd, yyyy")
to take the formatted string output of returned date.
if you can't change the database column type, then
SqlCmd.Parameters["@ZDATE_LOAN"].Value
having string value of DateTime. You can do string manipulation and build the required datetime string like below
string inputdate = "16, November, 2014";
string[] dateParts =inputdate.Split(',');
if(dateParts.Length ==3)
{
string formatedDateString =string.Format("{0}, {1}, {2}", dateParts[1].Trim(), dateParts[0].Trim(),dateParts[2].Trim());
}
But rather than string manipulation I recommend you to convert string to datetime first and then call ToString method with the format which needed. But you need to use DateTime.TryParseExact or DateTime.ParseExact with correct date time format which you have store in the database. for example if you save dates in the format of dd, MMMM, yyyy then
DateTime result;
if (DateTime.TryParseExact(str,"dd, MMMM, yyyy",CultureInfo.InvariantCulture,DateTimeStyles.None,out result)){
string formatedDateString =result.ToString("MMMM, dd, yyyy");
}