Sahan's Blog

Validation Summary Control and Enter key submit ASP.NET

2011-01-16T10:19:00.000-08:00

When you use enter key to sumbit data the validations are working properly but most of the time the validation summary not fired as a part of the validation. To over come this problem you can include some JavaScript code in the form or div section of the ASP.NET form.

How to get enter key to submit data while avoiding validation summary problem.

protected void Page_Load(object sender, EventArgs e)
{
       if (!Page.IsPostBack)
       {
             // Add new attribute to form1 event to fire when enter key submit button click event
             form1.Attributes.Add("onkeydown", "javascript: return WebForm_FireDefaultButton (event, '"  +      ButtonName.ClientID + "')");

             // Allow you to use enter key for sumbit data
             ClientScript.RegisterHiddenField("__EVENTTARGET", "ButtonName");
       }
}

// Then add this Page_Load event to div section on the form1
div id="inputArea" onkeypress="javascript:return WebForm_FireDefaultButton(event,'ButtonName')"

Hope this helps,
Cheers :)

MCTS (70-515) Examination .NET 4.0

2011-01-03T04:44:00.000-08:00

MCTS (70-515) Web Application Development with Microsoft .NET Framework 4 self-paced training kit has been released and you can buy it online using below link.

If you are in UK - http://www.amazon.co.uk/MCTS-Self-Paced-Training-Exam-70-515/dp/0735627401

If any where else - http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-515/dp/0735627401

How to create simple stored procedures in SQL Server - Select, Insert/Update, Delete

2010-12-21T15:08:00.000-08:00

Think you have a table called [CallbackDates] which has included only two colums named ID and CallBackDate. Create table SQL Query as follow.

CREATE TABLE "CallbackDates" (
"ID" INT not null,
"CallBackDate" DateTime not null)

Then you can create stored procedures using SQL.

Stored procedure - Select

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_SelectCallbackDates]
@ID int
AS
BEGIN
SET NOCOUNT ON

SELECT
  [ID],
  [CallbackDate]

FROM [dbo].[CallbackDates]
WHERE
  ([ID] = @ID)

END

Stored procedure - Insert

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_InsertCallbackDates]
@ID int = NULL OUTPUT,
@CallbackDate datetime

AS
BEGIN
SET NOCOUNT ON

INSERT
INTO [dbo].[CallbackDates]
(
  [CallbackDate]
)
VALUES
(
  @CallbackDate
)
SELECT @ID = SCOPE_IDENTITY()
END

In this case I have used some proper naming types for the stored procedure name.

Stored procedure - Update

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_UpdateCallbackDates]
@ID int,
@CallbackDate datetime

AS
BEGIN
SET NOCOUNT ON

UPDATE [dbo].[CallbackDates]
SET
  [CallbackDate] = @CallbackDate
WHERE
  [ID] = @ID

END

Stored procedure - Delete

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[proc_DeleteCallbackDates]
@ID int

AS
BEGIN
SET NOCOUNT ON

DELETE
FROM [dbo].[CallbackDatess]
WHERE
  [ID] = @ID

END

Create Outlook VCalendar reminder file and attach it into an email using C#.net

2010-09-05T12:04:00.000-07:00

Using the below code example you can create Outlook calendar file with extention .ics. Then, using System.Net.Mail you can attach it into an email as binary data.

// CreateAppointment creates email attachment containing outlook calendar file.
// Attachment representing a calendar appointment

string AppointmentFileName = "Your file name";
string AppointmentSummary = "Your appointment summary";
string AppointmentDescription = "Your appointment description";
int AppointmentDuration = 20;            // Choose appropriate time duration
private System.Net.Mail.Attachment CreateAppointment()
{

// Building .ics file string

string filestring = "BEGIN:VCALENDAR" + Environment.NewLine +
                         "VERSION:1.0" + Environment.NewLine +
                         "BEGIN:VEVENT" + Environment.NewLine +
                         "DTSTART:" + DateTime.Parse(TextBoxDate.Text).ToString("s") + Environment.NewLine +
                         "DTEND:" + DateTime.Parse(TextBoxDate.Text).AddMinutes                                            (AppointmentDuration).ToString("s")
                        + Environment.NewLine +
                         "SUMMARY:" + AppointmentSummary + Environment.NewLine +
                         "DESCRIPTION:" + AppointmentDescription + Environment.NewLine +
                         "END:VEVENT" + Environment.NewLine +
                         "END:VCALENDAR";

// Convert filestring into binary.

byte[] filedata = Encoding.UTF8.GetBytes(filestring);
MemoryStream memorystream = new MemoryStream(filedata);

System.Net.Mail.Attachment appointment = new System.Net.Mail.Attachment(memorystream, AppointmentFilename, "text/calendar");

return appointment;
}

