.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Embedded code block question

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
Hello,i know it's a very basic problem but i can't use an asp.net code block the way i want.I have used those before but it seems i encountered a case i haven't seen before.<asp:SqlDataSource ID="SqlDataSourcetblCategoriesPourListe" runat="server" ConnectionString="<%$ ConnectionStrings:BottinConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT label from mytable WHERE (HOrder = @HOrder)))"> <SelectParameters> <asp:QueryStringParameter DefaultValue="<% (int)GetDefaultValue()%>" Name="HOrder" QueryStringField="HOrder" /> </SelectParameters> </asp:SqlDataSource>Whenever i run this, i get an exception:Syntax error converting the nvarchar value '<% (int)GetDefaultValue()%>' to a column of data type int.How can i avoid this ?I am not doing it in the code behind because i use nested gridviews and sqldatasources.  Can't access nested sqldatasources from code behind, as far as i know.

View Complete Post

More Related Resource Links

SSRS embedded code scope question

Can someone please provide some insight about how embedded code works in terms of scope?  I am trying to show moving average values on charts using the custom code from http://msdn.microsoft.com/en-us/library/aa964128%28SQL.90%29.aspx.  My chart has an actual series group, which has multiple values.  To be specific, my data series is profit per unit; my series group is division; and I have time on the X axis.  The "division" series group can have multiple values such as "US", "Europe", and "Asia".  Looking at the moving average custom code from the above link, I really wonder how the global variables, such as "queue" and "queueSum", are handled across the multiple series group values.  Can it correctly separate the queue for division "US" from the queue for division "Europe" and "Asia"?  Also, I have multiple charts ont he same report and they all use the moving average custom code.  Does SSRS use different instances of the global variables so that one chart is calculated separately from another? 

Question about user used to execute code from app_code


 Hello. I would like to know something about code execution  in App_Code folder.

Under wich user executed code from app_code.

I'm using impersonate in web.config

Catch Block question

What are the scenarios in which a t-sql catch block will not be called?   I have a SP which does partition management, sometimes i see that partitions have not been properly created... but still the catch block was never called. This is getting very hard to debug.   Can it be that in some timeout scenarios the catch block is not called?

How do I get column values in Sharepoint designer so I can use them as a variable in code block?

