error in sql parameter String does not contain definition.

Question

0.00/5 (No votes)

See more:

hye i'm having error "string' does not contain a definition for 'Parameters' and no extension method 'Parameters' accepting a first argument of type 'string' could be found (are you missing a using directive or an assembly reference?)". Where did i do wrong?

string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\shafiq\\Desktop\\history\\App_Data\\Radiation.mdf;Integrated Security=True;User Instance=True";

            // Create SQLDataSource.
            SqlDataSource sqlDataSource = new SqlDataSource();
            sqlDataSource.ID = "SqlDataSource123";
            this.Page.Controls.Add(sqlDataSource);

            // Bind ConnectionString to SQLDataSource.
            sqlDataSource.ConnectionString = connectionString;
            // Retrieve records with only 5 Columns from Employees table of NorthWind Database.

                sqlDataSource.SelectCommand = "SELECT top 30 [date], [data] FROM [loc1] WHERE (([data] >= '2') AND ([date] >= @startdate) AND ([date] < @enddate)) ORDER BY [data] DESC, [date] DESC";
                sqlDataSource.SelectCommand.Parameters.AddwithValue("@startdate", startdate);
                sqlDataSource.SelectCommand.Parameters.AddwithValue("@enddate", enddate);
                gridmaxdata.DataSource = sqlDataSource;
                gridmaxdata.DataBind();

Posted 15-Dec-13 17:21pm

Jejaka Siber

Add a Solution

Comments

JoCodes 15-Dec-13 23:36pm

Exactly which line your are getting the error?

Jejaka Siber 15-Dec-13 23:41pm

this line "sqlDataSource.SelectCommand.Parameters.AddwithValue"

JoCodes 15-Dec-13 23:55pm

The error is related to the datatype of the parameter.
Parameters.AddwithValue("@startdate", startdate); Make sure the startdate and enddate variables are converted to appropriate datatype which they have in the field of your DB table.

JoCodes 16-Dec-13 0:08am

Have you checked the comment I have added?If still the issue persists revert.

Jejaka Siber 16-Dec-13 0:19am

the startdate and enddate variable is datetime value the same as the db. but the problem still persists. when i double check the selectcommand, the "parameter" option is unavailable.

JoCodes 16-Dec-13 0:33am

Double click on design view of sqldatasource? Can you please make it clear?

Jejaka Siber 16-Dec-13 0:43am

what i means is that the paramters method is unavailable under method selectcommand.

JoCodes 16-Dec-13 0:55am

Ok, Then try an alternative

SqlDataSource.SelectCommand="select query";
SqlDataSource.SelectParameters.Add("@startdate", startdate);

Jejaka Siber 16-Dec-13 1:35am

it say that it code is an invalid argument and it cannot change datetime to string.

JoCodes 16-Dec-13 2:38am

Convert the string to datetime. it will work...

Gaurav Makwana 15-Dec-13 23:40pm

i think you need to pass that conncectionstring variable anywhere else just check and find its easy to play with this type of errror

Jejaka Siber 15-Dec-13 23:48pm

i dont understand, could you explain more?

Naresh Pansuriya 15-Dec-13 23:52pm

WHAT IS DATATYPE OF startdate and enddate?

Jejaka Siber 16-Dec-13 0:16am

datetime data type. dd/MM/yyyy

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

An@nd Rajan10 · Answer 1 · 2013-12-15T17:57:00

Solution 1

i thing u did not pass value to parameter, so @startdate, @enddate are empty parameter.
first you can pass parameter value from datetimepicker or ....

Posted 15-Dec-13 17:57pm

An@nd Rajan10

Comments

Jejaka Siber 16-Dec-13 0:36am

What do you means by i didn't pass the value?? where do i suppose to pass the value??

Mas11 16-Dec-13 0:40am

Yes. Same view here

♥…ЯҠ…♥ · Answer 2 · 2013-12-15T18:16:00

Solution 2

Hi Siber,

