c# - Trying to Search by id then display data in gridview but getting syntax error -


could please explain why getting error? aware code has no security not public access. please explain going wrong? want search id display data in gridview. have linked gridview data.

exception details: system.data.sqlclient.sqlexception: incorrect syntax near 'equipmentregister''. line: 53 highlighted in source error

source error: 

    line 51:         sqldataadapter da = new sqldataadapter(querystring, con);     line 52:         dataset ds = new dataset();     line 53:         da.fill(ds);     line 54:         gvregister.datasource = ds;     line 55:         gvregister.databind();

here apsx file:

private void rep_bind()     {         string theconnectstring = system.configuration.configurationmanager.connectionstrings["equipregisterconnectionstring"].connectionstring;         sqlconnection con = new sqlconnection(theconnectstring);         string querystring = ("select * equipmentregister engineerref '" + txtengref.text + "%'");         sqlcommand com = new sqlcommand(querystring, con);         com.connection = con;         con.open();         sqldataadapter da = new sqldataadapter(theconnectstring, con);         dataset ds = new dataset();         da.fill(ds);         gvregister.datasource = ds;         gvregister.databind();      }       protected void btnsearch_click(object sender, eventargs e)     {           string theconnectstring = system.configuration.configurationmanager.connectionstrings["equipregisterconnectionstring"].connectionstring;         sqlconnection con = new sqlconnection(theconnectstring);         string querystring = ("select engineerref equipmentregister  engineerref like'" + txtengref.text + "%'");         sqlcommand com = new sqlcommand(querystring,con);         com.connection = con;         con.open();         sqldatareader dr;         dr = com.executereader();          if (dr.hasrows)         {             dr.read();             rep_bind();             gvregister.visible = true;          }         else         {             gvregister.visible = false;          }

stack trace

    [sqlexception (0x80131904): incorrect syntax near 'equipmentregister'.]    system.data.sqlclient.sqlconnection.onerror(sqlexception exception, boolean breakconnection, action`1 wrapcloseinaction) +1789294    system.data.sqlclient.sqlinternalconnection.onerror(sqlexception exception, boolean breakconnection, action`1 wrapcloseinaction) +5340642    system.data.sqlclient.tdsparser.throwexceptionandwarning(tdsparserstateobject stateobj, boolean callerhasconnectionlock, boolean asyncclose) +244    system.data.sqlclient.tdsparser.tryrun(runbehavior runbehavior, sqlcommand cmdhandler, sqldatareader datastream, bulkcopysimpleresultset bulkcopyhandler, tdsparserstateobject stateobj, boolean& dataready) +1691    system.data.sqlclient.sqldatareader.tryconsumemetadata() +61    system.data.sqlclient.sqldatareader.get_metadata() +90    system.data.sqlclient.sqlcommand.finishexecutereader(sqldatareader ds, runbehavior runbehavior, string resetoptionsstring) +377    system.data.sqlclient.sqlcommand.runexecutereadertds(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, boolean async, int32 timeout, task& task, boolean asyncwrite, sqldatareader ds) +1421    system.data.sqlclient.sqlcommand.runexecutereader(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, string method, taskcompletionsource`1 completion, int32 timeout, task& task, boolean asyncwrite) +177    system.data.sqlclient.sqlcommand.runexecutereader(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, string method) +53    system.data.sqlclient.sqlcommand.executereader(commandbehavior behavior, string method) +137    system.data.sqlclient.sqlcommand.executedbdatareader(commandbehavior behavior) +41    system.data.common.dbcommand.system.data.idbcommand.executereader(commandbehavior behavior) +10    system.data.common.dbdataadapter.fillinternal(dataset dataset, datatable[] datatables, int32 startrecord, int32 maxrecords, string srctable, idbcommand command, commandbehavior behavior) +140    system.data.common.dbdataadapter.fill(dataset dataset, int32 startrecord, int32 maxrecords, string srctable, idbcommand command, commandbehavior behavior) +316    system.data.common.dbdataadapter.fill(dataset dataset) +88    viewregister.rep_bind() in c:\users\michelle\desktop\comf510_65300_hs_task_2\viewregister.aspx.cs:53    viewregister.btnsearch_click(object sender, eventargs e) in c:\users\michelle\desktop\comf510_65300_hs_task_2\viewregister.aspx.cs:77    system.web.ui.webcontrols.button.onclick(eventargs e) +9628614    system.web.ui.webcontrols.button.raisepostbackevent(string eventargument) +103    system.web.ui.webcontrols.button.system.web.ui.ipostbackeventhandler.raisepostbackevent(string eventargument) +10    system.web.ui.page.raisepostbackevent(ipostbackeventhandler sourcecontrol, string eventargument) +13    system.web.ui.page.raisepostbackevent(namevaluecollection postdata) +35    system.web.ui.page.processrequestmain(boolean includestagesbeforeasyncpoint, boolean includestagesafterasyncpoint) +1724

your sqldataadapter initialized connectionstring instead of query. reason sql exception.
use constructor recieves sqlcommand instead.

also, should use parameterized queries.


-

Comments

Post a Comment

Popular posts from this blog

apache - PHP Soap issue while content length is larger -

we have developed soap based webservice post data third party webservice. accepts 4 params. in 1 of parameters accepts xml string no size limit restriction put in place. the webservice works fine in local environment running on php 5.2 , apache2. works content length long 10 mb. in staging server running nginx , php fpm.we have updated max post size , max upload filesize in php.ini , client_max_body param in nginx.conf allow upto 50 mb. but webservice client keeps on loading in staging environment. gives 502 timeout , gives soap error. can me understand issue here?
Read more

asynchronous - Python asyncio task got bad yield -

i confused how play around asyncio module in python 3.4. have searching api search engine, , want each search request run either parallel, or asynchronously, don't have wait 1 search finish start another. here high-level searching api build objects raw search results. search engine using kind of asyncio mechanism, won't bother that. # no asyncio module used here class search(object): ... self.s = some_search_engine() ... def searching(self, *args, **kwargs): ret = {} # raw searching according args , kwargs , build wrapped results ... return ret to try async requests, wrote following test case test how can interact stuff asyncio module. # here testing script @asyncio.coroutine def handle(f, *args, **kwargs): r = yield f(*args, **kwargs) return r s = search() loop = asyncio.get_event_loop() loop.run_until_complete(handle(s.searching, arg1, arg2, ...)) loop.close() by running pytest, return runtimeerror: task got bad yield : {results s...
Read more

javascript - Complete OpenIDConnect auth when requesting via Ajax -

the normal openidconnect server works like: you go a.com/secure-resource you 302 server your browser handles , sends identity server you login there it sends a.com via post you logged in on a.com , a.com/secure-resource on browser. however have scenario i'm trying solve need help. the user logged in on idserver the user logged in on a.com the user not logged in on b.com we need send ajax call web server b.com (from domain a.com ) b.com configured use openidconnect. but because request b.com via ajax, user cannot redirected idserver. (all in response 302 ) we can go ahead , handle 302 via ajax (i'm still not sure whether work, security-wise). but is there scenario in identityserver/openidconnect designed these situations? with identityserver in scenario setup server b.com use bearer token authentication, need use access token provided a.com in headers of ajax call $.ajax({ url: 'http://b.com', headers: { ...
Read more