السلام عليكم
اريد عمل بحث و اظهار النتائج في Textbox
انا عامل كود البحث
اريد كيف اظهر النتائج في ال Textbox
using System;
using System.Data.OleDb;
using System.Data;
using System.IO;
using System.Data.SqlClient;
using System.Configuration;
namespace ReadExcelInToDataSet
{
public partial class Default : System.Web.UI.Page
{
OleDbConnection oledbConn;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GenerateExcelData("Select");
}
}
protected void ddlSlno_SelectedIndexChanged(object sender, EventArgs e)
{
GenerateExcelData(ddlSlno.SelectedValue);
}
private void GenerateExcelData(string SlnoAbbreviation)
{
try
{
// need to pass relative path after deploying on server
string path = System.IO.Path.GetFullPath(Server.MapPath("~/InformationNew.xlsx"));
/* connection string to work with excel file. HDR=Yes - indicates
that the first row contains columnnames, not data. HDR=No - indicates
the opposite. "IMEX=1;" tells the driver to always read "intermixed"
(numbers, dates, strings etc) data columns as text.
Note that this option might affect excel sheet write access negative. */
if (Path.GetExtension(path) == ".xls")
{
oledbConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"");
}
else if (Path.GetExtension(path) == ".xlsx")
{
oledbConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");
}
oledbConn.Open();
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter oleda = new OleDbDataAdapter();
DataSet ds = new DataSet();
// passing list to drop-down list
// selecting distict list of Slno
cmd.Connection = oledbConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT distinct([Slno]) FROM [Sheet1$]";
oleda = new OleDbDataAdapter(cmd);
oleda.Fill(ds, "dsSlno");
ddlSlno.DataSource = ds.Tables["dsSlno"].DefaultView;
// SqlDataReader sdr = cmd.ExecuteReader();
if (!IsPostBack)
{
ddlSlno.DataTextField = "Slno";
ddlSlno.DataValueField = "Slno";
ddlSlno.DataBind();
}
// by default we will show form data for all states but if any state is selected then show data accordingly
if (!String.IsNullOrEmpty(SlnoAbbreviation) && SlnoAbbreviation != "Select")
{
cmd.CommandText = "SELECT [Slno], [FirstName], [LastName], [Location]" +
" FROM [Sheet1$] where [Slno]= @Slno_Abbreviation";
cmd.Parameters.AddWithValue("@Slno_Abbreviation", SlnoAbbreviation);
}
else
{
cmd.CommandText = "SELECT [Slno],[FirstName],[LastName],[Location] FROM [Sheet1$]";
}
oleda = new OleDbDataAdapter(cmd);
oleda.Fill(ds);
// binding form data with grid view
// SqlCommand cmds = new SqlCommand();
// System.Data.OleDb.OleDbDataReader sdr;
// Label1.Text = ds.Tables[1].Rows[0];
grvData.DataSource = ds.Tables[1].DefaultView;
grvData.DataBind();
}
// need to catch possible exceptions
catch (Exception ex)
{
lblError.Text = ex.ToString();
}
finally
{
oledbConn.Close();
}
}
protected void btnSerch_Click(object sender, EventArgs e)
{
GenerateExcelData("Select");
}// close of method GemerateExceLData
}
}
شكرا مقدماااا