Settings.Settings .NET C#

I just learned the newest feature for adding configuration to .NET application (Console, Windows Forms, Web forms, ets.)

Settings.Settings are created when you start your application. This allows you to build out Settings that scope either the application or user. But the big question was how do you access them in the code.

Simple.

Try this

Properties.Settins.Default.[Intellisense takes over and find your setting]

That easy.

InfoPath Designer Mode

Well, after all the research I found Tim Pash as you can see in the post below. It seems that in the Corporate Enviroment you have to request that you have the setting deployed to you by your Microsoft Office Deployment and Configuration team. So with that being said, if you do not see the designer feature in InfoPath send a request to you Information Technology Team.

InfoPath

Well,

I am now back contracting because of my love to CODE. I have a new venture at Bank of America using SharePoint, InfoPath, and Visual Basic for Applications (VBA). My first task is to figure out how to enable InfoPath to allow me to design?

I found a great resource from the Tim Pash: http://blogs.msdn.com/timpash/archive/2006/02/08/Prevent-Design-Mode-For-Users.aspx?CommentPosted=true#commentmessage

Update from comparison of two SQL tables

UPDATE o
SET Amount=Price
FROM orders o JOIN items i ON (o.ItemNumber=i.ItemNumber)

UPDATE o SET EmpActive = 0 FROM ComplianceEmployee o
JOIN ComplianceEmployeeLoad i ON (o.EmpID = i.EmpID)

GoDaddy.com System.Net.Mail Solution

Here is the C# version of the GoDaddy.com ASP.NET 2.0 Send Mail by Moojjoo http://www.mmwebs.com

Web.Config
<?xml version="1.0"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<system.web>

<customErrors mode="Off"/>
<compilation debug="true"/> <!-- Be sure to change this to false when going to production -->

</system.web>
<system.net>

<mailSettings>
<smtp>

<network

host="relay-hosting.secureserver.net" />
</smtp>

</mailSettings>
</system.net>

</configuration>



.cs code behind for your .aspx page

protected void btnSubmit_Click(object sender, EventArgs e)
{

MailMessage myMail = new MailMessage();

myMail.From = new MailAddress("from@yourdomain.com");
myMail.Subject = "Contact Form";

MailAddressCollection myMailTo = new MailAddressCollection();
myMail.To.Add("to@domain.com");

StringBuilder sb = new StringBuilder();
sb.Append("Last Name: " + txtFirstName.Text + "<br>");

sb.Append("First Name: " + txtFirstName.Text + "<br>");
sb.Append("Address: " + txtAddress.Text + "<br>");

sb.Append("City: " + txtCity.Text + "<br>");
sb.Append("State: " + ddlState.SelectedValue + "<br>");

sb.Append("Zip: " + txtZip.Text + "<br>");
sb.Append("Email: " + txtEmail.Text + "<br>");

sb.Append("Questions/Comments: " + txtQandC.Text + "<br>");string strBody = sb.ToString();
myMail.Body = strBody;

myMail.IsBodyHtml = true;

SmtpClient smtp = new SmtpClient();
smtp.Credentials = CredentialCache.DefaultNetworkCredentials;

try

{

smtp.Send(myMail);

myMail = null;
}

catch (System.Exception ex)
{

Response.Write(ex.Message);

}

}

Moojjoo Õ¿Õ

http://www.mmwebs.com

http://www.autoinventoryonline.com/

Advanced Unit Testing, Part I - Overview - The Code Project - C# Programming

Great article on Unit Testing

Advanced Unit Testing, Part I - Overview - The Code Project - C# Programming

ASP.NET 2.0 - Membership and Roles

Today, I have been working with SQL Server 2000 and Visual Studio 2005 to increase my speed in development by using Strongly Typed Datatypes and the Membership/Roles provided by SQL.

For now I am going to jump into using the Membership/Roles provided by ASP.NET.

Microsoft has made it easy to setup membership/role for you Web application, but did not explain the needs most freelance developers must use in order to use rented Web hosting space.

As for my self I develop on http://www.idevconsultants.com/ servers and they run SQL 2000. And not to mention I do not have keys to the server so I have to develop with what I can without making changes to IIS. This is the same for most developers.

So here is the trick to use this new membership tools.

Scott Gu blog http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx explains the ends and outs, but basically the secret is to run the following tool:

Open a command-line window on your system and run the aspnet_regsql.exe utility that is installed with ASP.NET 2.0 in under your C:\WINDOWS\Microsoft.NET\Framework\v2.0.xyz directory. This tool will build all the Tables, StoredProcs needed to run the membership tools in ASP.NET 2.0.

VERY IMPORTANT: Next in your WEB.CONFIG name your connection string to

















Again DO NOT I REPEAT DO NOT change the name...

Testing Visual Studio with Firefox

In my job I develop for Intranets (IE) and Internet (All Browsers) and order to test Firefox I found the following article which was crucial to setting up the Firefox browser for testing an ASP.NET 2.0 application in order to get NTLM to work.