Insert line breaks in SQL text data

2010-09-04T16:00:00.000-07:00

Think, you want to insert text data into SQL server database as seperate lines. The answer is very simple. You can use following sql query...

INSERT INTO tableName(colunmName1, columnName2, ....)
VALUES ('Text Line One' + char(13) + char(10) + 'Text Line Two', columnName2 Value so on...)

Then the text data stored as two lines in the database.

Text Line One
Text Line Two

If you need to break two lines then you can use + char(13) + char(10) + char(13) + char(10) +
insted of + char(13) + char(10) +
It'll be return

Text Line One

Text Line Two

How to create Windows Vista Sidebar Gadgets...

2008-03-28T04:20:00.000-07:00

It is really easy to create vista gadgets when you are going to create very small vista gadgets...
But when you are going to create more advance gadgets (ex : CountDown Timer, Rssfeed news gadget etc...) then you have to write more coding to get into your goals. Most of time we have to use JavaScript, XML, HTML as programming languages for the gadget development, therefore you should have good knowledge in JavaScript and XML also HTML...

Use following links to get more details about the coding and the other required background...

http://blogs.techrepublic.com.com/window-on-windows/?p=577
http://archworx.wordpress.com/2006/11/05/how-to-create-a-vista-sidebar-gadget/
http://www.codeproject.com/KB/gadgets/DailyDilbert.aspx

How to use Rss Feed to your website to increase the efficiency

2008-03-28T03:55:00.000-07:00

It's very simple to add Rss Feed to your website when you are using ASP.NET for the development. Dmitry and the ASP.NET development team provided RssToolkit(Free Download). What you have to do is add the RssToolkit to your project and follow the instruction as they mentioned...

How to download and add RssToolkit to your porject...

Visit Dmitry blog : http://blogs.msdn.com/dmitryr/archive/2006/02/21/536552.aspx

Scottgu have implemented it as follows, it's very easy to understand to you to get more details about consuming RssFeed... http://weblogs.asp.net/scottgu/archive/2006/02/22/Awesome-ASP.NET-2.0-RSS-Tool_2D00_Kit-Released.aspx

If you are need to produce RssFeed to your website, then use following link to get more deatails...

http://www.codeplex.com/ASPNETRSSToolkit/Wiki/View.aspx?title=Producing%20Feeds&referringTitle=Home

How to Upload a larger size file into the web server

2008-02-11T02:04:00.000-08:00

In the button click event you can write following code to upload a file in to the web server...

(Code Behind file)

private void Submit1_ServerClick(object sender, System.EventArgs e)
{

if( (uploadfile.PostedFile != null ) && (uploadfile.PostedFile.ContentLength > 0 ) )
{

string fn = System.IO.Path.GetFileName(uploadfile.PostedFile.FileName);
string SaveLocation = Server.MapPath("Data") + "\\" + fn;

try
{

uploadfile.PostedFile.SaveAs(SaveLocation);
Response.Write("The file has been uploaded.");

}
catch ( Exception ex )
{

Response.Write("Error: " + ex.Message);
}
}

else
{

Response.Write("Please select a file to upload.");

}
}

Then you should change the httpRuntime section in the Web.config file as follows...

<
httpRuntime
executionTimeout="90"
maxRequestLength="4096"
useFullyQualifiedRedirectUrl="false"
minFreeThreads="8"
minLocalRequestFreeThreads="4"
appRequestQueueLimit="100"
/>

How to upload an IMAGE in DetailsView ItemInserting event ASP.NET, C#

2008-02-06T02:46:00.000-08:00

Now you can upload an images, remarkably easy way. Following code demonstrates that how it can easily implemente in C# code...

protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{

if (((FileUpload)DetailsView1.FindControl("FileUpload1")).HasFile)
{

((FileUpload)DetailsView1.FindControl("FileUpload1")).SaveAs(System.Configuration.ConfigurationManager.AppSettings["ItemImagePath"].ToString() + ((FileUpload)DetailsView1.FindControl("FileUpload1")).FileName.ToString());

SqlDataSource1.InsertParameters[8].DefaultValue = ((FileUpload)DetailsView1.FindControl("FileUpload1")).FileName.ToString();

}

}

The code demonstrates that, the image will be saved in the name called "Imagepath" at Web.config file. And the image name will be saved in Database (Datasource1).
Then you should specify the image path in the Web.config file as follows...

<>
< key="ItemImagePath" value="D:\Projects\My Project\www.demoproject.com\images">
< /appSettings >

Sending e-mail using System.Net.Mail, ASP.net C#

2008-01-29T02:22:00.000-08:00

It is really easy to send e-mails using the System.Net.Mail. Below C# code demonstrates more details...

