"Novice" SqlDataSource dynamic setting problem! Thank you! !!

sonicliao

I use SqlDataSource to bind to GridView. Because the Select in my SqlDataSource is dynamic. For example: select a, b, c from xxx, sometimes: select b, c from xxx

sqlstr is the SQL statement I generated:
sqlstr = "Select aa, bb From Guest WHERE (PublicName = @PublicName) AND (PType = @PType)"

DefineTypeDS is SqlDataSource, which is a SqlDataSource control that I dragged in the design page. The name is DefineTypeDS.
DefineTypeDS.SelectCommand = sqlstr;

        DefineTypeDS .SelectParameters .Clear ();
        DefineTypeDS.SelectParameters.Add (new Parameter ("@PublicName", TypeCode.String));
        DefineTypeDS.SelectParameters.Add ("@ PType", "");
        DefineTypeDS.SelectParameters ["@ PublicName"]. DefaultValue = "username";
        DefineTypeDS.SelectParameters ["@ PType"]. DefaultValue = "newguest";
       
        // When the program is executed here, an error is reported: the variable '@PublicName' must be declared
        DefineTypeDS.Select (DataSourceSelectArguments.Empty);]

Puzzled! Please master help. Thank you! !!

sonicliao

TOP yourself. .

jetzzz

Depressed. You also have to ask this question. Then you declare @PublicName.

wdh3139593

Oh

ggggex

Declaration @PublicName

sonicliao

Halo said for a long time. I just ask how to declare? Where to declare it?

everever30

DefineTypeDS.Select (new DataSourceSelectArguments ());

sonicliao

DefineTypeDS.Select (new DataSourceSelectArguments ());


Not the problem. Tried it. Still wrong.

sonicliao

DefineTypeDS .SelectParameters .Clear ();
        DefineTypeDS.SelectParameters.Add (new Parameter ("PublicName", TypeCode.String));
        DefineTypeDS.SelectParameters.Add ("PType", "");
        DefineTypeDS.SelectParameters ["PublicName"]. DefaultValue = "username";
        DefineTypeDS.SelectParameters ["PType"]. DefaultValue = "newguest";

I tried it myself. Just remove the @ in front of @PublicName. do not know why.