http://brennan.offwhite.net/blog/2005/07/22/firefox-authentication-with-ntlm/

Be sure to add localhost to your proxy if needed.

SQL

This week I was told about a book titled, "Gurus Guide to Transact SQL". So being told about the book I headed to the local Borders with my daughter to check the book out. This book first and for most is better purchased online it is a lot cheaper.

This book is the ultimate guide to SQL Server Transact-SQL. T-SQL is a must for any developer utlizing SQL Server as their backend DBMS (Data Base Management System).

Back on the blog

Moojjoo here and I am would like to apologize for not writting more. Having a 7 month old is a lot of work and not to mention the full plate I have at work lately.

I am very excited that my current company R.J. Reynolds Tobacco Company is finally moving forward to ASP.NET 2.0 and Visual Studio 2005.

As for coding I have really been researching the ability to use tiers in development so I can use as much resuse as possible.

Til Later

Using .NET Outlook to send formatted email

Imports Microsoft.Office
Imports Microsoft.Office.Core
Imports System.Runtime.InteropServices
Imports Outlook = Microsoft.Office.Interop.Outlook


Public Class TestOutlookMail
Inherits System.Web.UI.Page

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
Private Sub InitializeComponent()

End Sub
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Private app As Outlook.ApplicationClass

'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
app = New Outlook.ApplicationClass
End Sub

'Private Sub button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' CreateEmailMessage()
'End Sub 'button1_Click


'Private Sub CreateEmailMessage()
' 'Initialize the envelope values.
' Dim strTo As String = "yourname@yourdomain.com"
' Dim strBCC As String = "yourname@yourdomain.com"
' Dim strCC As String = "yourname@yourdomain.com"
' Dim strSubject As String = "Outlook Automation"
' Dim strBody As String = "Hello World"

' 'Automate the Outlook mail item.
' app = New Outlook.ApplicationClass
' Dim mItem As Outlook.MailItemClass = CType(app.CreateItem(Outlook.OlItemType.olMailItem), Outlook.MailItemClass)
' 'Dim As Outlook.MailItemClass = CType(doc.MailEnvelope.Item, Outlook.MailItemClass)
' 'Outlook.MailItemClass mi = (Outlook.MailItemClass)app.CreateItem
' mItem.To = strTo
' mItem.BCC = strBCC
' mItem.CC = strCC
' mItem.Subject = strSubject
' mItem.BodyFormat = Outlook.OlBodyFormat.olFormatHTML
' mItem.HTMLBody = strBody
' 'mItem.ItemEvents_Event_Close += New Outlook.ItemEvents_CloseEventHandler(Me.wApp_Close)

' 'wApp.Visible = True

' ' Loop until there are no more references to release.
' While Marshal.ReleaseComObject(mItem) > 0
' End While
' mItem = Nothing

' ' Invoke the .NET garbage collector.
' GC.Collect()
' GC.WaitForPendingFinalizers()
'End Sub 'CreateEmailMessage

Private Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Subject As String = "This is my Subject"
Dim Body As String = "This is my Body"


Dim mi As Outlook.MailItemClass = CType(app.CreateItem(Outlook.OlItemType.olMailItem), Outlook.MailItemClass)
mi.BodyFormat = Outlook.OlBodyFormat.olFormatHTML
mi.HTMLBody = Body
mi.Subject = Subject
mi.Display(New Object)

Dim ni As Outlook.NoteItemClass = CType(app.CreateItem(Outlook.OlItemType.olNoteItem), Outlook.NoteItemClass)
ni.Body = "This is my Body again"
ni.Display(New Object)

Dim pi As Outlook.PostItemClass = CType(app.CreateItem(Outlook.OlItemType.olPostItem), Outlook.PostItemClass)
pi.Subject = Subject
pi.BodyFormat = Outlook.OlBodyFormat.olFormatHTML
pi.Body = Body

pi.Display(New [Object])
End Sub 'button1_Click


End Class

DropDown in DataGrid, How to Select

This is a two parter. First we will discuss on to add a "Select Value" to the Drop Down List after we populate the DropDown with Data from the Database then I will discuss how to Select that value using the OnItemDataBound from the DataGrid.

Inside the DataGrid you must use a Template like so

SQL Time Converter

Private Sub BuildSQLTime(ByVal strProdDate, ByVal strProdTime)
Dim SQLDateTime As DateTime
Dim strDate As String = strProdDate
Dim strTime As String = strProdTime

Dim DateArray(2) As String
DateArray(0) = strDate.Substring(0, 2)
DateArray(1) = strDate.Substring(2, 2)
DateArray(2) = strDate.Substring(4, 2)

Dim tempDateTime As String
Dim newDateTime As DateTime

tempDateTime = DateArray(1) & "/" & DateArray(2) & "/" & DateArray(0)
newDateTime = Convert.ToDateTime(tempDateTime & " " & strTime)
'newDateTime = DateTime.Now

