id does not exist in curent context

aditya immadi

Hai all,

i'm facing a stupid problem.hope you guys help me out .when i'm trying to binding the records

string id = System.Web.HttpContext.Current.Session.SessionID;

if (IsPostBack == false)

{

string connn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;

SqlConnection con = new SqlConnection(connn);

con.Open();

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

cmd.CommandText = "spuserdata";

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@id",id);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);--------convertion failed to convert nvarchar to int

DataList1.DataSource = ds;

DataList1.DataBind();

when i tried like this cmd.Parameters.AddWithValue("@id",Convert.ToInt32("id"));--- it says input string is not in correct formate

how can i solve this

and my stored proc is

ALTER procedure [dbo].[spuserdata](

@id int)

Begin

select decription,name from tb_userdata inner join tb_userlogin on tb_userdata.uidfromtb1=tb_userlogin.id

where tb_userlogin.id=@id

End

Thanks and Regards

5 Replies

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

Biswa Pujarini Mohapatra12y ago
The way you are getting the current user session id is correct, but the thing is that it is a unique id which contains character data and you cannot convert a char datatype to int.

probably you have to change your store procedure and database accordingly
aditya immadi12y ago
i tried like this...and it is wrong and the same error continues

session["id"]=System.Web.HttpContext.Current.Session.SessionID;

can you please tell me how can i get current user session id ?
Biswa Pujarini Mohapatra12y ago
System.Web.HttpContext.Current.Session.SessionID always retuns a string and you cannot convert it string or character to int.

I think in your code you have to store the Loginid in a session

like Session["LoginID"]=123;

then you can convert session to int32
aditya immadi12y ago
no it is not working i already tried it says input string is not in the correct formate
Biswa Pujarini Mohapatra12y ago
instead of Convert.int32 use

cmd.Parameters.AddWithValue("@id",Int32.TryParse("id"));

hope it helps