c# - Eternal loading time with Update statement in ASP.NET -
i have code:
<asp:sqldatasource id="updatefullnamesql" runat="server" connectionstring="<%$ connectionstrings:userqueries %>" providername="<%$ connectionstrings:userqueries.providername %>" updatecommand="update users set firstname = :changefirstname, lastname = :changelastname (username = :currentusername)"> <updateparameters> <asp:controlparameter controlid="changefirstnamebox" name="changefirstname" propertyname="text" type="empty" /> <asp:controlparameter controlid="changelastnamebox" name="changelastname" propertyname="text" type="empty" /> <asp:controlparameter controlid="usernamebox" name="currentusername" propertyname="text" type="empty" /> </updateparameters> </asp:sqldatasource>
after hit button, starts load, loads forever , nothing happens.
any suggestions? (i'm using oracle database, changing : sign @ shows missing expression exception.)
have tried running normal update query c# code? can try , see if doing same.
Comments
Post a Comment