<div>
Try this<br />
<br />
(SELECT WeekUpdate from tbl_StatusTracking10th <br />
where cast(ReferralID as varchar(50)) = '@ReferralID' )&quot;
</div>


Try this

(SELECT WeekUpdate from tbl_StatusTracking10th
where cast(ReferralID as varchar(50)) = '@ReferralID' )"

<div>
it solved the error but the sql query does not seem to recognize referralID. ReferralID is a int number.
</div>


it solved the error but the sql query does not seem to recognize referralID. ReferralID is a int number.

<div>
<div class="content wysiwyg-content">
i am trying to do assign the referralID in <br />
&nbsp; &nbsp; &nbsp; &nbsp; if (!this.IsPostBack)<br />
&nbsp; &nbsp; &nbsp; &nbsp; {<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.SqlDataSource3.Select<wbr />Parameters<wbr />[&quot;Referral<wbr />ID&quot;].Defau<wbr />ltValue = Request.QueryString[&quot;r&quot;];<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; }<br />
<br />
I have a dropdown list pulling data from a database.<br />
<br />
&nbsp;&lt;asp:SqlDataSource ID=&quot;SqlDataSource3&quot; runat=&quot;server&quot; SelectCommand=&quot;select WeekID, WeekUpdate from tbl_WeekUpdate where WeekID not in (SELECT WeekUpdate from tbl_StatusTracking10th where ReferralID = '@ReferralID' )&quot; ConnectionString=&quot;&lt;%$ ConnectionStrings:TestConn<wbr />ectionStri<wbr />ng %&gt;&quot; &gt;<br />
&nbsp; &nbsp; <br />
&nbsp; &lt;SelectParameters&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &lt;asp:Parameter DefaultValue=&quot;-1&quot; &nbsp;Name=&quot;ReferralID&quot; /&gt;<br />
&nbsp; &nbsp; &nbsp; &lt;/SelectParameters&gt;<br />
&nbsp; &nbsp; &lt;/asp:SqlDataSource&gt;<br />
<br />
I receive this error.<br />
Conversion failed when converting the varchar value '@ReferralID' to data type int.<br />
<br />
Any suggestion
</div>
</div>


i am trying to do assign the referralID in 
        if (!this.IsPostBack)
        {

            this.SqlDataSource3.SelectParameters["ReferralID"].DefaultValue = Request.QueryString["r"];

        }

I have a dropdown list pulling data from a database.

 <asp:SqlDataSource ID="SqlDataSource3" runat="server" SelectCommand="select WeekID, WeekUpdate from tbl_WeekUpdate where WeekID not in (SELECT WeekUpdate from tbl_StatusTracking10th where ReferralID = '@ReferralID' )" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" >
    
  <SelectParameters>
        <asp:Parameter DefaultValue="-1"  Name="ReferralID" />
      </SelectParameters>
    </asp:SqlDataSource>

I receive this error.
Conversion failed when converting the varchar value '@ReferralID' to data type int.

Any suggestion

Conversion failed when converting the varchar value '@ReferralID' to data type int.

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).