My Happy Moments

My Problem :

The SQL 2005 did install correctly on my 64bit Vista but I was not able to log on to the server and it gave the following error

Login failed for user ‘PC-Name\UserName’. (.Net SqlClient Data Provider)

Error Number: 18456 – Severity: 14 – State: 1

Recently I was asked to write a code to send entire Aspx page as an HTML mail using VB.Net.
Private Function ReadAspxPage(ByVal url As String) As String
Dim htmlPage As String
Dim objResponse As System.Net.WebResponse
Dim objRequest As System.Net.WebRequest = System.Net.HttpWebRequest.Create(url)
objResponse = objRequest.GetResponse()
Dim readpage As New System.IO.StreamReader(objResponse.GetResponseStream())
htmlPage = readpage.ReadToEnd()
readpage.Close()
Return htmlPage.toString()
End Function

Share and Enjoy:

Private Function GetEmailTemplate(ByVal templateName As String) As String
Dim sr As IO.StreamReader = New IO.StreamReader(System.Web.HttpContext.Current.Server.MapPath(templateName))
Dim body As String = sr.ReadToEnd()
sr.Close()
sr.Dispose()
[...]

I was asked to read all Mail merge Files in an HTML Template and then perform a mail Merge.
The MailMerge Fields were like ##[Field]##.
So thought to use regex to find the fields.
The biggest task for me was to write a regex for Matching ##[Merge Fields]##.

Share and Enjoy:

I am writing this post to help people like me who are new to nunit. Bascially it’s easy to setup but some time it can be really hard for some people.

Share and Enjoy:

I had to display Yes or No based on databind this is how I did it.
<asp:Label ID=”IsUserActiveCheckBox” Text=’<%# if(Eval(“IsUserActive”),”Yes”,”No”) %>’
runat=”server” />
Also Bind will not work if you are databinding it.
Here is another example where I used code behind.
in Aspx :
<asp:RadioButtonList ID=”rbGLRSearch” runat=”server” RepeatDirection=”Horizontal”
OnSelectedIndexChanged=”EnableCluster” AutoPostBack=”true” SelectedValue=’<%# GetCheckBoxValue(Eval(“GLRSearch”)) %>’>
<asp:ListItem>Yes</asp:ListItem>
<asp:ListItem>No</asp:ListItem>
<asp:ListItem>N/A</asp:ListItem>
</asp:RadioButtonList>
in code behind :
Protected Function GetCheckBoxValue(ByVal bool) As [...]