HAVE THIS ERROR.
Pls assist to correct
string str;
str = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(str);
string intno;
intno = GridView1.SelectedRow.Cells[1].Text;
SqlCommand SqlCmd = new SqlCommand("sp_GetDisbursed", sqlcon);
SqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ZAPPRAISAL", intno);
SqlCmd.Parameters.Add("@ZACCT1", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZACCT1"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZACCT2", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZACCT2"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZACTUAL_DISB", System.Data.SqlDbType.Money);
SqlCmd.Parameters["@ZACTUAL_DISB"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZAMT_APPRVED", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZAMT_APPRVED"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZBANK1", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZBANK1"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZBANK2", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZBANK2"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZBENEFICIARY", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZBENEFICIARY"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZBRANCH_CODE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZBRANCH_CODE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZBRANCH_NAME", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZBRANCH_NAME"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZCREDIT_OFFICER", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZCREDIT_OFFICER"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZCURRENCY", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZCURRENCY"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZDATE_DISB", System.Data.SqlDbType.DateTime);
SqlCmd.Parameters["@ZDATE_DISB"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZDFI_CODE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZDFI_CODE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZDFI_NAME", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZDFI_NAME"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZDIR1", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZDIR1"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZDIR2", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZDIR2"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZDISB_ROUTINE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZDISB_ROUTINE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZESTABLISH", System.Data.SqlDbType.DateTime);
SqlCmd.Parameters["@ZESTABLISH"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZEXPECT_AMT", System.Data.SqlDbType.Money);
SqlCmd.Parameters["@ZEXPECT_AMT"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZFACILITY_TYPE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZFACILITY_TYPE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZMANAGING", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZMANAGING"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZMORAT_MTHS", System.Data.SqlDbType.SmallInt);
SqlCmd.Parameters["@ZMORAT_MTHS"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZOFFICE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZOFFICE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZPROJECT_TYPE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZPROJECT_TYPE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZREGISTERED", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZREGISTERED"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZSECT_NAME", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZSECT_NAME"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZSECT_NO", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZSECT_NO"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZTRANCHE", System.Data.SqlDbType.Money);
SqlCmd.Parameters["@ZTRANCHE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZDISBURSE_TYPE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZDISBURSE_TYPE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZINTEREST_TYPE", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZINTEREST_TYPE"].Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.Add("@ZMORATORIUM", System.Data.SqlDbType.VarChar, 50);
SqlCmd.Parameters["@ZMORATORIUM"].Direction = System.Data.ParameterDirection.Output;
ALTER Procedure [dbo].[sp_GetDisbursed]
(
@ZAPPRAISAL VarChar( 50) OUTPUT,
@ZACCT1 VarChar( 50) OUTPUT,
@ZACCT2 VarChar( 50) OUTPUT,
@ZACTUAL_DISB MONEY OUTPUT,
@ZAMT_APPRVED MONEY OUTPUT,
@ZBANK1 VarChar( 50) OUTPUT,
@ZBANK2 VarChar( 50) OUTPUT,
@ZBENEFICIARY VarChar( 50) OUTPUT,
@ZBRANCH_CODE VarChar( 50) OUTPUT,
@ZBRANCH_NAME VarChar( 50) OUTPUT,
@ZCREDIT_OFFICER VarChar( 50) OUTPUT,
@ZCURRENCY VarChar( 50) OUTPUT,
@ZDATE_DISB DateTime OUTPUT,
@ZDFI_CODE VarChar( 50) OUTPUT,
@ZDFI_NAME VarChar( 50) OUTPUT,
@ZDIR1 VarChar( 50) OUTPUT,
@ZDIR2 VarChar( 50) OUTPUT,
@ZDISB_ROUTINE VarChar( 50) OUTPUT,
@ZESTABLISH DateTime OUTPUT,
@ZEXPECT_AMT MONEY OUTPUT,
@ZFACILITY_TYPE VarChar( 50) OUTPUT,
@ZMANAGING VarChar( 50) OUTPUT,
@ZMORAT_MTHS SmallInt OUTPUT,
@ZOFFICE VarChar( 50) OUTPUT,
@ZPROJECT_TYPE VarChar( 50) OUTPUT,
@ZREGISTERED VarChar( 50) OUTPUT,
@ZSECT_NAME VarChar( 50) OUTPUT,
@ZSECT_NO VarChar( 50) OUTPUT,
@ZTRANCHE MONEY OUTPUT,
@ZDISBURSE_TYPE VarChar( 50) OUTPUT,
@ZINTEREST_TYPE VarChar( 50) OUTPUT,
@ZMORATORIUM VarChar( 50) OUTPUT
)