{"id":392,"date":"2008-08-08T16:24:57","date_gmt":"2008-08-08T15:24:57","guid":{"rendered":"http:\/\/www.galhano.com\/blog\/?p=392"},"modified":"2008-08-09T00:40:23","modified_gmt":"2008-08-08T23:40:23","slug":"configuracao-para-comecar-a-utilizar-webparts","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=392","title":{"rendered":"Configura\u00c3\u00a7\u00c3\u00b5es para come\u00c3\u00a7ar a utilizar WebParts"},"content":{"rendered":"<p>Para come\u00c3\u00a7ar a usar Webparts \u00c3\u00a9 necess\u00c3\u00a1rio ter uma base de dados de suporte.<\/p>\n<p>Para criar essa base de dados \u00c3\u00a9 necess\u00c3\u00a1rios executar a aplica\u00c3\u00a7\u00c3\u00a3o<strong> aspnet_reqsql.exe <\/strong>que se encontra no directorio do .Net framework, normalmente <strong>C:\\WINDOWS\\Microsoft.NET\\Framework\\v2.0.50727<\/strong><\/p>\n<p>Depois \u00c3\u00a9 necess\u00c3\u00a1rio dar permiss\u00c3\u00b5es a um utilizador para aceder \u00c3  base de dados criada, no SQLServer.<\/p>\n<p>Estando o SQL preparado necessitamos de criar as liga\u00c3\u00a7\u00c3\u00b5es no nosso webSite:<\/p>\n<p>no ficheiro <strong>web.config<\/strong> devemos criar uma nova connection (por exemplo):<\/p>\n<p style=\"padding-left: 30px;\"><span style=\"color: #003366;\">&lt;connectionStrings&gt;<br \/>\n&lt;add name=&#8221;connASPNETDB&#8221; connectionString=&#8221;Server=MEUSERVER; Database=ASPNETDB; User Id=MEUUSER;Password=USERPASS;&#8221; providerName=&#8221;System.Data.SqlClient&#8221;\u00c2 \/&gt;<br \/>\n&lt;\/connectionStrings&gt;<\/span><\/p>\n<p>e definir o <strong>sqlpersonalization provider<\/strong> :<\/p>\n<p style=\"padding-left: 30px;\"><span style=\"color: #000080;\">&lt;webParts&gt;<br \/>\n&lt;personalization defaultProvider=&#8221;AspNetSqlPersonalizationProvider&#8221;&gt;<br \/>\n&lt;providers&gt;<br \/>\n&lt;clear\/&gt;<br \/>\n&lt;add name=&#8221;AspNetSqlPersonalizationProvider&#8221;<br \/>\ntype=&#8221;System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&#8221;<br \/>\nconnectionStringName=&#8221;connASPNETDB&#8221; \/&gt;<br \/>\n&lt;\/providers&gt;<br \/>\n&lt;\/personalization&gt;<br \/>\n&lt;\/webParts&gt;<\/span><\/p>\n<p>e bem-vindo ao mundo das webparts \ud83d\ude42<\/p>\n<p><strong><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para come\u00c3\u00a7ar a usar Webparts \u00c3\u00a9 necess\u00c3\u00a1rio ter uma base de dados de suporte. Para criar essa base de dados \u00c3\u00a9 necess\u00c3\u00a1rios executar a aplica\u00c3\u00a7\u00c3\u00a3o aspnet_reqsql.exe que se encontra no directorio do .Net framework, normalmente C:\\WINDOWS\\Microsoft.NET\\Framework\\v2.0.50727 Depois \u00c3\u00a9 necess\u00c3\u00a1rio dar permiss\u00c3\u00b5es a um utilizador para aceder \u00c3 base de dados criada, no SQLServer. Estando o [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,28,9],"tags":[181,68],"class_list":["post-392","post","type-post","status-publish","format-standard","hentry","category-code-snippets","category-aspnet-20","category-sql-server","tag-net","tag-webparts","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=392"}],"version-history":[{"count":0,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/392\/revisions"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}