date format changing to nov 16 2014 instead of 16, November, 2014

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");
}