<%-- _lcid="1033" _version="12.0.4518" _dal="1" --%>
<%-- _LocalBinding --%>
<%@ Page language="C#" MasterPageFile="~masterurl/default.master"    Inherits="Microsoft.SharePoint.WebPartPages.WebPartPage,Microsoft.SharePoint,Version=12.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c" meta:webpartpageexpansion="full" meta:progid="SharePoint.WebPartPage.Document" %>
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<asp:Content ContentPlaceHolderId="PlaceHolderPageTitle" runat="server">
	<SharePoint:EncodedLiteral runat="server" text="<%$Resources:wss,webpagecreation_bp_title%>" EncodeMethod='HtmlEncode'/>
</asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderPageTitleInTitleArea" runat="server">
	<table>
		<tr>
			<td class="ms-pagetitle" style='width: 100%'>
			<WebPartPages:WebPartZone runat="server" Title="loc:TitleBar" ID="TitleBar" AllowLayoutChange="false" AllowPersonalization="false"><ZoneTemplate></ZoneTemplate></WebPartPages:WebPartZone></td>
			<td class="ms-propertysheet" nowrap="true">
			<SharePoint:BpScript runat="server"/></td>
		</tr>
	</table>
</asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderAdditionalPageHead" runat="server">
	<META Name="GENERATOR" Content="Microsoft SharePoint">
	<META Name="ProgId" Content="SharePoint.WebPartPage.Document">
	<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
	<META Name="CollaborationServer" Content="SharePoint Team Web Site">
	<script>
	var navBarHelpOverrideKey = "wssmain";
	</script>
	<SharePoint:RssLink runat="server"/>
	<SharePoint:ScriptLink language="javascript" name="bpstd.js" runat="server"/>
	<style>
	Div.ms-titleareaframe {
		height: 100%;
	}
	.ms-pagetitleareaframe table {
		background: none;
	}
	</style>
<!--[if gte mso 9]><xml>
<o:CustomDocumentProperties>
<o:Category msdt:dt="string">9-Examples of Best Practice</o:Category></o:CustomDocumentProperties></xml><![endif]-->
</asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderSearchArea" runat="server">
	<SharePoint:DelegateControl runat="server"
		ControlId="SmallSearchInputBox"/>
</asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderLeftActions" runat="server">
</asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderPageDescription" runat="server">
	<SharePoint:ProjectProperty Property="Description" runat="server"/>
</asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderBodyRightMargin" runat="server">
	<div height=100% class="ms-pagemargin"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></div>
</asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderPageImage" runat="server"></asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderLeftNavBar" runat="server"></asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderNavSpacer" runat="server"></asp:Content>
<asp:Content ContentPlaceHolderId="PlaceHolderMain" runat="server">
		<table cellpadding="4" cellspacing="0" border="0" width="100%">
				<tr valign="top">
					<td width="100%">
						<WebPartPages:WebPartZone runat="server" FrameType="TitleBarOnly" Title="loc:FullPage" ID="FullPage" AllowLayoutChange="false" AllowPersonalization="false"><ZoneTemplate>
<WebPartPages:ContentEditorWebPart runat="server" __MarkupType="xmlmarkup" WebPart="true" __WebPartId="{27B3F9F0-5288-4E2E-B998-BB58704DC7CD}" >
<WebPart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/WebPart/v2">
  <Title>Content</Title>
  <FrameType>None</FrameType>
  <Description>Use for formatted text, tables, and images.</Description>
  <IsIncluded>true</IsIncluded>
  <PartOrder>1</PartOrder>
  <FrameState>Normal</FrameState>
  <Height />
  <Width />
  <AllowRemove>true</AllowRemove>
  <AllowZoneChange>true</AllowZoneChange>
  <AllowMinimize>false</AllowMinimize>
  <AllowConnect>true</AllowConnect>
  <AllowEdit>true</AllowEdit>
  <AllowHide>true</AllowHide>
  <IsVisible>true</IsVisible>
  <DetailLink />
  <HelpLink />
  <HelpMode>Modeless</HelpMode>
  <Dir>Default</Dir>
  <PartImageSmall />
  <MissingAssembly>Cannot import this Web Part.</MissingAssembly>
  <PartImageLarge />
  <IsIncludedFilter />
  <ExportControlledProperties>true</ExportControlledProperties>
  <ConnectionID>00000000-0000-0000-0000-000000000000</ConnectionID>
  <ID>g_27b3f9f0_5288_4e2e_b998_bb58704dc7cd</ID>
  <ContentLink xmlns="http://schemas.microsoft.com/WebPart/v2/ContentEditor" />
  <Content xmlns="http://schemas.microsoft.com/WebPart/v2/ContentEditor"><![CDATA[<STRONG>Hello</STRONG>
<DIV></DIV>]]></Content>
  <PartStorage xmlns="http://schemas.microsoft.com/WebPart/v2/ContentEditor" />
</WebPart>
</WebPartPages:ContentEditorWebPart>
</ZoneTemplate></WebPartPages:WebPartZone>
					</td>
					<asp:SqlDataSource runat="server" id="SqlDataSource1" ProviderName="System.Data.SqlClient" ConnectionString="Data Source=IEVV11111;Initial Catalog=SOV;User ID=dsa;Password=asd" SelectCommand="SELECT [TAB], [LOGON] FROM [ALL_LIST]">
					</asp:SqlDataSource>
					<asp:GridView runat="server" id="GridView2" AutoGenerateColumns="False" DataSourceID="SqlDataSource2">
						<Columns>
							<asp:boundfield DataField="TAB" HeaderText="TAB" SortExpression="TAB">
							</asp:boundfield>
							<asp:boundfield DataField="LOGON" HeaderText="LOGON" SortExpression="LOGON">
							</asp:boundfield>
						</Columns>
					</asp:GridView>
					<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
						<Columns>
							<asp:boundfield DataField="TAB" HeaderText="TAB" SortExpression="TAB">
							</asp:boundfield>
							<asp:boundfield DataField="LOGON" HeaderText="LOGON" SortExpression="LOGON">
							</asp:boundfield>
						</Columns>
					</asp:GridView>
					<asp:SqlDataSource runat="server" id="SqlDataSource2" ProviderName="System.Data.SqlClient" ConnectionString="Data Source=IEVV11111;Initial Catalog=SOV;Integrated Security=True" SelectCommand="SELECT [TAB], [LOGON] FROM [ALL_LIST]">
					</asp:SqlDataSource>
				</tr>
		</table>
</asp:Content>

This control does not allow connection strings with the following keywords: ‘Integrated Security’, ‘Trusted_Connection’. 
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: Microsoft.SharePoint.WebPartPages.DataSourceControlDisabledException: This control does not allow connection strings with the following keywords: ‘Integrated Security’, ‘Trusted_Connection’.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[DataSourceControlDisabledException: This control does not allow connection strings with the following keywords: ‘Integrated Security’, ‘Trusted_Connection’.]
   Microsoft.SharePoint.WebControls.SPSqlDataSource.CheckConnectionString(String ConnectionString) +339
   Microsoft.SharePoint.WebControls.SPSqlDataSource.GetView(String viewName) +75
   System.Web.UI.DataSourceControl.System.Web.UI.IDataSource.GetView(String viewName) +10
   System.Web.UI.WebControls.DataBoundControl.ConnectToDataSourceView() +128
   System.Web.UI.WebControls.DataBoundControl.OnLoad(EventArgs e) +19
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

 


--------------------------------------------------------------------------------