No Response To Code And Query Analyser Cannot Read Statement

hi





have a problem ...


I tried to test my statement in QA as it returns no dataset ,it gives me empty columns in return,I though it will return all the columns and some records of (lmeyer) as the current user ,who logged in on windows auth,but it return only the columns,is that means my query analyser cannot read the login1 ,column which has the username as (lmeyer)





select * from tstudents where (login1='@param1')





if not what could me wrong in my code ,because I get no response to the sql server














Public Function login(ByVal login1 as string) as dataset





Dim myconnection as new sqlconnection("server=G103-TT03;database=CampusLANDB;Trusted_Connection=yes")


dim mycommand as new sqlcommand ("Select * from tStudents Where login1 = @param1",myconnection)


mycommand.parameters.add(new SQLClient.SqlParameter("@param1",login1))





dim DS as new dataset()








try


myconnection.open





dim adpt as new sqldataadapter


adpt.selectcommand = mycommand


adpt.fill(DS,"tStudents")








catch ex as exception


throw new exception(ex.message)


return nothing


finally


myconnection.close


end try





try


mydatagrid.datasource=DS.Tables("tStudents")


mydatagrid.databind()


catch ex as exception


errorlabel.text=ex.message


end try





return DS





End Function

















thankx in advance


pamela mkosana