object reference is not set to an instance of object

con2.Open();

ls_sql ="SELECT business_partner_id , broker_flag FROM Application " +

"WHERE application_number =" +"'" +this.is_appno +"'";

SqlCommand cmd =newSqlCommand(ls_sql ,con2);

SqlDataAdapter sql =newSqlDataAdapter(cmd);

sql.Fill(DsTemp,"DtTemp");

I found error on strikethrough line " object reference is not set to an instance of object"

ls_sql ="SELECT point_score_ind FROM FP_Dealer WHERE financial_product_id = (SELECT financial_product_id" +

" FROM contract_detail WHERE application_number =" +"'" +this.is_appno +"'" +" AND identification_code = 1 ) " +

"AND business_partner_id = (SELECT business_partner_id FROM Application WHERE application_number =" +"'" +this.is_appno +"'" +" )" +

" AND role_cde =" +"'" + ls_role_code +"'";

cmd =newSqlCommand(ls_sql, con2);

cmd.CommandType =CommandType.Text;

sql =newSqlDataAdapter(cmd);

lc_point_score_ind = cmd.ExecuteScalar().ToString().

cmd.Connection.Close();

samq:

lc_point_score_ind = cmd.ExecuteScalar().ToString().

Hi,

Can you try to use

lc_point_score_ind = sql.SelectCommand.ExecuteScalar().ToString().

Hope this helps to solve your problem

Good Luck

Regards

Vineed