In App_Data Folder

string connectionString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + System.Web.HttpContext.Current.Server.MapPath(”App_Data/DBMASTER_Jan2009.xls”) + “;Extended Properties=Excel 8.0;”;

In Project

string connectionString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + System.Web.HttpContext.Current.Server.MapPath(”DBMASTER_Jan_2009.xls”) + “;Extended Properties=Excel 8.0;”;

public DataSet SearchReportData()

{

OleDbConnection objConn = new OleDbConnection(connectionString);

//string query = “select * from [satya$] where Dist=’” + txtDistrict.Text.Trim() + “‘”;

string query = “select * from [satya$] where SCNo=?”;

OleDbCommand objCmd = new OleDbCommand(query, objConn);

objCmd.Parameters.Add(”@SCNO”, OleDbType.VarChar).Value = sSCNo;

DataSet objDs = new DataSet();

OleDbDataAdapter objDa = new OleDbDataAdapter(objCmd);

objConn.Open();

objDa.Fill(objDs);

objCmd.ExecuteNonQuery();

objConn.Close();

return objDs;

}