when i tried to debug or upload the project in "visual studio 2005" in the "C#" language.
this problem view to me :-
No value given for one or more required parameters.

i need a help plz quickly
i will be thankful to any answer.

this is ASP c# is .net

and the error is in some code we can't see

but it is a database query that is missing something

i dont exactly what is needed maybe this :-
OleDbConnection cn = newOleDbConnection();
cn.ConnectionString = " data source= C:\\Inetpub\\wwwroot\\insite\\App_data\\Database.m db;provider=microsoft.jet.oledb.4.0";
OleDbCommand cmd = newOleDbCommand();
cmd.Connection = cn;
cmd.CommandText = " select * from Attorneys where id='" + id + "'";
OleDbDataAdapter da = newOleDbDataAdapter();
da.SelectCommand = cmd;
DataSet ds = newDataSet();
da.Fill(ds);
return ds;

maybe this if not tell me i will put what u need but i wanna solve plz .
thank you 4 uor help i apperciate it.

Originally Posted by chrishirst

this is ASP c# is .net

and the error is in some code we can't see

but it is a database query that is missing something

i dont know exactly what is needed maybe this :-
OleDbConnection cn = newOleDbConnection();
cn.ConnectionString = " data source= C:\\Inetpub\\wwwroot\\insite\\App_data\\Database.m db;provider=microsoft.jet.oledb.4.0";
OleDbCommand cmd = newOleDbCommand();
cmd.Connection = cn;
cmd.CommandText = " select * from Attorneys where id='" + id + "'";
OleDbDataAdapter da = newOleDbDataAdapter();
da.SelectCommand = cmd;
DataSet ds = newDataSet();
da.Fill(ds);
return ds;

maybe this if not tell me i will put what u need but i wanna solve plz .
thank you 4 uor help i apperciate it.

Change this line:

cmd.CommandText = " select * from Attorneys where id='" + id + "'";

to:

Response.Write(" select * from Attorneys where id='" + id + "'");
return null;

And then copy the text from the web page, paste it into a new Access query, try to run it, and you'll understand what's going on.

Ideal way to debug.

You're missing the value for id itself. Chances are that it isn't being retrieved or passed from whatever you're trying to retrieve or pass it from at some point...or you're wiping it out.

Aha! Three days in the relevant link exchange forum!

If he wasn't passing the id variable it would return a blank string, and send the query select * from attorneys where id='' to the database. That could provoke an error for implicit conversions if id is a numeric field, because you can't turn an empty string into a number, but if it's against an Access database, the "required parameters" error means something that looks like a field from SQL syntax hasn't been assigned a value.

Basically, the field is probably AttorneyID and not ID; if the field id doesn't exist in the query, Access assumes it's a parameter, and if you try to run the query in Access, it will give you an InputBox asking you to supply a value for id. Then it would run a query like Select * from attorneys where [value you typed]='' and not return any results. Unless you just hit enter, and it would return all rows.

But Response.Write is the magic debug injecter in asp. And if you have some dynamically generated SQL, the best way to debug is to see exactly what query is being generated, and test it in the database directly.

An even better idea, though, is that dynamic SQL must die.

This is true. Response.Write is a wonderful thing. I was actually thinking about something else when I wrote that answer.

I'll go serve my time like a good boy. (****, I'm pissed off at myself for coming up with that punishment. )

It's okay, I think you can get a pardon in this case because it's Friday. And, funny as it is, it's sort of cruel and unusual punishment!

thank you for all the replies thanx a lot .
u r a good team