Convert enum to hashtable for dropdown list binding

We have one enum

enum ContractType

{

    Permanent = 1,

    Contract = 2,

    Internship = 99

}

Below function for convert enum to hashtable

public static Hashtable BindToEnum(Type enumType)

{

    // get the names from the enumeration

    string[] names = Enum.GetNames(enumType);

    // get the values from the enumeration

    Array values = Enum.GetValues(enumType);

    // turn it into a hash table

    Hashtable ht = new Hashtable();

    for (int i = 0; i < names.Length; i++)

        // note the cast to integer here is important

        // otherwise we'll just get the enum string back again

        ht.Add(names[i], (int)values.GetValue(i));

    // return the dictionary to be bound to

    return ht;

}

Now we can direct call above function for convert enum to hashtable and use for dropdown bind.

MyDropDownList.DataSource = BindToEnum(typeof(ContractType));

Hope you will help above code !!

Read More

How to restore database when database was suspect

EXEC sp_resetstatus DataBaseName;
ALTER DATABASE DataBaseName SET EMERGENCY
DBCC checkdb(DataBaseName)
ALTER DATABASE DataBaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (DataBaseName, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DataBaseName SET MULTI_USER

Read More

How to call server side function using JQuery in Asp.net

Click Here for Download Source Code

Below is Default.aspx page code
-------------------------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" 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 id="Head1" runat="server">
<title>Call server side method using Jquery</title>

<!-- Add the jQuery Reference Library-->
<script src="Script/jquery-1.4.min.js" type="text/javascript"></script>
<script type="text/javascript">
$('#btnok').click(function() {

$.ajax({

type: "POST",

url: "Default.aspx/Test1",

data: "{'args1':'Kalpesh','args2':'Patel'}",

contentType: "application/json",

dataType: "json",

success: function(msg) {

// Replace the div's content with the page method's return.

$("#newresult").text(msg.d);

}

});

});

</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<input id="Button1" type="button" value="button" />
<span id="status"></span>
</div>
</form>
</body>
</html>


Code Behide file code (Default.aspx.cs)
-----------------------------------------

using System;

using System.Web.Services;

using System.Web;

public partial class _Default : System.Web.UI.Page

{

public void test()

{

}

[WebMethod(EnableSession = false)]

public static string Test1(string args1, string args2)

{

return "Hello: " + args1 + " " + args2;

}

[WebMethod]

public static string Test2()

{

return "Hello: " + DateTime.Now.Millisecond + " -- Kalpesh Patel";

}

}

Read More

Sometimes Page load event not firing in asp.net

The reason for the page executing doesn't affect the page cycle, the Load event always fires when the page is executed.

So, if the Page_Load doesn't run sometimes, it's because the page is cached and doesn't execute on the server. The page can be cached in the browser, in a router somewhere along the way, or on the server using server side page caching.

If you haven't enabled server side page caching for the page, it's cached in the browser or in the network. You can use cache settings to try to elliminate this:

Response.Cache.SetCacheability(HttpCacheability.NoCache);

This will keep the page from being cached in normal circumstances. (Check also that your browser isn't in offline mode, then it will use anything in the cache regardless of it's cacheability settings.)

Read More

Excel Data Reader - Read Excel files in .NET (Convert Excel data to DataTable using Asp.Net)

Click here to download Excel.dll File FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read);
//1. Reading from a binary Excel file ('97-2003 format; *.xls)
IExcelDataReader excelReader =ExcelReaderFactory.CreateBinaryReader(stream);

//... //2. Reading from a OpenXml Excel file (2007 format; *.xlsx)

IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

//... //3. DataSet - The result of each spreadsheet will be created in the result.Tables
DataSet result = excelReader.AsDataSet();
//... //4. DataSet - Create column names from first row
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
//5. Data Reader methods
while (excelReader.Read()) { //excelReader.GetInt32(0); }
//6. Free resources (IExcelDataReader is IDisposable) excelReader.Close();
I hope help to you.

Read More