c# - Violation of PRIMARY KEY constraint 'PK__tblmembe__DD7012648BA5EC8B' When insert in DataBase *** ASP.Net Query -

-

i create page insert users .

but when run the page show me error

error pic

asp code

protected void page_load(object sender, eventargs e) {     system.data.sqlclient.sqlconnection con = new system.data.sqlclient.sqlconnection();     con.connectionstring = system.configuration.configurationmanager.connectionstrings["shopdbconnectionstring"].connectionstring;     system.data.sqlclient.sqlcommand cmd = new system.data.sqlclient.sqlcommand();     cmd.commandtext = "insert tblmember values ('" + txtemail.text + "','" + txtname.text + "','" + txtfamily.text + "','" + txtpass.text + "','','" + dropdownlist1.selectedvalue + "') ";     cmd.commandtype = system.data.commandtype.text;     cmd.connection = con;     con.open();     cmd.executenonquery();     con.close();     response.redirect("default.aspx"); }

my database

it seems you're not passing primary key in query, duplicate key shown empty (). email column uid (name confusing me) must unique. can't have 2 rows same primary key.

secondly , more important, not concatenate strings input build query. can injected harmful queries might drop database.

check example on how use parameterized queries.


Comments

Post a Comment

Popular posts from this blog

Angularjs unit testing - ng-disabled not working when adding text to textarea -

-
i trying test angularjs component using karma, mocha, power-assert. have textarea , button in component, button disabled based on length of text in textarea. when run component in browser works perfectly. can't figure out how test functionality. here's bit of code. inquiryform.js function inquiryform($scope) { // plan add logic here } angular.module('myapp').component('inquiryform', { controller: inquiryform, controlleras: 'inquiryform', templateurl: 'inquiryform.html' }); inquiryform.html <div class="contact"> <div>thanks contacting us.</div> <form> <textarea ng-model="inquiryform.inquirytext" name=""></textarea> <input type="submit" value="send" ng-disabled="!inquiryform.inquirytext.length"> </form> </div> inquiryformtest.js describe('inquiry form ', () => { let $r...
Read more

sql - invalid in the select list because it is not contained in either an aggregate function -

-
i can't figure out rewrite sql statement avoid error below msg 8120, level 16, state 1, line 26 column 'staffmember.staffmemberid' invalid in select list because not contained in either aggregate function or group clause. sql statment select (select [dbo].[udf_readstaffmemberbasic](sm.staffmemberid) xml path ('staffmembersummary'), root ('items'), type ), count(sm.staffmemberid) totalresults, ceiling(cast(count(sm.staffmemberid) decimal)/ @pagesize) totalpages staffmember sm inner join staffmembertoadditionalrole ar on sm.staffmemberid = ar.staffmemberid (sm.firstname '%' + @name + '%' or sm.surname '%' + @name + '%') , (@floorid null or sm.floorid = @floorid) , (@directorateid null or sm.directorateid = @directorateid) , (@additionalroleid null or ar.additionalroleid = @additionalroleid) order sm.staffmemberid offset @page * @pagesize rows fe...
Read more

c++ - Qt: Resize QScrollArea to show 4 widgets at most -

-
i dynamically adding , removing widgets in qscrollarea, , show @ 4 widgets @ same time before scroll bar appears. basically, if have 0-3 widgets , add one, scroll area resized fit new height, after that, height stays @ 4 widgets size , have scroll see 5th, 6th, ... currently, call following method when widget inserted/removed. void widgetlist::resizescrollarea() { // height of first 4 widgets int widgetsheight = 0; (int = 0; < _widgets.size() && < 4; ++i) { // height of widget widgetsheight += _widgets.at(i)->sizehint().height(); } // leeway make sure have gap between widgets _ui->scrollarea->setfixedheight(widgetsheight + 5); } the problem sizehint() isn't correct height (sometimes big), neither size() (often small). scroll area bit big content, works. not widgets have same height, , sizehint seems correct one, , size. understand sizehint size widget have, not 1 layout gives it, don't why size incor...
Read more