Try to replace the below two lines

C#

sqlDataSource.SelectParameters.Add("@startdate", Convert.ToDateTime(startdate));
sqlDataSource.SelectParameters.Add("@enddate", Convert.ToDateTime(enddate));

Here you can see I have converted to dateTime type since I believe field in database is in DateTime type.

Note: Before that you need to make sure startdate and enddate has values.

Hope this helps you a bit.

Regards,
RK

Posted 15-Dec-13 18:16pm

♥…ЯҠ…♥

Updated 15-Dec-13 20:29pm

v6

Comments

Jejaka Siber 16-Dec-13 0:39am

the code does not work as the error is that it does not recognize SqlDataSource.SelectCommand.Parameters where the error is the Parameters itself. under the SelectCommand, the parameters option is unavailable.

♥…ЯҠ…♥ 16-Dec-13 0:54am

You didnt get Parameters from intellisense?

Jejaka Siber 16-Dec-13 1:27am

no... Parameters is not available

♥…ЯҠ…♥ 16-Dec-13 1:29am

I didnt get you, Parameters is not available means you didnt get value in Parameters or you didnt get Parameters after SelectCommand intellisense?

Jejaka Siber 16-Dec-13 2:05am

i did not get parameters after selectcommand intellisense. even if i write it directly, it will show error.

♥…ЯҠ…♥ 16-Dec-13 2:10am

try removing sqldatasource before sqldatasource and check it

Jejaka Siber 16-Dec-13 2:12am

how?? I don't understand. Can you elaborate?

♥…ЯҠ…♥ 16-Dec-13 2:18am

updated my solution, use the above two lines with your code and lemme know

Jejaka Siber 16-Dec-13 2:23am

i got this almost the same error but this time on System.Web.UI.WebControls.SqlDataSource

'System.Web.UI.WebControls.SqlDataSource' does not contain a definition for 'Parameters' and no extension method 'Parameters' accepting a first argument of type 'System.Web.UI.WebControls.SqlDataSource' could be found (are you missing a using directive or an assembly reference?)

♥…ЯҠ…♥ 16-Dec-13 2:28am

Okay...try the updated solution now, it would work for you.

Jejaka Siber 16-Dec-13 2:37am

I got two error on the new code

The best overloaded method match for 'System.Web.UI.WebControls.ParameterCollection.Add(string, string)' has some invalid arguments

and

Argument '2': cannot convert from 'System.DateTime' to 'string'

p/s: the startdate and enddate are already a datetime datatype

♥…ЯҠ…♥ 16-Dec-13 2:45am

Refer here http://forums.asp.net/t/1115044.aspx

Jejaka Siber 16-Dec-13 3:10am

i have try the code

sqlDataSource.SelectParameters["@startdate"].DefaultValue = startdate.ToLongDateString();

sqlDataSource.SelectParameters["@enddate"].DefaultValue = enddate.ToLongDateString();

but i got error when i try to run the web, which is null reference exception. i dont know how to settle this because i don't know what to put in the catch error code.

do you have any idea?

♥…ЯҠ…♥ 16-Dec-13 3:14am

I think, startdate and enddate is empty.. check like this
If (startdate != null && enddate != null)
{
sqlDataSource.SelectParameters["@startdate"].DefaultValue = startdate.ToLongDateString();
sqlDataSource.SelectParameters["@enddate"].DefaultValue = enddate.ToLongDateString();
}

Jejaka Siber 16-Dec-13 3:26am

i have try to get the startdate and enddate to show in label, and it does have value but when i run the web, it still give the null reference exception. i have try the code that you give me, i still get the same error

♥…ЯҠ…♥ 16-Dec-13 3:40am

before assigning debug and see what you get in startdate and enddate?

Jejaka Siber 16-Dec-13 3:50am

I have comment the datasource code, and i have made label to show the startdate and enddate value, and there are value in the startdate and enddate. when i redo the comment, i still get the null exception error