Creating a Simple WebPart Page and Use WebServer Controls as WebParts

You are working with Microsoft SharePoint Portal Server 2003 or Microsoft Office SharePoint Portal Server 2007? But minimizing WebPart is supposed to work normaly. Can you observe the minimize icon or it is not displayed?! if you can enteract with it, then you mean it is not minimizing! and in this case I'm not sure of the issue

Well this may occur because of many reasons. Check the connection string in the Web.Config, and make sure that your SQLExpress is installed. You might not have SQLExpress, in this case, read my reply above your comment.

Hi, I am also facing the same problem.. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) any solution for this...? Hitesh

thank you my friend. to resolve your issue you'll need to add new connection string to your connectionString section. This connection string will map to one of your database where ASP.NET 2.0 Services is installed, specially Personalization Services. To install this services on a specific Database do the following: Start -> All Programs -> Microsoft .NET Framework SDK v2.0 -> click on SDK Command Prompt. type aspnet_regsql and press enter. This should display a wizard to you. follow the wizard and install the services on one of your databases. new you have the services installed. Now add a connection string to this database to your connectionStrings section if not already there. <connectionStrings> <add name="pubsConnectionString" connectionString="Data Source=.;Initial Catalog=pubs;Integrated Security=True" providerName="System.Data.SqlClient" /> <add name="aspnetservicesdb" connectionString="Data Source=.;Initial Catalog=aspnetdb;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> Under system.web element add the following <webParts> <personalization defaultProvider="AspNetSqlPersonalizationProvider"> <providers> <clear/> <add name="AspNetSqlPersonalizationProvider" connectionStringName="aspnetservicesdb" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider"/> </providers> </personalization> </webParts> Note the bolded code. You may also need to configure some other services like membership, role or profile providers. to do so you can also add the following under system.web element: <membership defaultProvider="AspNetSqlMembershipProvider"> <providers> <clear/> <add name="AspNetSqlMembershipProvider" connectionStringName="aspnetservicesdb" type="System.Web.Security.SqlMembershipProvider"/> </providers> </membership> <roleManager defaultProvider="AspNetSqlRoleProvider"> <providers> <clear/> <add name="AspNetSqlRoleProvider" connectionStringName="aspnetservicesdb" type="System.Web.Security.SqlRoleProvider"/> </providers> </roleManager> <profile defaultProvider="AspNetSqlProfileProvider"> <providers> <clear/> <add name="AspNetSqlProfileProvider" connectionStringName="aspnetservicesdb" type="System.Web.Security.SqlProfileProvider"/> </providers> </profile> Hope this helps you and resolves your issue

great Muhammad, nice work realy

Ahh.. the example is written in C# (guessing) and I was working in .net VB.

I got the same problem: I developed a webpart for sps 2003 which uses GridView Control to display data fetched from SQL Server 2005. It worked. Then i tried to customize the properties of gridview i.e., i set the properties AllowPaging and AllowSorting to true and added event handlers for handling sorting and paging. When i tried to use it in sps 2003 page it gave the following error: Object reference not set to an instance of an object. Here is the code which is wrote : using System; using System.Collections.Generic; using System.ComponentModel; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using Microsoft.SharePoint; using Microsoft.SharePoint.WebPartPag<WBR>es; using System.Xml; using System.Xml.Serialization; using System.Configuration; namespace MyNewGridView { [ DefaultProperty("Text")] [ ToolboxData("<{0}:WebTestGrid runat=server></{0}:WebTestGrid<WBR>>")] [ XmlRoot(Namespace="MyNewGridView")] public class WebTestGrid : WebPart { SqlConnection cnn; SqlCommand cmd; SqlDataAdapter da; DataSet ds; GridView gv; [ Bindable(true)] [ Category("Appearance")] [ DefaultValue("")] [ Localizable(true)] public string Text { get { String s = (String)ViewState["Text"]; return ((s == null) ? String.Empty : s); } set { ViewState[ "Text"] = value; } } protected override void CreateChildControls() { try { cnn = new SqlConnection(); string connectionstring = ConfigurationManager.ConnectionStrings["pubs"].ConnectionString; cnn.ConnectionString = connectionstring; cnn.Open(); cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from customer"; da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); gv = new GridView(); gv.AllowPaging = true; gv.AllowSorting = true; gv.PageSize = 2; gv.PageIndexChanging += new GridViewPageEventHandler(Page_change); gv.Sorting += new GridViewSortEventHandler(Page_sort); gv.DataSource = ds; gv.DataBind(); Controls.Add(gv); base.CreateChildControls(); } catch (Exception ex) { throw ex; } finally { da.Dispose(); cnn.Close(); } } protected override void RenderWebPart(HtmlTextWriter output) { gv.RenderControl(output); base.RenderWebPart(output); } public void Page_change(object sender, GridViewPageEventArgs e) { gv.PageIndex = e.NewPageIndex; show(); } public void show() { cmd.CommandText = "select * from Customer "; SqlDataAdapter da1 = new SqlDataAdapter(cmd); try { cnn.Open(); ds.Clear(); da1.Fill(ds); gv.DataSource = ds; gv.DataBind(); } catch (Exception ex) { throw ex; } finally { da1.Dispose(); cnn.Close(); } } public void Page_sort(object sender, GridViewSortEventArgs e) { int pageindex = gv.PageIndex; string str = e.SortExpression; cmd.CommandText = "select * from Customer order by " + str + " ASC"; SqlDataAdapter da2 = new SqlDataAdapter(cmd); try { cnn.Open(); ds.Clear(); da2.Fill(ds); gv.DataSource = ds; gv.DataBind(); gv.PageIndex = pageindex; } catch (Exception ex) { throw ex; } finally { da2.Dispose(); cnn.Close(); } } } } If you can help me , i would be very thankful for you. Thanks & Regard's, Manoj