How to read the first sheet in Excel with C#


string AppPath=Request.ServerVariables["APPL_PHYSICAL_PATH"]+"Tahsilat/";
OleDbConnection m_ConnectionToExcelBook;
OleDbDataAdapter m_AdapterForExcelBook;
m_ConnectionToExcelBook = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+AppPath+"deneme.xls;Extended Properties=Excel 8.0;");
bool ErrorExist=false;

try
{

m_ConnectionToExcelBook.Open();
DataTable dtExcelSchema = m_ConnectionToExcelBook.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
// select first sheetname
string sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
DataTable DataObject = new DataTable();
OleDbCommand selectCommand = new OleDbCommand("select * from [" + sheetName + "]");


selectCommand.Connection = m_ConnectionToExcelBook;
m_AdapterForExcelBook = new OleDbDataAdapter();
m_AdapterForExcelBook.SelectCommand = selectCommand;
m_AdapterForExcelBook.Fill(DataObject);

if (DataObject.Rows.Count > 0)
{
.......
.......
}

500 Internal Server Error - The received certificate has expired.

PROBLEM
The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed.Please try the following:
Click the Refresh button, or try again later.
Open the www.mylogo.com.tr home page, and then look for links to the information you want.
If you believe you should be able to view this directory or page, please contact the Web site administrator by using the e-mail address or phone number listed on the www.mylogo.com.tr home page.
500 Internal Server Error - The received certificate has expired. (-2146893016) Internet Security and Acceleration Server
CAUSE
This issue occurs if both of the following conditions are true:
You publish a Secure Sockets Layer (SSL) Web site by bridging the SSL connection to the internal Web server as SSL. In other words, Internet Security and Acceleration (ISA) Server receives an SSL request on the external interface and then requests the Web content from the Web server by using an SSL request. -and-
The certificate on the internal Web server has expired.The error message that is described in the "Symptoms" section describes the error as an internal ISA Server error. However, this error message actually indicates a problem with the published server's certificate.

RESOLUTION
To resolve this issue, obtain a new certificate for the published Web server. This error no longer occurs when the published server has a valid certificate.

Enable Ole automation for MS SQL


The following steps for "Enable Ole automation",


start ->


programs ->


MS sql 2005 ->


configuration tools ->


surface area configuration ->


Surface area conf for features ->



Ole automation ->


select the Enable check box and saved


FUNCTION: isNaN (Java Script)

The isNaN function is used to determine if the argument, testvalue, is a NaN.

A NaN, which means "Not-a-Number", is classified as a primitive value by the ECMA-262 standard and indicates that the specified value is not a legal number.

The function returns true if the argument is not a number and false if the argument is a number.

The classic example of a NaN is zero divided by zero, 0/0.

Code:

document.write(isNaN("Ima String")) // true

document.write(isNaN(0/0)) // true

document.write(isNaN("348")) // false

document.write(isNaN(348)) // false

BlackListIP control on Serenity platform (.NET Core)

 In the Serenity platform, if you want to block IPs that belong to people you do not want to come from outside in the .net core web project,...