Remove Parameters

Hi,

I need some help. I am really new to C# and have to do something in ASP.NET to get data from SQL Server and display it in a GridView.

I have been able to populate the GridView but now I have come to a block because I need the user to be able to edit the data. On the RowEditing part of the code I am using the same databind() which is the same for loading the inital data into the GridView.

I come across this error message;

The variable name '@Year1' has already been declared.

Can someone please tell me how to drop the parameters. I have tired
myCommand.Parameters.Clear();

public void binddata()

{

//My Databind

SqlDataSource SqlDataSource1 = new SqlDataSource();

SqlDataSource1.ID = "SqlDataSource1";

this.Page.Controls.Add(SqlDataSource1);

SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["RMUConnectionString"].ConnectionString;

SqlDataSource1.SelectCommand = @"SELECT

base.[Contract Number] AS Contract_Number,

base.[Lead PCT] AS LeadPCT,

base.[BMI Site] AS BMISite,

base.[CQUIN Indicator] AS CQUIN_Indicator,

base.[Original Indicator Weighting (% of total Scheme)] AS IndicatorPer,

base.odscode AS ODS,

[Achievement Reported by site (% of individual indicator)] / 100 AS Achievement,

[Agreed by CCG] AS Agreed

FROM [CQUIN BASE DATA] base

LEFT JOIN [CQUIN DATA TABLE] A

ON base.odscode = a.odscode

AND base.[Contract Number] = a.[Contract Number]

AND base.[CQUIN Indicator] = a.[CQUIN Indicator]

AND a.Quarter = @Year1 + ' ' + @Quarter1

AND a.Date_Updated = (SELECT

MAX(date_updated)

FROM [CQUIN DATA TABLE] a2

WHERE a2.odscode = a.odscode

AND a2.[Contract Number] = a.[Contract Number]

AND a2.[CQUIN Indicator] = a.[CQUIN Indicator]

AND a2.quarter = a.quarter)

WHERE base.[Contract Number] = @Contract1

AND base.odscode = @Site1

AND base.Quarter = RIGHT(RTRIM(@Quarter1), 1)

ORDER BY 1, 3, 4";

//Declare Parameters

SqlDataSource1.SelectParameters.Add("Year1", TextYear.SelectedValue);

SqlDataSource1.SelectParameters.Add("Site1", TextSite.SelectedValue);

SqlDataSource1.SelectParameters.Add("Contract1", TextContract.SelectedValue);

SqlDataSource1.SelectParameters.Add("Quarter1", TextQuarter.SelectedValue);

MainDataView.DataSource = SqlDataSource1;

MainDataView.DataBind();

}

Any help would be great.

Paul

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nishant Mittal10y ago
Accepted answer
HI,

TRY USING THIS
SqlDataSource1.SelectParameters.Remove
0
Paul Arthur10y ago
I am using the databind() to first populate the GridView when one of my combo boxes changes value, I then want to use it again on the MainGrid_RowCancelingEdit but then it says that the variables have already been declared.
0
Nishant Mittal10y ago
And Yes it will come at the end of your class. Please accept the ans if it helps u.. Cheers
0
Nishant Mittal10y ago
Hi Paul

i have one question if u wont need that parameter y u wana first add and then remove it?
0
Paul Arthur10y ago
Is this suppose to go at the end of the binddata() class?

I am getting this error.

CS0201: Only assignment, call, increment, decrement, and new object expressions can be used as a statement

Once again thank you for all your help.
0
Paul Arthur10y ago
Thanks Nishant for getting back to me so quickly.

Does cmd relate to something.

So will mine be SqlDataSource1.Parameters.RemoveAt(0);

It is not accepting this.
0
Nishant Mittal10y ago
Hi ..

I think clear will clean all the parameter..

try using this
cmd.Parameters.RemoveAt(0);
0