Use Dynamic stylesheet class for messages in Asp.Net

Hi,

In the web application, some times we need to use a message style for
only one Label, like, suppose if our data has been added successfully, we display
message like 'Records has been added successfully'. So, depend on
system's different situation, we have to display label message with style color
combination.

So, Here you can find the solution. By it, you can display your message
with sytle as per your system's situation.

Just copy and paste the style script and copy C# method in your page.

You can find it here...



(Download these images for stylesheet)

protected void Page_Load(object sender, EventArgs e)
{
lblMessage.Text = "Records has been Added Successfully.";
this.SetStyle(lblMessage, MessageType.Info);
}

private void SetStyle(Label objLabel, MessageType msgType)
{
if (string.IsNullOrEmpty(objLabel.Text.Trim()))
objLabel.CssClass = "";
else
{
switch (msgType)
{
case MessageType.Error:
objLabel.CssClass = "MessageError";
break;
case MessageType.Info:
objLabel.CssClass = "MessageInfo";
break;
case MessageType.Success:
objLabel.CssClass = "MessageSuccess";
break;
}
}
}

// Define enum in the outer side of your page class.
public enum MessageType
{
Success,
Info,
Error
}

Now, Run your page and check it.

That's it !
Hope you will like it.

Create and Export-Import Excel file in Asp.Net

Create and Export-Import Excel file in Asp.Net
=======================================

// This method create an Excel file and export it for download
private void CreateExcelFileandDownload()
{

try
{
// Create a new Excel file.

string[] connectStrings = new string[] {
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"C:\\TEMP\\TestExcel2003Output.xls\";Extended Properties=\"Excel 8.0;HDR=Yes;\";",
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"C:\\TEMP\\TestExcel2007Output.xlsx\";Extended Properties=\"Excel 12.0 Xml;HDR=Yes;\";"
};

string dropTableStmt = "DROP TABLE [test]";
string createTableStmt = "CREATE TABLE [test] ( [Integer] int, [String] varchar(40), [Double] float, [Date] datetime, [Boolean] bit )";
string insertStmt = "INSERT INTO [test] ([Integer], [String], [Double], [Date], [Boolean]) VALUES ({0}, '{1}', {2}, '{3}', {4})";
object[] data = new object[] {

new object[] { 2628013, "Anderson", 0.617715356, new DateTime( 2008, 5, 5 ), true },

new object[] { 2628015, "Rainaud", 0.64933168, new DateTime( 2007, 4, 10 ), false },

new object[] { 2628017, "Dennis", 0.62140731, new DateTime( 2006, 3, 15 ), true },

new object[] { 2628019, "Schoenster", 0.599058708, new DateTime( 2005, 2, 20 ), false },

new object[] { 2628041, "Ganun", 0.593402527, new DateTime( 2004, 1, 25 ), true }

};

foreach (string connect in connectStrings)
{
OleDbConnection con = new OleDbConnection(connect);
con.Open();
if (con.State == ConnectionState.Open)
{
OleDbCommand cmd = con.CreateCommand();
cmd.CommandTimeout = 0;
try
{
// Only need this on runs subsequent to first time
cmd.CommandText = dropTableStmt;
cmd.ExecuteNonQuery();
}
catch
{
// First run will cause exception because table (worksheet) doesn't exist
}

cmd.CommandText = createTableStmt;
cmd.ExecuteNonQuery();
foreach (object[] row in data)
{
cmd.CommandText = String.Format(insertStmt, row[0], row[1], row[2], row[3], row[4]);
cmd.ExecuteNonQuery();
}

cmd.Dispose();
if (con.State == ConnectionState.Open)
con.Close();
con.Dispose();
}
}

// Download Created File

// For Office 2007 format
string FileName = @"C:\TEMP\TestExcel2007Output.xlsx";
// For Office 97 - 2003 format
string FileName2 = @"C:\TEMP\TestExcel2003Output.xls";

Response.Clear();
Response.ClearContent();
Response.ContentType = "application/vnd.xls";
Response.AddHeader("Content-Disposition", "attachment; filename=Name.xlsx;");

byte[] buffer = System.IO.File.ReadAllBytes(FileName);

System.IO.MemoryStream mem = new System.IO.MemoryStream();
mem.Write(buffer, 0, buffer.Length);

mem.WriteTo(Response.OutputStream);
Response.End();
}
catch (Exception ex)
{
// throw an exception
}

}

