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)
{
.......
.......
}
How to read the first sheet in Excel with C#
500 Internal Server Error - The received certificate has expired.
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
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,...
-
Logo Tiger programında kullanılan veritabanı tabloları aşağıdadır. 1. XXX olarak üç digit ile gösterilen bölüm firma numarasını belirtir....
-
Devexpress AspxGridView kolonlarında filtre türünü değiştirmek için grid üzerindeki ilgili kolonda Settings--> AutoFilterCondition = defa...
-
TABLO ADI AÇIKLAMA L_PERSONEL Çalışma Alanı Tanımları L_SYSLOG Kullanıcı Kaydı İzleme L_L...