Does the ParameterField class have a Name member? If it doesn't, that may account for the error message.

Hello, You might have tried these suggestions already but here is what I would check for the error "Load Report Failed". 1. If you are loading the report from a file be positive the filepath is correct. 2. ASPNET account needs access to the TEMP directory on the server. 3. Make sure to set the reportviewer's reportsource in page_init. Also, you can handle the reportviewers error event and see if a different exception is available there. Hope this helps :). Regards, John Adams ComponentOne LLC

thanks for your answer but i have problem about to send parameter to proc please send me 1 or 2 example i need it thank you very much

This would be SQL and Database discussions[^] question. However, the error is very clear. Have you tried tail-log backup before restore or forced restore as the error describes? The need to optimize rises from a bad design

try objCommand.Parameters.add["@nopersoneli"].Value = convert.toint32(txtNoPersoneli.Text); nelsonpaixao@yahoo.com.br trying to help & get help

Whoever univoted this - I agree that it's not best practice and if you look at my previous reply I did suggest using events (implies delegates too). The question in response to that from the OP was specifically on the unrecommended way, to which I gave an accurate and working response! X| ;P Dave BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

objCommand.Parameters.Add("@nopersoneli", SqlDbType.int).Value = convert.Toint32(txtNoPersoneli.text); if that doesn´t work is because "txtNoPersoneli.text" cannot be converted to a int value, or "@nopersoneli" is not int. listen, there is not a reason for that not work :-O nelsonpaixao@yahoo.com.br trying to help & get help

download bob tubor tutorial videos on microsoft learning (absolute beginners lessons) download both c# and sql lessons, he teaches you that and it is free :-\ nelsonpaixao@yahoo.com.br

but i have one table and 2 query now do i need one dateset?

How do you know he didn't go to Google and got pointed here? You seem to spend alot of time belittling people and telling them to Google what they're looking for. If you're not intetrested in helping, then why not ignore the post instead of bullying people? Apparently you're no longer a Microsoft MVP, and not at all interested in answering people's questions. You're interested in making people feel bad because they're experience isn't as great as yours. Degradation is the last refuge of the imcompetant. Everything makes sense in someone's mind

Hi, download bob tubor learning videos from microsoft(c#+sql). Search something like absolute beginners lessons, download as most as you can, they are free and very helpful. :laugh: nelsonpaixao@yahoo.com.br