.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

project using ADO.NET & EF works, but not inside customers network...

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :ASP.Net
I'm developing a case management package called SLPortal and I've run into some rather strange problems. Here's the breakdown: It's a .Net 3.5 web app developed in VS2008 using C#, ADO.NET and Entity Framework. Database is MS SQL Server 2005 hosted on Windows Server 2003 Webserver is IIS6 on Windows Server 2003 It's hosted from within the Boise State University LAN. The test system at my house runs 'fine' in that most everything works as intended, aside from the occasional bug from my inexperienced code. Here's the key issue: It seems like when we (myself and the testers) log into the system from on campus, all 'Create' functions quit working, with one exception: I used the Microsoft asp.net MembershipProvider tables to handle the User and Roles functionality. They are built into the FACULTYINTAKE database. All Create, Update, and Delete functionality for these tables work correctly, but note that I am strictly using the MS provided functions to interact with it. I can use the system from home and off the BSU campus and it works. The test systems run Windows XP Pro sp3, Vista Business x86 (32 bit), and Windows Server 2008 64bit using Internet Explorer 7 and 8, Firefox, Safari 4, and Chrome. There are hiccups, but all the database stuff works. When we attempt to use the system from BSU, anywhere on the BSU

View Complete Post

More Related Resource Links

DataPager works inside ListView, but not outside


I have a ListView that uses an ObjectDataSource

When I add a DataPager control INSIDE the ListView, it works fine and the ListView's PagePropertiesChanging event fires.

When I move the DataPager OUTSIDE the ListView control and set its PagedControlID to the ListView, it stops working and the ListView's PagePropertiesChanging event no longer fires.

