How to work by datatable from linq in asp.net .

hi Rowshan ,

  Your dt value store a viewstate and get your another button click event

protected void  Page load(object sender, EventArgs e)
{
  DataTable dt = new DataTable();
  DataColumn d1 = new DataColumn("PIId");
  DataColumn d2 = new DataColumn("PINO");
  DataColumn d3 = new DataColumn("LCTRANDAte");
  private void mytable()
  {
  dt.Columns.Add(d1);
  dt.Columns.Add(d2);
  dt.Columns.Add(d3);
  using (SqlConnection conn = new SqlConnection(_connStr))
  {
  string sql = "SELECT PIId, PINo, L_CTransdate FROM PInvoice";
  using (SqlCommand cmd = new SqlCommand(sql, conn))
  {
  using (SqlDataAdapter ad = new SqlDataAdapter(cmd))
  {
  ad.Fill(dt);
  View state["value"]=dt;
  }
  }
  }

}

//The above code is Your code and i would change is dt value store a viewstate
//then click event
Protected Void Button_Click(object sender, EventArgs e)
{
datatable dt=new datatable();
dt=(datatable)View state["value"];
//then use dt
}
Thanks
Sreejesh

Hello Friend,
                  Let's say you want to perform seraching on the basis of PinNo. The following query may help you to do the task.


var query=from a in dt.AsEnumerable() where a.Pinno="XXX" select a;

        foreach(var result in query)
                Response.Write(result.Pinno+"\t"+result.LCTRANDAte);


Hope that solves your problem.


With Regards,
Vishal Gilbile.