How to return string value through a sql query?

Question

I have a query which retuns a string value as the output. But shows an error in the return. I dont know how to fix it. Here i have added my query.

public string detailsRemarksGet(string ddlValue)
{

     string strQuery = @"select r.remarks
                        from [A_MASTER] m, [A_REMARKS] r
                        where m.A_REF_NO=r.A_REF_NO 
                        and r.A_REF_NO='"+ ddlValue +"' and DEPT='POS' ";
     return SqlHelper.ExecuteScalar(strConnStringAppeal, CommandType.Text, strQuery);
}

Here is mky code of .cs

public string detailsRemarks(string ddlValue)
{
   string remarks= db.detailsRemarksGet(ddlValue);
   return remarks;
}

In the error list i get a message as follows

Error 2 Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)

Mostafiz · Accepted Answer · 2016-09-19 04:25:35Z

3

Sql query return object type, you need to cast that as string. So cast as string using ToString() method in return statement

return SqlHelper.ExecuteScalar(strConnStringAppeal, CommandType.Text, strQuery).ToString();

edited Sep 19, 2016 at 4:25

answered Sep 19, 2016 at 4:18

Mostafiz

7,3523 gold badges30 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mike Over a year ago

It works. Thanks for the answer. I will accept it after few minutes

Mostafiz Over a year ago

great, happy coding

Shai Cohen Over a year ago

You are not even going to mention the glaring SQL injection problem in the code?

Sandip - Frontend Developer · Accepted Answer · 2016-09-19 04:57:32Z

0

Just convert your return type to String, because your method name db.detailsRemarksGet will return you an object and your detailsRemarks method return type is string.

public string detailsRemarks(string ddlValue)
{
    string remarks= Convert.ToString(db.detailsRemarksGet(ddlValue));
    return remarks;
}

answered Sep 19, 2016 at 4:57

Sandip - Frontend Developer

14.7k5 gold badges38 silver badges62 bronze badges

Collectives™ on Stack Overflow

How to return string value through a sql query?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related