SW DEVELOPER'S PROFILE

About me: I think I am changing the world, but I am not. I think I am contributing to the Indian economy, but I guess I am not. I think I love my work, but I do not. I think I hate all people who made me earn my engineering degree, and I do. I think I am living, but and most importantly, I am LOOKING for someone Ok...I won't be funny anymore. I am a cool guy with a zeal to enjoy life (If you know me--> "Just stop laughing"

Birthday : The day my PL is about to fire me.

Age : 10111

Here for : web browsing in company hours.

Children : can't be (hey, don't get me wrong here)

Languages I speak : Java, C/C++, 010101110101

Religion: I get holidays on all religious festivals, so I love all religions.

Political view : the guy sitting beside me is a pig

Humor : weekly.

Fashion: Ask my company HR. Btw, I like jeans, t-shirt and a cross-bag.

Smoking: The second greatest pleasure on the earth.

Drinking : The first is this.

Pets: Yeah, my PL looks like a dog.

Living: Common, this is a stupid one. How can this be asked to a software engineer? Believe me, I am living

Hometown : My company (Oh God! Please bring my appraiser to this page)

Webpage: http://naukri.com, http://jobsahead.comß- Isnt it Ultimate?

Passions: searching for the cheapest pub around, cursing my company, looking for other company, remembering my good old college days, worrying about my future.

Sports: quake, CS (Counter Strike), computer chess.

Books : "How to lose weight in 20 days?", "How to live a happy life?", "101 ways to attract a girl", "Java Unleashed", "C++ at your footsteps", Others censored.

Music: Metallica, Pink Floyd, Nirvana, ACDC,BSB and anything depressing.

Tv shows : can't afford one.

Cuisines: Bread Butter, Maggi, anything available within 200 meteres of Home

Regards,
MILIND KANSAGARA.

SW DEVELOPER'S PROFILE

About me: I think I am changing the world, but I am not. I think I am contributing to the Indian economy, but I guess I am not. I think I love my work, but I do not. I think I hate all people who made me earn my engineering degree, and I do. I think I am living, but and most importantly, I am LOOKING for someone Ok...I won't be funny anymore. I am a cool guy with a zeal to enjoy life (If you know me--> "Just stop laughing"

Birthday : The day my PL is about to fire me.

Age : 10111

Here for : web browsing in company hours.

Children : can't be (hey, don't get me wrong here)

Languages I speak : Java, C/C++, 010101110101

Religion: I get holidays on all religious festivals, so I love all religions.

Political view : the guy sitting beside me is a pig

Humor : weekly.

Fashion: Ask my company HR. Btw, I like jeans, t-shirt and a cross-bag.

Smoking: The second greatest pleasure on the earth.

Drinking : The first is this.

Pets: Yeah, my PL looks like a dog.

Living: Common, this is a stupid one. How can this be asked to a software engineer? Believe me, I am living

Hometown : My company (Oh God! Please bring my appraiser to this page)

Webpage: http://naukri.com, http://jobsahead.comß- Isnt it Ultimate?

Passions: searching for the cheapest pub around, cursing my company, looking for other company, remembering my good old college days, worrying about my future.

Sports: quake, CS (Counter Strike), computer chess.

Books : "How to lose weight in 20 days?", "How to live a happy life?", "101 ways to attract a girl", "Java Unleashed", "C++ at your footsteps", Others censored.

Music: Metallica, Pink Floyd, Nirvana, ACDC,BSB and anything depressing.

Tv shows : can't afford one.

Cuisines: Bread Butter, Maggi, anything available within 200 meteres of Home

Regards,
MILIND KANSAGARA.