If you want to send an email using button click event, then you can do this as below...

protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
MailMessage message = new MailMessage(FromTextBox.Text, ToTextBox.Text, SubjectTextBox.Text, MessageTextBox.Text);

SmtpClient emailClient = new SmtpClient("SMTPSERVER");
emailClient.Send(message);

Status.Text = "Message Successfully Sent";
}
catch (Exception ex)
{
Status.Text = ex.ToString();
}

After writing the above code, you should configure Web.config file to send e-mails as below...

<>
<>
<>
< networkhost="mail.inzeek.com">
port="25"
userName=sahan@inzeek.com
password=mailto:password=sahan@inzeek.com />
< / smtp >
< / mailSettings >
< / system.net>

DataList & FormView event handling...ASP.Net, C#

2008-01-27T21:25:00.000-08:00

The following code demonstrates how to insert DataList values into another table, in the same Session.

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("Command Name"))
{
DSAddToCart.InsertParameters[0].DefaultValue = Session.SessionID.ToString();
DSAddToCart.InsertParameters[1].DefaultValue = DataList1.DataKeys[e.Item.ItemIndex].ToString();
DSAddToCart.InsertParameters[2].DefaultValue = "1";
DSAddToCart.InsertParameters[3].DefaultValue = ((Label)e.Item.FindControl("UnitPriceLabel")).Text.ToString();
DSAddToCart.InsertParameters[4].DefaultValue = ((Label)e.Item.FindControl("UnitPriceLabel")).Text.ToString();
DSAddToCart.Insert();
}
}
catch (Exception)
{
}

FormView event handling...

Assign a FormView label value into string variable name.

string name = ((Label)FormView2.FindControl("LabelName")).Text.ToString();

GridView events...ASP.Net, C#

2008-01-27T20:25:00.000-08:00

.Net freamwork very powerful with supporting event handlers.

Useful codings in GridVeiw events. After cliking the "Select" Command name button, suppose, you want to get value into the LableName, then you can do it using following code.

Retrieve a GridView value and put into another Label or somewhere...

protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Select"))
{
GridViewRow row = (GridViewRow)((Control)e.CommandSource).Parent.Parent;

DataSource.UpdateParameters[0].DefaultValue = ((Label)GridView2.Rows[row.RowIndex].FindControl("LabelName")).Text.ToString();
DataSource.Update();
FormView1.DataBind();
}
}

ASP.Net Web.config File

2008-01-23T21:24:00.000-08:00

Do you know how it is important to have a good knowledge about the "Web.config" file..?
Here some related examples...
Create or change Login settings...

We can simplify our code by using the Web.config. It's very easy to change the mode. If you need "form" authentication mode, see below...

Should be Inside the tags

< mode="Forms">
< timeout="30" loginurl="~/login.aspx">< /forms>
< /authentication>

Then we should indicate location(What is the directory or pages not allow to access to other out side users) and authorization (Who has allowed to access to the secure pages) properties.
see below...

< path="Cp" allowoverride="true">
<>
<>
< users="?">
< /authorization>
< /system.web>
< /location>

Create database connection...

You can create database connection in Web.config using below code. Then you can use this connection anywhere. How easy........?

Out side the tags

"
<>
< name="DemoConnectionString" connectionstring="Data Source=.;Initial Catalog=Demo;User ID=sa;Password=sa" providername="System.Data.SqlClient">
< /connectionStrings> "

Set image path...

When you are going to upload images to the website, then you can set image path using in the web.config file.

Outside the tags

"
<>
< key="ItemImagePath" value="D:\Projects\My Project\www.demoproject.com\images">
< /appSettings> "

Support e-mailling...

System.Net.Mail allowed us to send and recieve email prety handy way in the .net framework. Here some code examples of C# and web.config configuration for email settings.

ButtonClik event handler code

MailMessage message = new MailMessage();
message.From = new MailAddress(" sender@domainName ");

message.To.Add(new MailAddress(" recipient e-mail adress1 "));
message.To.Add(new MailAddress(" recipient e-mail adress2 "));

message.CC.Add(new MailAddress(" carboncopy@domainName "));
message.Subject = "This is my subject";
message.Body = "This is the content";

SmtpClient client = new SmtpClient();
client.Send(message);

Then you should set the Web.config configurations for e-mails.
Web.config code...

< from="sahan@inzeek.com">
< host="mail.inzeek.com" port="25" username="sahan" password="sahan" defaultcredentials="true">

My first words...!

2008-01-19T00:44:00.000-08:00

Finally, I have created a web blog. it's so easy to create a web blog using the free templates. And I would like to post more general and important things which are related to the Microsoft technologies basically ASP.NET, C# development categories. Also I would like to invite you to keep link with my blog and find somthing interesting.