.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

Web Q&A: Data Integrity Over HTTP, IIS Credentials, DataGrids, and More

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

More Related Resource Links

Toolbox: Rich AJAX Data Controls, Analyzing HTTP Traffic, And More


This month we look at rich data Web controls for AJAX, HTTP traffic analysis, and more.

Scott Mitchell

MSDN Magazine March 2009

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?

Visual Studio 2005 loses shared data source credentials upon restart...Has it...or Will it ever be f

This issue was submitted via feedback on connect.microsoft for SQL Server on 5/14/09 and I can't seem to find anywhere that says it has been fixed!!!  I just got a new PC and they imaged my PC after another co-workers and he was having this issue and now so am I!!  I'm desperate for a resolution as I have to restart almost daily and I have several shared data source connnections...  Here are the details that were submitted to Microsoft....  Please any help is appreciated!!   Type: Bug ID: 450753 Opened: 5/14/2009 4:31:05 PM Access Restriction: Public       0 Workaround(s) view 18 User(s) can reproduce this bug         I recently installed Service Pack 3 for SQL Server 2005 on my local machine, and now my saved credentials for my shared data sources in my Reporting Services project in Visual Studio 2005 SP1 are gone every time I restart my computer. I have to enter the specific User Name and Password into the Credentials tab every day for each shared data source. This problem never occurred before I installed SQL Server 2005 SP3, and now my co-workers are afraid to install SP3 on their machines. The server already has SP3 installed. Details (expand) Product Language English Version SQL Server 2005 SP3 Category Rep

error sending SOAP data to http://localhost/myWCFService/MyWCFService.svc


I am a beginner with WCF services, trying to learn. I created a WCF service where MyWCFServiceInterface has service and data contracts. MyWCFService class implements this interface and has two methods that connect to sqlServer DB to run Sprocs to fetch data. I am hosting this WCFService using IIS6.0. I created a webclient to test the service, which works fine. When I call the service using soap request I get the following error: Could not POST file MyWCFService/MyWCFService.svc on server localhost(415). error sending SOAP data to http://localhost/MyWCFService/MyWCFService.svc


Please check the following wsdl and the soap request and suggest corrections. I greatly appreciate your help. Thanks.



<?xml version="1.0" encoding="utf-8"?>
<wsdl:definitions xmlns:wsap="http://schemas.xmlsoap.org/ws/2004/08/addressing/policy" xmlns:wsa10="http://www.w3.org/2005/08/addressing" xmlns:tns="http://tempuri.org/" xmlns:msc="http://schemas.microsoft.com/ws/2005/12/wsdl/contract" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wsx="http://schemas.xmlsoap.org/ws/2004/09/mex" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wsam="http://www.w3.org/2007/05/addressing/metadata" xmlns:soap12=&q

How can i send a http post, to get the girdview's data ? thanks


how to send a http post to asp.net web,

and to get the gridiview's data .

Gridview like this:




How to connect OLAP data source WITHOUT using http connection


Hello Guys,

I used to connect my OLAP database with this connection strings :

"Data Source=http://<target IP>/olap/msmdpump.dll;Catalog=<cube name>;Impersonation Level=Anonymous;"


but somehow, it managed to be disconnected for some other reason... 

then, i try to not using HTTP connection...

""Data Source=<target IP>;Catalog=<cube name>;Impersonation Level=Anonymous;"


the result is, I cannot connect to my OLAP.. 

Any suggestion? I want to connect my OLAP without using HTTP connection...



Best Regards and Thanks,

Roland Andreas

trying to call a web service with credentials gives me 505: HTTP Version Not Supported


I am trying to call an webservice from .net code.  I believe the webservice is java based.  If I visit the WSDL, I see this "WSDL created by Apache Axis version: 1.2".


When I call the web service with no credentials, I get the error 401: Unauthorized.

When I call the web service with credentials I get the error 505: HTTP Version Not Supported

401 Error:

SearchService svc = new global::Search.SearchService();
svc.Url = svcAddress;
SearchRequest req = new SearchRequest();
SearchResponse resp = svc.search(req);
 //The request failed with HTTP status 401: Unauthorized.

505 Error:

SearchService svc = new global::Search.SearchService();
svc.Url = svcAddress;
SearchRequest req = new SearchRequest();
svc.Credentials = new System.Net.NetworkCredential("user", "pass");
SearchResponse resp = svc.search(req);
//The request failed with HTTP status 505: HTTP Version Not Supported.


Also I have tried adding all of the following:

            svc.SoapVersion = System.Web.Services.Protocols.SoapProtocolVersion.Default;

            svc.SoapVersion = System.Web.Services.Protocols.SoapProtocolVersion.Soap

Passing data credentials back to the data layer


I have an N-Tier ASP.NET application that uses an Oracle back end and has to use Oracle Users to authenticate. I need to be able to pass these users back to the database to log in. I really do not want create parameters in each and every method for this purpose. Can someone give me some ideas on how I might pass these credentials back to the datalayer for db authentication purposes?

Stored Data Source Credentials in Report Builder 3.0



I have setup a SQL Reporting Services 2008 R2 server which contains data sources that connect to databases on a remote SQL 2008 server.  In the data source the connection string is defined and "Connect using:" is set to "Credentials Stored Securely in the Report Server", I have entered the credentials required to connect to the remote SQL 2008 server where the database resides and there is no problem when I choose "Test Connection". 

When I access the Report Builder through the SSRS website and create a new report I can add the data source to the report without an issue.  When I try to create a new dataset and specify to "Use a dataset embedded in my report" I can choose the data source but when I try to then open the Query Designer I am prompted to enter the credentials for the data source.  The username I saved in the data source on the Reporting Server seems to default in however the password does not.

I see on MSDN (http://msdn.microsoft.com/en-us/library/ms159736.aspx) the following:

"You can specify a single set of stored credentials that a report server uses to access external data for a report. Stored credentials are used if the report runs unattended. The report server retrieves and uses the credent

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.
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