Web Forms

Re: No value given for one or more required parameters

venkatu2005 — Wed, 08 Jul 2009 03:59:41 GMT

alessandro:
venkatu2005:

As the above code bind using the bound coluem as it contains only itemtemplate which shows only the value ie: readonly you are not able to insert , edit the data on this template so you have to create the InsertItemtemplate for inserting , EditItemtemplate for Edit and update the data.

So follow the link from the begining , work on the same way so only can do the above manipulation, as you written SqlDataSource its ok with all query (insert , update , delete)

I have had to slap my forehead ~~forehad~~ a few times at how wrong every solution you have provided is. ahh the blind helping the blind! My head hurts. It's ok to not know. If you do not, simply let someone more knowledgable to help. If you are wrong, say you are wrong.

Back to the problem, venkatu, you will agree that, while the poster has the boundfield specified as readonly, he has the parameter set in datakeynames. His back is pretty much covered in the value being passed to his updatemethod. Also the value won't be required during an insert operation. so, why are you suggesting templatefields?

You present an alternate solution instead of offering to help the poster with the current problem at hand.

Also I don't understand what the poster is so happy about to mark you as answer at this point! I'm disappointed :(

The only real issue is the one hans points out. There are just way too many placeholders, more than the number of parameters in the updateparameters collection specified by the original poster. This is as clear as the sun imho

Spot on hans!

If i had mistake i will correct it , suppose i do no the answer i left it so someone else answer these , where i has any argument regard my post anywhere --- as i told on first post using itemtemplate you can make it easy be to place the control and also user can format his control as he wish.

Re: No value given for one or more required parameters

NYVolvoLvr — Wed, 08 Jul 2009 03:20:27 GMT

Thanks for the input guys, I'll work on Hans solution and see what happens.

Thanks again...

Re: No value given for one or more required parameters

alessandro — Tue, 07 Jul 2009 15:27:34 GMT

venkatu2005:

As the above code bind using the bound coluem as it contains only itemtemplate which shows only the value ie: readonly you are not able to insert , edit the data on this template so you have to create the InsertItemtemplate for inserting , EditItemtemplate for Edit and update the data.

So follow the link from the begining , work on the same way so only can do the above manipulation, as you written SqlDataSource its ok with all query (insert , update , delete)

I have had to slap my forehead ~~forehad~~ a few times at how wrong every solution you have provided is. ahh the blind helping the blind! My head hurts. It's ok to not know. If you do not, simply let someone more knowledgable to help. If you are wrong, say you are wrong.

Back to the problem, venkatu, you will agree that, while the poster has the boundfield specified as readonly, he has the parameter set in datakeynames. His back is pretty much covered in the value being passed to his updatemethod. Also the value won't be required during an insert operation. so, why are you suggesting templatefields?

You present an alternate solution instead of offering to help the poster with the current problem at hand.

Also I don't understand what the poster is so happy about to mark you as answer at this point! I'm disappointed :(

The only real issue is the one hans points out. There are just way too many placeholders, more than the number of parameters in the updateparameters collection specified by the original poster. This is as clear as the sun imho

Spot on hans!

Re: No value given for one or more required parameters

hans_v — Mon, 06 Jul 2009 10:16:15 GMT

venkatu2005:

There is a parameter called Terminal - have you find its different- check

WHERE (([Terminal] = @Terminal) OR ([Terminal] IS NULL AND @Terminal IS NULL))"

I don't get you want to say? I see a parameter @Terminal that is used twice. Like I said, if you have another solution for the error message, please explain but don't write riddles, It won't help anybody!

Re: No value given for one or more required parameters

venkatu2005 — Mon, 06 Jul 2009 10:06:14 GMT

hans_v:
venkatu2005:

UpdateCommand="UPDATE [Castrminfo] SET [Employee ID] = @EmployeeID, [First Name] = @FirstName, [Last Name] = @LastName, [Terminal Name] = @TerminalName WHERE (([Terminal] = @Terminal) OR ([Terminal] IS NULL AND @Terminal IS NULL))"

could you count the parameter

Off course. I see 6 parameters (you forgot to highlight the last), but the last 2 are treated as the same, because I named them! In his original UpdateCommand, the questionmarks are treated as 6 different parameter, parameter as the first @terminal parameter, which is the cause of the error 'No value given for one or more parameters'

UpdateCommand="UPDATE [Castrminfo] SET [Employee ID] = @Paremeter1, [First Name] = @Parameter2, [Last Name] = @Parameter3, [Terminal Name] = @Parameter4 WHERE (([Terminal] = @Parameter5) OR ([Terminal] IS NULL AND @Parameter5 IS NULL))"

But if you don't agree, please explain the cause of the error?

There is a parameter called Terminal - have you find its different- check

WHERE (([Terminal] = @Terminal) OR ([Terminal] IS NULL AND @Terminal IS NULL))"

Re: No value given for one or more required parameters

hans_v — Mon, 06 Jul 2009 09:55:08 GMT

venkatu2005:

UpdateCommand="UPDATE [Castrminfo] SET [Employee ID] = @EmployeeID, [First Name] = @FirstName, [Last Name] = @LastName, [Terminal Name] = @TerminalName WHERE (([Terminal] = @Terminal) OR ([Terminal] IS NULL AND @Terminal IS NULL))"

could you count the parameter

Off course. I see 6 parameters (you forgot to highlight the last), but the last 2 are treated as the same, because I named them! In his original UpdateCommand, the questionmarks are treated as 6 different parameter, which is the cause of the error 'No value given for one or more parameters'

UpdateCommand="UPDATE [Castrminfo] SET [Employee ID] = @Paremeter1, [First Name] = @Parameter2, [Last Name] = @Parameter3, [Terminal Name] = @Parameter4 WHERE (([Terminal] = @Parameter5) OR ([Terminal] IS NULL AND @Parameter5 IS NULL))"

But if you don't agree, please explain the cause of the error?

Re: No value given for one or more required parameters

venkatu2005 — Mon, 06 Jul 2009 04:49:15 GMT

hans_v:
venkatu2005:

And also check the Update Parameter contains only 4 parameter , you have to pass the 5 parameter

I really don't follow you. He passes 5 paramters, the problme is that he has 6 parameters in his update command.

UpdateCommand="UPDATE [Castrminfo] SET [Employee ID] = @EmployeeID, [First Name] = @FirstName, [Last Name] = @LastName, [Terminal Name] = @TerminalName WHERE (([Terminal] = @Terminal) OR ([Terminal] IS NULL AND @Terminal IS NULL))"

could you count the parameter

Re: No value given for one or more required parameters

hans_v — Sat, 04 Jul 2009 12:15:15 GMT

venkatu2005:

hans_v:

Are you really sure? I think you should try it, you'll be up for a big surprise.

A BoundField will create a textbox in both edit an insert state of the detailsview and in the edit state of a gridview, unless you change some settings

OfCourse , but i am not work out with boundfield , but i will prefer to use Itemtemplate to show the data in some format.

You presented it not as a preference, but as a solution to the problem, which obviously it is not

venkatu2005:

And also check the Update Parameter contains only 4 parameter , you have to pass the 5 parameter

I really don't follow you. He passes 5 paramters, the problme is that he has 6 parameters in his update command.

shahed.kazi:
You have 2 update parameters Terminal and Terminal_Name and you have only parameter in the UpdateCommand.

No, he uses both Terminal and Terminal_Name fields in the UpdateCommand. The problem, as I earlier explained, is that his intention is to use the Terminal parameter twice. In that case he should gove names to the questionmarks.

Re: No value given for one or more required parameters

shahed.kazi — Sat, 04 Jul 2009 07:26:37 GMT

You have 2 update parameters Terminal and Terminal_Name and you have only parameter in the UpdateCommand.

Re: No value given for one or more required parameters

manjeetrocks — Sat, 04 Jul 2009 06:25:42 GMT

You need to write parameters for Gridview.

Re: No value given for one or more required parameters

venkatu2005 — Sat, 04 Jul 2009 06:17:44 GMT

hans_v:
Are you really sure? I think you should try it, you'll be up for a big surprise.

A BoundField will create a textbox in both edit an insert state of the detailsview and in the edit state of a gridview, unless you change some settings

OfCourse , but i am not work out with boundfield , but i will prefer to use Itemtemplate to show the data in some format.

And also check the Update Parameter contains only 4 parameter , you have to pass the 5 parameter

Re: No value given for one or more required parameters

hans_v — Fri, 03 Jul 2009 15:30:26 GMT

venkatu2005:
As the above code bind using the bound coluem as it contains only itemtemplate

Are you really sure? I think you should try it, you'll be up for a big surprise.

A BoundField will create a textbox in both edit an insert state of the detailsview and in the edit state of a gridview, unless you change some settings

Re: No value given for one or more required parameters

hans_v — Fri, 03 Jul 2009 15:25:49 GMT

Well, the answer to the problem is quit simple. Count the amount of parameters in your Update Command ( 6 ) and the amount of parameters in the parametercollection (5). Access (or better said the Jet Database Engine) doesn't understand that you mean the last 2 questionmarks are in fact the same parameter. Every questionmark is treated as a new parameter, so you need to specify 6 parameters. The best way to solve it is to name the parameters when you need the same parameter multiple times...

UpdateCommand="UPDATE [Castrminfo] SET [Employee ID] = @EmployeeID, [First Name] = @FirstName, [Last Name] = @LastName, [Terminal Name] = @TerminalName WHERE (([Terminal] = @Terminal) OR ([Terminal] IS NULL AND @Terminal IS NULL))"

Now you've only 5 parameters, so the error should be gone. But if it works is a big question. Because you have terminal as the datakeyname of the detailsview, which means that it is the primary key. But if it is the Primary Key, why are you checking if it is Null, because a primary key cannot be null? It looks to me that EmployeeID is in fact the Primary Key???

By the way, when specifying the DataFile, you could replace

C:\Documents and Settings\User\Desktop\Access Database\Access Edit\App_Data

With

|DataDirectory|

Re: No value given for one or more required parameters

venkatu2005 — Fri, 03 Jul 2009 05:09:51 GMT

NYVolvoLvr:
I'm sure the resource you provided has the information I need, its just a matter of me understanding it and executing.

Any additional help you could provide would be appreciated!

As the above code bind using the bound coluem as it contains only itemtemplate which shows only the value ie: readonly you are not able to insert , edit the data on this template so you have to create the InsertItemtemplate for inserting , EditItemtemplate for Edit and update the data.

So follow the link from the begining , work on the same way so only can do the above manipulation, as you written SqlDataSource its ok with all query (insert , update , delete)

Re: No value given for one or more required parameters

NYVolvoLvr — Thu, 02 Jul 2009 13:15:43 GMT

Thanks for the reply, went to the website you referenced above and spent a few hours on it and couldnt get it to work. The problem I ran into was the coding produced by the application doesnt look much like what was in the website link, the coding was unfamiliar, would it make sense to start from scratch and manually enter the code as per the codeasp.net article? I was also unsure where to insert the methods such as UpdateRecord.

I'm sure the resource you provided has the information I need, its just a matter of me understanding it and executing.

Any additional help you could provide would be appreciated!