An Error has occurred: Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
using System; using System.ComponentModel; using System.Web.UI; using System.Web.UI.WebControls; using System.Xml.Serialization; using Microsoft.SharePoint; using Microsoft.SharePoint.Utilities; using Microsoft.SharePoint.WebPartPages; using System.Data; using System.Data.SqlClient; namespace NewDispData ...{ /**////<summary> /// Description for WebPart1. ///</summary> [DefaultProperty("Text"), ToolboxData("<{0}:WebPart1 runat=server></{0}:WebPart1>"), XmlRoot(Namespace="NewDispData")] publicclass NewDispData : Microsoft.SharePoint.WebPartPages.WebPart//,ICellConsumer//,IRowProvider ...{
webPart变量#region webPart变量 privateconststring defaultText =""; privatestring text = defaultText; [Browsable(true), Category("Miscellaneous"), DefaultValue(defaultText), WebPartStorage(Storage.Personal), FriendlyName("Text"), Description("Text Property")] publicstring Text ...{ get ...{ return text; }
set ...{ text = value; } } conststring connectionStr ="server=downmoon-hgh;database=NorthWind;uid=sa;pwd=sa;";// protected Label ErrorLabel; protected DataGrid OrdersGrid;
创建子控件#region 创建子控件 protectedoverridevoid CreateChildControls() ...{ // This label is displayed only if // an exception is thrown while attempting // to load the data. ErrorLabel =new Label(); ErrorLabel.Visible =false; Controls.Add(ErrorLabel);
// Create the data grid OrdersGrid =new DataGrid(); BoundColumn newColumn;
Controls.Add(OrdersGrid); } /**////<summary> /// OrdersLoad /// handles OrdersGrid.Load. ///</summary> /// publicvoid OrdersLoad(object sender, EventArgs e) ...{ BindGrid(); } privatevoid BindGrid() ...{ // Load schema and data into a DataSet. DataSet ordersSet =new DataSet();
// Assume XML data file is in the wpresources folder. // If File I/O permissions are not available, // the following will throw a security exception. try ...{ NorthWindConnection.Open(); string sqlSelectStr ="select * from Orders"; NorthWindAdp =new SqlDataAdapter(sqlSelectStr,NorthWindConnection); NorthWindDataSet =new DataSet(); NorthWindAdp.Fill(NorthWindDataSet,"Orders"); NorthWindConnection.Close(); } catch(Exception ex) ...{ ErrorLabel.Text = ex.Message +"<br>"+ "Steps to correct this are included in"+ " the documentation for this sample."; ErrorLabel.Visible =true; return; } finally ...{ NorthWindConnection =null; NorthWindAdp =null; }
// No error if we made it this far. ErrorLabel.Visible =false;