dataTable and session variable.

Aarti Gupta

I am using Ado.Net DataTable and DataAdapter to query the database, after successfully logging , i want to store the datatable values into session , how to achieve that?

using (SqlConnection con = new SqlConnection(cs))
{
SqlDataAdapter da = new SqlDataAdapter("select * from UserMaster where Name=@Name and Password=@Psd",con);
da.SelectCommand.Parameters.AddwithValue("@Name",txtuserName.Text);
da.SelectCommand.Parameters.AddwithValue("@Psd",Bl.Decrypt(txtuserpsd.Text));
con.Open();
System.Data.DataTable dt = new System.Data.DataTable();
da.Fill(dt);
// here i have to store it in session
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
use below code
if (dt.Rows.Count > 0)
               {
                   User emp = new User();
                   emp.Name=dt.Rows[0].Field("Name");
                   emp.Gender = dt.Rows[0].Field("Gender");
                  ...... whatever your fields are
                   Session["User"] = emp;
               }
           }

           User user= (User)Session["User"];
           string Name = user.Name;
...  so on.
+1