The code below is in my EditForm.aspx and it works but instead of it outputting "This is just a test!" I need get a number that is stored in a column named Phone Number that has 5555555555 stored in it and have the line that says TD2.innerHTML = "This is just a test!"; ouput what ever number is stored in the Phone Number column. Here is the code that is in my EditForm.aspx <script type="text/javascript">function DisplayItemID(){       var TD1 = document.createElement("TD");       TD1.className = "ms-formlabel";       TD1.innerHTML = "<h3 class='ms-standardheader'>Test</h3>";       var TD2 = document.createElement("TD");       TD2.className = "ms-formbody";       TD2.innerHTML = "This is just a test!";       var IdRow = document.createElement("TR");       IdRow.appendChild(TD1);       IdRow.appendChild(TD2);       var ItemBody = GetSelectedElement(document.getElementById("idAttachmentsRow"),"TABLE").getElementsByTagName("TBODY")[0]; 

Question with this code

Hello all I have a question with this code, I'm still learning and I'm not sure what can be the possible error with this code Thanks in advance for the help! The error showed is this ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Index and count must refer to a location within the string. Parameter name: count Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentOutOfRangeException: Index and count must refer to a location within the string. Parameter name: count Source Error: Line 54: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Line 55: Line 56: Usuario = Context.User.Identity.Name.Remove(0, 6).ToString Line 57: Line 58: Dim myConnection As New Data.SqlClient.SqlConnection ----------------------------------------------------------------------------------------------------------- This is my code ------------------------------------------------------------------------------------------------------------ Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Usuario= Context.User.Identity.Name

Changing Properties/Attributes of a Webpart in inline code block - Error 'System.Web.UI.WebControl

I'm trying this code below, but gettting error: System.Web.UI.WebControls.WebParts.WebPart' does not contain a definition for 'FilterValue1' I need to change the value of the FilterValue1 properties of a content Query WebPart with title = Applicant Files. Thanks in Advance!
protected override void OnLoad(EventArgs e) {  base.OnLoad(e); SPSecurity.RunWithElevatedPrivileges(delegate() { using (SPSite SiteCollection = new SPSite("https://somesite/")) { SPWeb myWeb = SiteCollection.OpenWeb(); myWeb.AllowUnsafeUpdates = true; Microsoft.SharePoint.WebPartPages.SPLimitedWebPartManager mgr = null; mgr = myWeb.GetLimitedWebPartManager("default.aspx",System.Web.UI.WebControls.WebParts.PersonalizationScope.Shared); foreach (System.Web.UI.WebControls.WebParts.WebPart myWebPart in mgr.WebParts) { if (myWebPart.Title == "Applicant Files") { myWebPart.FilterValue1 = "/13"; mgr.SaveChanges(myWebPart); break; } } } }); }

General question: Using the VS Designer vs. the Source Code

I just finished Sams Teach Yourself ASP.Net in 24 Hours. I am now going through the Data tutorials here. I am a beginner at ASP.Net. One thing that I am having a little bit of trouble with is the idea that I am using the Designer in Visual Studio for just about everything except for a few code tweaks. I used to do a lot of HTML, JavaScript and CSS. I even did some programming (PowerBuilder). So, I am used to writing/typing code instead of using a Designer. (I always liked writing web pages in a text editor.) When I look at the code generated by the Designer in Visual Studio, I can understand what is going on there. But, to sit down and write that code instead of using the Designer to me seems impossible. There is just so much there. From what I understand, ASP.Net and Visual Studio were created to help streamline the code writing process. I suppose if I was used to writing VB code to create applications I might look at this from a different angle. But, I am learning ASP.Net using the VS Designer. Any comments or suggestions from experienced coders? I really don't want to have a battle between people who use the Designer and the Source Code editor. I am just hoping for some comments that will help newbies. Thanks.

Newbie question about SQl code and SSIS


Hi Guys,

Im coming from a SAP Datawarehouse background and i don't know much about sql queries or statements. I was wondering if i need this knowledge to learn SSIS, and if so in what situations?

Thanks in advance

Infopath form timesheet question on rounding time and using code


We have a timesheet form that has 4 time fields:  Start Time, End Time, Actual Time and Billable Time. 

Our Start Time, End Time and Actual Time buttons and field calculations work just fine, but we want the 4th field to calculate the billable time by rounding UP to the quarter-hour.

For example:

Start Time - 9:00am

End Time - 11:20am

Actual Time -  2:20

Billable Time - 2:30 (or 2h30min)


I'm new to Infopath and not sure how we would accomplish this.  What type of code would I need and can I even use code on that Billable Time field to accomplish this?


Thanks for any help you can give me!


A few question on optimizing the code


1. Does comments in code affect the processing time on server?

2. Do I decrease the process time if I change <asp:Label></asp:Label> to <asp:Label />

3. Is there a difference in writing "using System.Web.Security;" at the beginning of the code or
 specifying it when it is needed "System.Web.Security.FormsAuthentication.SignOut();"

4. Should I spend more time on trying to reuse connections if possible when processing the page.
   Someone said that .NET does this automatically if the use of the connection happens within a certain time?

5. Does formatting and long variable/function names affect the processing of the page and is it worth anything to shorten them?

Thanks in advance!


Infopath Question: XPath code to remove domain name from AccountID field in Person/Group Picker


I have an infopath email based submission form where I am using the Person/Group picker as a way for people to find people in the active directory to CC the form to. I was using the field "DisplayName" in the control and discovered that when you try to CC several employees, that it would disrupt the rules and you can't send the form.

I want to use the field "AccountID" but it includes the domain before the email alias (for ex. REDMOND\johndoe). Is there a formula code I could use to remove the domain from every email alias. Right now my CC formula is concat(SubmitterAlias, "; ", DisplayName)

Novice question regarding code behind


I am new to ASP.Net and am having problems.  I'm trying to create a web app based on a tutorial and I can't get it to work.  The code is from Beginning ASP.NET 3.5 in C# 2008, 2nd Ed (pages 141/142).  Here's what I'm doing (using VS 2010 on WinXP):

File/New Project/Web -> ASP.Net Web Application

Leave the default Name

Delete all code from Default.aspx and replace with: 

<%@ Page Language="C#" AutoEventWireup="true"CodeFile="CurrencyConverter.aspx.cs" Inherits="CurrencyConverter" %>
<html xmlns="http://www.w3.org/1999/xhtml">
    <title>Currency Converter</title>
    <form runat="server">
            <input type="text" ID="US" runat="server" />
              U.S. dollars to Euros.
            <br /><br />
            <input type="submit" value="OK" ID="Convert" runat="server"
                OnServerClick="Convert_ServerClick" />
            <br /><br />
            <div style="font-weight: bold" ID="Result" runat=&qu

Newbie question: Are there any code changes required in an app when introducing SQL Replication?



We are investigating introducing SQL Replication (transactional model) to mitigate the usage of our main database from a remote site (so, we would have a replication at the remote site).

What we want is for users to write only to the Publisher, and read from the local Subscribers.

I have just assumed so far that SQL Replication will be completely transparent and handle the replication internally, so that we won't need to change anything in our client applications connecting to the DB, but I can't actually find any documentation that confirms this (it just seems to be the most obvious way for this to work).

Can you please point me to some documentation that clarifies this, or just confirm the actual behaviour here?

Thank you!


Login SQL Server with Dynamic Code and block SSMS remote connection


Dear all,

- Can we configure SQL Server login integrated using Dynamic Code (TOKEN) ?

As far i know , we can use Dynamic code / Token with Login Windows, but i dont know about Token/Dynamic Code with SQL Server login.

- and can we block SSMS Remote connection, so we cannot connect using SSMS /Query analyzer to the server. The only way is local connection.

thanks in advance

Our Environments :
-SQL Server 2K8EE integrated with LUna HSM & RSA

-Win Server 2k8EE


Regards, Mathias.Arya

New code block suggestion


In my latest project all the calls to Data Access Layer (or any other layer for that matter) return ArrayList of errors. in one of the functions i have about 25 calls to data layer, because i'm saving a huge object that has to create/update/delete from about 15 tables in the DB. Since i don't want to continue execution if one call returns any error my code looks like this:

if (errorList.Count == 0)


    //massage data

    errorList = dataLayer.Save1(object1);


if (errorList.Count == 0)


    errorList = dataLayer.Save2(object2);



this creates extra 25 if conditions. So i thought there should be a better way.

So my suggestion is to introduce a new code block similar to 'try' 'catch', but 'try' 'catch' only watches for exceptions; I suggest a custom block (like 'watch' 'found' or something of that nature) where you can specify the condition that you are looking for. If condition is found -> execute found block. So instead of the code above my code could look like:

watch (errorList.Count > 0)


    errorList = dataLayer.Save1(object1);

    errorList = dataLayer.Save2(object2);



Issue while using embedded vb code in SSRS 2005


Problem description:

    I am using the function to embedd within the report .This function is called the user presses the view report button.

It works in the report designer (in preview),but it doesn't work on the server after i deployed it to the server,
why does it give me the message that is Error during processing of '@ParameterName' report parameter.(rsReportParameterProcessingError).

I am using Mgbox to display some alert statements in the Custome code.. embedded into the.. report

do I need to do anything with custom assemblies?
or any ot
her reasons this?

Any help to solve this issue is greatly appreciated


Code Optimized Web Development Profile (VS 2010 and .NET 4.0 Series)

When you first run VS 2010 it prompts you to select an IDE profile to use. The profile you select will configure how tool windows are displayed/docked in the IDE by default and set the default keyboard shortcuts. You can then customize any of these settings by using the Tools->Options menu within the IDE and then override/change them. You can also later reset your profile and pick a different one by choosing the Tools->Import and Export Settings menu command.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend