sqldatasource default value

Question

How do I set the default value of a SQLdatasource parameter to the select all

<asp:Parameter Name="original_lastsaved" Type="string" defaultvalue="???"/>

Thanks for the help. saurabh

Off The Gold · Accepted Answer · 2016-02-12 14:52:20Z

2

You can do like...

SqlDataSource1.SelectParameters["original_lastsaved"].DefaultValue = "Set Value here";

Edit: If you want that when you click the Select All button, it will pick up all of the record and ignore the where clause parameter, then make an overloaded with no parameter and then clear the Select parameter in SQLDataSource Selecting event. e.g.

protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
    SqlDataSource1.SelectParameters.Clear();
}

edited Feb 12, 2016 at 14:52

Off The Gold

1,23615 silver badges28 bronze badges

answered Jul 6, 2011 at 13:14

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

saurabh goyal Over a year ago

sorry you got my question wrong . i mean if parameter value is empty suppose in control parameter then how will i show all the records.

saurabh goyal Over a year ago

hmm.it might work . but i already got a simple solution for that simply set the default value as '%'.sorry for sharing the answer late

Collectives™ on Stack Overflow

sqldatasource default value

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related