i.e. This works (and the ListView's PagePropertiesChanging fires):

        <asp:ListView ID="lvItems" runat="server" DataSourceID="dsItems" ItemPlaceholderID="itemPlaceholder">

Cannot connect to SSAS production server in customers network



I have a problem when connecting to the SSAS production server (SQL Server 2008 Standard Edition) of my customer.

The situation is as follows: I have SSMS installed on my computer and also on the production server. On the server the connection to my SSAS/database works fine, but on my machine it doesn't. I am connected through a VPN connection with the customers network. The Windows Firewall is not activated on the Windows Server 2003 SP3 where SSAS is installed on. The connection to the SQL Server Database located on the same server from my machine works fine (via Windows Authentication), but as I said, the connection to SSAS does not. As we have different Windows Domains I am logged on with my corporate login (RCG\alexander.greiner) on my machine and connected through VPN with the administrative credentials (CUSTOMER\myadmin) I got from my customer.

Following error message is displayed when I try to connect to the remote SSAS in my customers network: "A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)"

Do you have any ideas on how I can solve this problem?


Error Running SSIS Package as SQL Agent Job loading a file from network drive, works fine in bids an

Having problems reading an excel file from a networked drive while running a package as a SQL Agent job step as a type "SQL Server Integration Services Package". I have agent running as an AD account, and I can use the execute package utility logged in as this account and it works. When I log into the server as this account, I can see the network drive, read/write/create to folders on the drive but when I try to run the agent job it cant find the file. I tried using the unc path in the config file rather than a mapped drive, still no luck. If I use a local drive (c) in the config file, the job works fine so it has to do with the network drive. Running windows server 2003 standard R2, SQL Server 2005 standard sp3. Any ideas out there?

Adventure works list of customers who has done purchases on a particular date



My requirement is to get a list of customers who has purchased any item on a particular date. If the purchase date is known, how can get the customers for that date who purchased items. An example using the Adventure work analysis database is very much appreciated.



Unity container works within Asp.net project but not within class library it calls.


I have a solution with an asp.net project and several class libraries.  I am using Unity 2.0 in all the projects.  Unity 2.0 seems to work within the HelpfulQuiz web asp.net project, but not within the HelpfulQuizCore class library it utilizes.  I've spent several days trying to figure this out and would appreciate your kind assistance.  Here is the error:


Server Error in '/' Application.

The current type, HelpfulQuizCore.Core.IPictureRepository, is an interface and cannot be constructed. Are you missing a type mapping?

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.InvalidOperationException: The current type, HelpfulQuizCore.Core.IPictureRepository, is an interface and cannot be constructed. Are you missing a type mapping?

Source Error: 

Line 30:             containe

Accessing the different controls inside a GridView control

how we can access a particular control which resides inside a GridView control. In this article I will show you how you can access different controls inside a GridView control. We will see how we can access a TextBox control, a DropDownList control and a ListBox control. If you are working with ASP.NET 1.X then you might want to check out my article Accessing Different Controls Inside a DataGrid.

Project Example: ASP.NET MVC + SubSonic Architecture

use of SubSonic to provide the DAL in association with some ASP.NET MVC sites and was waylaid in my original intent to throw up a post summarizing the architecture we're using for the effort. Well I've finally gotten around to it. Recall that in his fake it till you need it post, Dave provided a window on our architecture that I'll build upon here

How To Add calendar control inside a GridView

This article show hot to add calendar control inside a GridView with code in c#

Using ATLAS PopUp Control with Calendar inside the GridView Control

In this video tutorial Mohammad demonstrates how you can access the Calendar control which is displayed using the ATLAS PopUp control inside the GridView control.

RadioButton inside GridView, How to get it work as normal

Did you tried before to drag a RadioButton control inside a Gridivew templatefield, and then you attempt to select these RadioButtons , you will notice that the behavior of RadioButton control will be changed and it will work just like the behavior of checkbox control! the user will be able to select more than one radiobutton in the grid!

Maintain HTML Radio Button Selection Inside GridView After Postback

Long time ago I wrote an article about getting the value of the selected RadioButtons inside the GridView control. The code did not addresssed the postback issue which means that the selected radio button was cleared after the postback occurs.

Code works on aspx but not ascx


Not sure which category to put this question in, so I will put it in here.

Just to give you an idea of the layout of my solution, I have the main project, along with 2 class libraries, BLL and DAL.  (Business Logic Layer and Data Access Layer)

The BLL refers to the DAL and the main project refers to the BLL.

I had a test website and the code worked fine, but the same code will not work on the real project. The only difference is that in the test project, the code was on an aspx code behind, whereas in the real project, it is an ascx code behind (Web User Control )

The code is:

Dim connectionString As String = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString").ConnectionString
        Dim recordEntry As New UserRecord(connectionString)
        recordEntry.UserName = "TestName"
        recordEntry.BMI = bMI
        recordEntry.BMR = bMR
        recordEntry.FTM = fTM
        recordEntry.TDEE = tDEE
        recordEntry.TodayDate = dateForToday

Dim connectionString As String = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString").ConnectionString

LinkButton inside Repeater



I have Repeater, which consists of LinkButon and Literal. LinkButon and Literal are whole thing by implication. I want get value from Literal, when user click on corresponding LinkButton.


Textbox in ItemTemplate inside Gridview, unable to get the value


Hi. I have a itemtemplate inside a gridview.

<asp:TemplateField HeaderText="Enter OTP">
                            <asp:Label ID="Label2" runat="server"
                                style="font-family: Arial, Helvetica, sans-serif; font-size: x-small"
                                Text="PIN Num:"></asp:Label>
                            &nbsp;<asp:TextBox ID="txtPIN" runat="server" Height="21px" Width="100px"></asp:TextBox>

Embed Youtube inside Ajax Html Editor- problem



When inserting a simple embed of youtube inside the ajax editor, on firefox and chrome problems occur. On the other hand on internet explorer 8 everything works fine. I found this solution http://www.nopcommerce.com/boards/t/4228/bug-in-ajax-html-editor.aspx . 

My question is where do I find the DesignPanel.pre.js ?


Roderick Vella

Gridview inside updatepanel


I am displaying large amount of data in gridview,the gridview placed within updatepanel,every 1sec i am refreshing updatepanel using ajax timer.my problem is while displaying large data the cpu performance is low,pls give idea to increase cpu performance..

how to get an array of all the asp.net textbox control inside create user wizard control?



How can I get all the textboxes inside a create user wizard control using getElementsByTagName().

Below is my JQuery code:

<script type="text/javascript">
        function addLoadEvent(func) {
            var oldonload = window.onload;
            if (typeof window.onload != 'function') {
                window.onload = func;
            } else {
                window.onload = function() {

        function prepareInputsForHints() {
            var inputs = document.getElementsByTagName("asp:TextBox");
            for (var i = 0; i < inputs.length; i++) {
                inputs[i].onfocus = function() {
                    this.parentNode.getElementsByTagName("span")[0].style.display = "inline";
                inputs[i].onblur = function() {
                    this.parentNode.getElementsByTagName("span")[0].style.display = "none";



<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
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