c# - Ado.Net Fill Grid By Logged in User -

c# - Ado.Net Fill Grid By Logged in User -

i need fill gridview records according logged in user. stored procedure asks 1 parameter, id of user. want parameter logged in user cant figure out how accomplish this.

my stored procedure grab records:

@cnt_id int begin select top (100) percent dbo.vtcursusplanning.cur_cursusid cursusid, dbo.vtcursusplanning.cur_omschrijving omschrijving, convert(varchar, dbo.vtdata.dat_datum, 100) datum, convert(varchar, dbo.vtdata.dat_start, 100) dstart, convert(varchar, dbo.vtdata.dat_stop, 100) dstop, dbo.vtcontactpersonen.cnt_initialen username dbo.vtdata inner bring together dbo.vtcursusplanning on dbo.vtdata.cur_fk = dbo.vtcursusplanning.cur_cursusid inner bring together dbo.vtcontactpersonen on dbo.vtcursusplanning.cnt_fk = dbo.vtcontactpersonen.cnt_id inner bring together dbo.vtcursuscursisten on dbo.vtdata.cur_fk = dbo.vtcursuscursisten.cst_fk (dbo.vtcontactpersonen.cnt_id = @cnt_id) , (not (dbo.vtcursuscursisten.cst_fk null)) , (not (dbo.vtcursusplanning.cur_project null)) order dstart end

and effort fill gridview c# code.

protected void page_load(object sender, eventargs e) { sqlconnection conn; sqlcommand comm; sqldatareader reader; gridview1.datakeynames = new string[] { "@cnt_id" }; string connectionstring = configurationmanager.connectionstrings["kris-planning"].connectionstring; conn = new sqlconnection(connectionstring); comm = new sqlcommand("spoffice2010evaluaties", conn); comm.commandtype = commandtype.storedprocedure; comm.parameters.add("@cnt_id", sqldbtype.int); comm.parameters["@cnt_id"].value = userid; seek { conn.open(); reader = comm.executereader(); gridview1.datasource = reader; gridview1.databind(); reader.close(); } grab (exception ex) { dberrorlabel.text = convert.tostring(ex); } { conn.close(); } } }

try 1 instead;

string userid = httpcontext.current.user.identity.name;

c# asp.net gridview