sql server - incorrect syntax near the keyword where c#? -

-

when run code erorr apeared incorrect syntax near keyword c#

public sqldatareader getdr(commandtype handelmode, string sqlstat, list<sqlparameter> parms) {     sqldatareader r = null;     sqlcommand com = new sqlcommand();     sqlconnection con = getconn();     try     {         com.commandtext = sqlstat;         com.connection = con;         com.commandtype = handelmode;          if (parms != null)         {             foreach (sqlparameter p in parms)             {                 com.parameters.add(p);             }         }          r = com.executereader(commandbehavior.closeconnection);      }     catch (exception ex)     {         messagebox.show(ex.message, "error", messageboxbuttons.ok);         return null;     }         {         con.close();     }     return r; } 


private void picturebox10_click_2(object sender, eventargs e) {      list<sqlparameter> parslist = new list<sqlparameter>();     string selectstatement = "select id,aname,ename,i_d " + screenmastertablename;     string cond = " id_co=@id_co";     parslist.add(new sqlparameter("@id_co", forminfo.id_co));      if (s_id.text != "")     {         decimal d = 0;         decimal.tryparse(s_id.text, out d);         cond += " , id=@id";         parslist.add(new sqlparameter("@id", d));     }     if (s_aname.text != "")     {         if (cond != "")             cond += " , ";         cond += " aname =@aname";         parslist.add(new sqlparameter("@aname", s_aname.text));     }      if (s_ename.text != "")     {         if (cond != "")             cond += " , ";         cond += " ename =@ename";         parslist.add(new sqlparameter("@ename", s_ename.text));     }     if (cond != "")         cond = " " + cond;       var l = bus.getsearcheddata(selectstatement + cond, parslist);     datagridview1.datasource = l;     label9.text = l.count.tostring(); }

assuming s_id filled in have query this:

where , id=@id

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more