lblResults.Text = newDateTime
End Sub

Update to Access Folders without reboot

Need to access a folder you were just given access to? No need to reboot. Simply go to Start > Run > Type CMD At the dos prompt type gpupdate

SQL Server Leading Zeros for CHAR Type

declare @DirectiveNumber char(6)
declare @DirLength int



SET @DirectiveNumber = (SELECT DirectiveNumber FROM dbo.tblPlants WHERE PlantId = '1201')

--UPDATE dbo.tblPlants SET DirectiveNumber =
SET @DirectiveNumber = @DirectiveNumber + 1

Select @DirLength = LEN(@DirectiveNumber)

IF (@DirLength = 1)
SET @DirectiveNumber = '00000' + @DirectiveNumber
IF (@DirLength = 2)
SET @DirectiveNumber = '0000' + @DirectiveNumber
IF (@DirLength = 3)
SET @DirectiveNumber = '000' + @DirectiveNumber
IF (@DirLength = 4)
SET @DirectiveNumber = '00' + @DirectiveNumber
IF (@DirLength = 5)
SET @DirectiveNumber = '0' + @DirectiveNumber

UPDATE dbo.tblPlants SET DirectiveNumber = @DirectiveNumber WHERE PlantId = '1201'

SELECT @DirectiveNumber

ASP.NET 2.0

WOW,

Well I just deployed my first ASP.NET 2.0. What a difference from 1.x.

I learned that you can deploy by using a publish and precompiled mode that will not cause a slow load the first time a user accesses the site, but the issue with using that is that when you make change you have to redeploy all the .aspx and .dll files again. That kinda sucks.

However, after a little research I found a tool that add-ons from microsoft: http://msdn.microsoft.com/asp.net/reference/infrastructure/wdp/

This feature more reflects the ASP.NET 1.x way of creating dlls

How do I hide a column in my Datagrid if AutoGenerateColumns is set to True?

Question: How do I hide a column in my Datagrid if AutoGenerateColumns is set to True?

Answer: AutoGenerated columns do not appear in the Datagrid's Columns() collection, and so the usual method of hiding a Datagrid column will fail:

'Will NOT work for AutoGenerated columns:
Datagrid1.Columns(1).Visible = False

So the place to handle this is in the ItemDataBound event of the Datagrid:

<asp:DataGrid id="Datagrid1" runat="server" AutoGenerateColumns="True" OnItemDataBound="Datagrid1_OnItemDataBound"/>

Codebehind
Private Sub Datagrid1_OnItemDataBound(s As Object, e As DatagridItemEventArgs)
e.Item.Cells(1).Visible = False
End Sub

AUTOEVENTWIREUP .NET

WARNING...

Auto Event Wireup will fire your ASP.NET pages twice be warned.

Parse Error When adding new Web pages to application

I am banging my head on this one... All of my other Web forms work fine but now...

I am getting the following error when adding new Web forms to my application:

I just added simple Web form with Hello World typed on the page.

Server Error in '/XXX.QuipSap.WebUi' Application.



Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'XXX.QuipSap.WebUi.TestForm'.

Source Error:

Line 1: <%@ Page Language="vb" AutoEventWireup="false" Codebehind="TestForm.aspx.vb" Inherits="XXX.QuipSap.WebUi.TestForm"%>
Line 2:
Line 3:

Source File: c:\inetpub\wwwroot\XXX.QuipSap.WebUi\TestForm.aspx Line: 1


SOLUTION:
OK as crazy as a solution that this sounds, but I am not to happy with the solution but it works.

When I create add a new Web form I just remove the inherits part from the first line of the aspx page. If I add labels or buttons and double click on them VS.NET 2003 adds back the inherits and magically (HMM I say magically because if I knew what was fixing it I would not be writting this) fixes the issue.

Parse Error When adding new Web pages to application

I am banging my head on this one... All of my other Web forms work fine but now...

I am getting the following error when adding new Web forms to my application:

I just added simple Web form with Hello World typed on the page.

Server Error in '/XXX.QuipSap.WebUi' Application.



Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'XXX.QuipSap.WebUi.TestForm'.

Source Error:

Line 1: <%@ Page Language="vb" AutoEventWireup="false" Codebehind="TestForm.aspx.vb" Inherits="XXX.QuipSap.WebUi.TestForm"%>
Line 2:
Line 3:

Source File: c:\inetpub\wwwroot\XXX.QuipSap.WebUi\TestForm.aspx Line: 1


SOLUTION:
OK as crazy as a solution that this sounds, but I am not to happy with the solution but it works.

When I create add a new Web form I just remove the inherits part from the first line of the aspx page. If I add labels or buttons and double click on them VS.NET 2003 adds back the inherits and magically (HMM I say magically because if I knew what was fixing it I would not be writting this) fixes the issue.