sql database exception error in c# asp.net

Question

Hi .I'm developing asp.net web application. i make sql database with table "reg".and actually i make 2 web forms for reg complete process.
reg1.aspx has username,password,etc...
reg2.aspx has dropdown securityQues.

actually table reg have 3 columns
1.username not null 2.password not null 3.securityQues not null

when i click reg1.aspx submit btn "sqldatabase exception by usercode" cmd.executenonquery(); error.. null values could add on table

plz help for this prlm... sorry for mistakes in english help me adv.thanks for all members

Prakash P · Answer

I Accept ur answer... but i have one ques... if i defined sqldb column value is null onceand it is possible to change i mean add the values after (next tme). plz send me stored procedure for this prlm.i need 2 pages for reg1.aspxreg2.aspx

Vishal Gilbile · Answer

Hello Friend This is happening because your table has 3 columns and when you click the button on WebForm1.aspx page you are trying to insert record in your Table by passing two values i.e. for username and password and your security question values is not passed because your this field lies on second page. either try to make your security question field in sql to accept null values or try to merge the content of the two pages into a single page so that on button click event you would be able to pass all the values of the table. Hope that solves your problem. With Regards Vishal Gilbile.

Sreejesh SP · Answer

Dear prakash Your input parameter and sql parameter count is mismach then you get this type erroranother case your database table fields are not null so must pass three fieldsso please review your Input code and stored procedureanother case is your connection ex: sqlconnection con=new sqlconnection(@connection string); sqlcommand cmd=new sqlcommand(); cmd.connection=con; cmd.commandtext= ; cmd.open(); cmd.executeNonquery(); cmd.close(); please read the above code and apply your applicationand check your sql queries and c#code Thanks Sreejesh

Pradip Pandey · Answer

Hi Check your code that if you have fields like usercode in your database tables then must pass the value from the UI otherwise remove the parameter from the UI. Hope it will help you.