Cannot convert string to int, must be simple but i m missing somewhere
<p>here, i want to check only if the column Active is Yes, then get into the if loop. But it gives me an error "Cannot convert from string to int" for the last condition in if. What do you guys i can do. Thanks!!</p>

<pre><code>if (ds != null &amp;&amp; ds.Tables != null 
     &amp;&amp; ds.Tables.Count &gt; 0 
     &amp;&amp; ds.Tables[0].Rows.Count &gt; 0 
     &amp;&amp; ds.Tables[0].Columns[0].ColumnName["Status"] == "Y")
        {
            disableloc.DataSource = ds;
            disableloc.DataBind();
        }
        else
        {
            ds = null;
            disableloc.DataSource = ds;
            disableloc.DataBind();
</code></pre>

<p>The stored procedure is SELECT ML.locationname, 
  rtrim(ML.address) + (CASE WHEN ML.Address2 IS NOT NULL THEN ('' '' + rtrim(ML.Address2)) ELSE '''' END) + '' - ''+ ML.city + '', ''+ ML.state as address,
  ML.locationid,
  ML.merchantid, 
  case when ML.active &lt;> ''Y'' then ''Deactive'' else ''Active'' end [Status], 
  (SELECT count(*) as retval 
   FROM merchant_statistics 
   WHERE type = ''merchant'' 
    AND locationID= ML.LocationID 
    AND status = ''clicked'') as stat, 
''&nbsp;'' as button,'' '' as blank ,<br>
   dbo.GetCouponCountForLocations(@_merchantid,ML.locationID) couponCount,
   MP.DomainName,
   (SELECT Count(*) FROM Promotion WHERE LocationId = ML.locationid AND PostType = 1) AS jobs
 FROM merchant_location ML , Merchant_Pages MP
 WHERE MP.LocationID = ML.LocationID
 AND   ML.merchantid  = @_merchantid  Order By '</p>
