SQL Server 2012 Express Edition – Error Enabling Full Text Search

May 2nd, 2012

I recently wanted to try out the new version of SQL Server 2012 Express Edition with Advanced Services. Microsoft blog states that this version offers Full Text Search, so I was surprised when I received the following error trying to set up a new catalog.

Full-text is not supported on this edition of SQL Server. (Microsoft.SqlServer.Smo)

It appears that Full-text index is available, but not through the GUI.  I had to script the catalog and the creation of the full text index.

To accomplish this again, a link to Microsofts Full Text MSDN page is helpful.

http://msdn.microsoft.com/en-us/library/ms187317.aspx

SQL Server ,

Notes on SQLMembership Provider using the MembershipProvider Class

November 15th, 2011

1. Set the tag to use “forms” in the config
2. use the reg_sql to generate the SQL tables for use with SQLMembership Provider.
3. Add 4. Can use membership.createuser(“UN”,”PW”,”Email”) to create user.
5. Methods include:Createuser, ValidateUser, DeleteUser, FinduserByName,finduserByEmail,GenPassword
6.Options to capture other user info with ProfileSystem, and defining provider properties in webconfig. Or simply adding additional tables.

 

[tester]

Membership

Table to Excel XLS code

November 15th, 2011

Dim StringWriter1 As IO.StringWriter
Dim StringBuilder1 As StringBuilder = New StringBuilder
StringWriter1 = New IO.StringWriter(StringBuilder1)
Dim TextWriter1 As HtmlTextWriter = New HtmlTextWriter(oStringWriter)
label.RenderControl(oTextWriter)
Response.Clear()
Response.ClearHeaders()
Response.ContentType = “application/vnd.xls”
Response.AddHeader(“Content-Disposition”, “attachment;filename=WLMS-exlfile.xls”)
Response.Write(StringWriter1.ToString())
Response.Flush()
Response.End()

ASP.NET

New Website Checklist

November 14th, 2011

Checklist
· Twitter Account
· Facebook Business Page Account
· Google Business
· Linked In Business Page
· Human.txt
· Robot.txt
· Emails
· News Letters
· Privacy Policy
· Contact Us
· Sitemap
· Blog
· Forum
Website Tools
· Google Webmaster Tools
· Google Alerts
· Google Keyword Tools
· addThis
· Google Page Speed
· Mozrank (Metrics)
· Google Analytics (Metrics)
· Spotify
· Intense Debate
· Feedburner
Guidelines
· Schema.org
Features
· OpenAuth
WP Specific
· Forum
· Akismet
· Allow PHP
SEO
· Linkbuilding

Architecture

Google Blueprint CSS Love

November 1st, 2011

Microsoft Project Code Name Velocity

November 1st, 2011

Microsoft Velocity provides distributed in-memory web application caching. This provides highly scalable, high-performance application caching. “Velocity Caching” can be used to cache any Common Language Runtime (CLR is the Virtual Machine of Microsoft’s .NET initiative) through simple API’s. From a general standpoint, Velocity was created with the goal of providing performance, scalability and availability.

The main application for providing scalable, available, high-performance applications using Velocity is by fusing the memory between multiple computers to give a single/unified cache view for the application to employ.The application can they store any CLR object that is serializable.

http://blogs.msdn.com/velocity/

Caching ,

Microsoft and PHP Patterns and Practices

November 1st, 2011

http://msdn.microsoft.com/en-us/practices/default.aspx

According to Microsoft P&P (Patterns and Practices) were created to meet the demands of architects and application developers.By following proven patterns and practices it is suggested that more sound applications will be the result. Included in P&P

  • How to design
  • Develop
  • Deploy
  • Operate architecturally sound applications on a Microsoft platform.

P&P for Web Applications

http://msdn.microsoft.com/en-us/practices/bb969054.aspx#web_apps

PHP Patterns and Practices

http://www.phppatterns.com/docs/start

Architecture

Calling WebService from Javascript Error

August 26th, 2011

I recently wasn getting the following error when trying to call a webservice from javascript.

“Request format is unrecognized for URL unexpectedly ending in ‘/Search’.”

