sql database exception error in c# asp.net

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.

Dear prakash,

              Your input parameter and sql parameter count is mismach then you get this type error,another case your database table fields are not null so must pass three fields,so please review your Input code and stored procedure,another 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 application,and check your sql queries and c#code

Thanks

Sreejesh

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.