I was able to invoke the web services from the test page offered by visual studio, but accessing it outside the invoke method on the test page would not work.

By default, webservices protocols are not added to the webconfig. To access normal get/post services you will need to add the following in the <system.web> node.

<webServices>
<protocols>
<add name="HttpPost"/>
<add name="HttpGet"/>
</protocols>
</webServices>

 

WebService

CSS 3 and HTML 5 Button

July 29th, 2011
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
 
<head runat="server">
 
    <title></title>
 
    <style type="text/css">
 
                /*Button*/
 
                .button {
 
                        display: inline-block;
 
                        outline: none;
 
                        cursor: pointer;
 
                        text-align: center;
 
                        text-decoration: none;
 
                        font: 14px/100% Arial, Helvetica, sans-serif;
 
                        font-weight:bold;
 
                        padding: .5em 2em .55em;
 
                        text-shadow: 0 1px 1px rgba(0,0,0,.3);
 
                        -webkit-border-radius: .5em;
 
                        -moz-border-radius: .5em;
 
                        border-radius: .5em;
 
                        border-radius: 15px 15px 15px 15px;
 
                        -webkit-box-shadow: 0 1px 2px rgba(0,0,0,.2);
 
                        -moz-box-shadow: 0 1px 2px rgba(0,0,0,.2);
 
                        box-shadow: 0 1px 2px rgba(0,0,0,.2);
 
                }
 
                .button:hover {
 
                        text-decoration: none;
 
                }
 
                .button:active {
 
                        position: relative;
 
                        top: 1px;
 
                }
 
                /*Gradient*/
 
                .orange {
 
                        color: #fef4e9;
 
                        border: solid 1px #da7c0c;
 
                        background: #f78d1d;
 
                        background: -webkit-gradient(linear, left top, left bottom, from(#faa51a), to(#f47a20));
 
                        background: -moz-linear-gradient(top,  #faa51a,  #f47a20);
 
                        filter:  progid:DXImageTransform.Microsoft.gradient(startColorstr='#faa51a', endColorstr='#f47a20');
 
                }
 
                .orange:hover {
 
                        background: #f47c20;
 
                        background: -webkit-gradient(linear, left top, left bottom, from(#f88e11), to(#f06015));
 
                        background: -moz-linear-gradient(top,  #f88e11,  #f06015);
 
                        filter:  progid:DXImageTransform.Microsoft.gradient(startColorstr='#f88e11', endColorstr='#f06015');
 
                }
 
                .orange:active {
 
                        color: #fcd3a5;
 
                        background: -webkit-gradient(linear, left top, left bottom, from(#f47a20), to(#faa51a));
 
                        background: -moz-linear-gradient(top,  #f47a20,  #faa51a);
 
                        filter:  progid:DXImageTransform.Microsoft.gradient(startColorstr='#f47a20', endColorstr='#faa51a');
 
                }
 
    </style>
 
</head>
 
<body>
 
    <form id="form1" runat="server">
 
    <div>
 
    <a href="#" class="button orange">Orange</a>
 
    </div>
 
    </form>
 
</body>
 
</html>

Uncategorized

Setting the SelectedValue of RadioButtonList & DropDownList in GridView EditItemTemplate

June 19th, 2011

Here is a trick one, because IntelliSense doesn’t bring up the “SelectedValue” property for a RadioButtonList, or a DropDownList in an EditItemTemplate for GridViews you may forget that “SelectedValue” is an actual property of these controls.

Here is how you can set the selected value of a RadioButtonList inside an EditItemTemplate

<asp:TemplateField HeaderText="Payment">
<ItemTemplate>
    <asp:Label ID="lablePayment" runat="server" Text='<%#Eval("PayName")%>' />
</ItemTemplate>
<EditItemTemplate>
  <asp:RadioButtonList Runat = "server" ID="rblPaymentType" SelectedValue='<%#Eval("PayTypeID")%>'>
    <asp:ListItem Text="Check" Value="1"></asp:ListItem>
    <asp:ListItem Text="Credit Card" Value="2"></asp:ListItem>
  </asp:RadioButtonList>
</EditItemTemplate>
</asp:TemplateField>

ASP.NET