|
Hi,
I've a DataGrid and its bound to a SqlDataSource with a SelectCommand. Now I have to populate this grid with data based on search criteria specified by user.
By default it loads all records because that is what the SelectCommand in the SqlDatasource does. But when the user makes a search criteria and cicks on Search, I change the SelectCommand and call DataBind on the Grid. But once I click on Page 2, it takes the default SelectCommand of the SqlDataSource and shows all records, which is default state.
Is there a work around, or am I doing something wrong with these controls?
Regards,
Blumen
“The thing for you is a burial permit. You have only to speak and I will see that you get it.”
|
|
|
|
|
I wouldn't change select command via code. On every postback the select command is going to back to the select command that you set in the markup.
How you should do this is write one stored proc for example...
create proc dbo.search (@nameValue varchar(10) = null)
select * from yourTable where nameField = isnull(@nameValue, nameFeild)
Something like the above will return all records if the parameter is null. You should not have to change the select command.
Actually, though if your original query pulls back all the records then you could save all the data in a databale and store it in session, viewstate or cache depending on the size and use a dataview to filter.
I didn't get any requirements for the signature
|
|
|
|
|
|
You could do it that way, but it depends how many records you are searching. Where is the data being stored between postbacks? The sqldatasource isn't going to open a connection to the database on every postback only to filter the data after it has been returned will it?
The other issue with using viewstate to store your search criteria is that is if the user leaves that page, they have to start all over.
I would use a stored proc with parameters and store the criteria in session state.
I didn't get any requirements for the signature
|
|
|
|
|
|
gopinagam wrote: Forum: ASP.NET
Subject: masterpage code
Sender: gopinagam
Date: Tuesday, December 23, 2008 7:45 PM
hi
Stop Spamming. This is not a Question .
cheers,
Abhijit
|
|
|
|
|
i am using a master page
and two child pages page1 , page 2 both are in master page
now i want to give title tag for page 1 = page 1 and for page 2=page 2
how can i do it in master page or is there any other way to give title tag???
any help would be appriciated..
umerumerumer
|
|
|
|
|
Seriously I Didn't get your problem ? 
Your are using One Master Page and Two Content Page. I believe you should also have content Place Holder in Master Page. and You have just need to mention the content place holder name in Content Page. This is are the general scenario.
mr_muskurahat wrote: now i want to give title tag for page 1 = page 1 and for page 2=page 2
how can i do it in master page or is there any other way to give title tag???
What about this part ?
cheers,
Abhijit
|
|
|
|
|
If you just want to add title for the content pages(Child Page).You can set it in child page's Page tag at top in page as
Title="Child1".
Let me know if any other issue.
Cheers!!
Brij
|
|
|
|
|
actually my page shows untitled page which is written in master page title tag
i want to show page 1 title instead of master page title.... what should i do????
umerumerumer
|
|
|
|
|
Put the Title value as I said earlier in the content page's Page tag.
Cheers!!
Brij
|
|
|
|
|
Ya solved thank you.... 
umerumerumer
|
|
|
|
|
Cheers!!
Brij
|
|
|
|
|
I have one asp dot net Project.I want to prepare help file for end user.And I want to know how to prepare help file.Can anybody give me good solutions to prepare help file.
|
|
|
|
|
There are a lot of websites having help on the net.You can have set of HTML pages with the table of intex and also can have sitemap etc.You can also upload a document for that one.
Cheers!!
Brij
|
|
|
|
|
2 Days back there was a Thread[^] in the same topic.
Hope that will help you.
cheers,
Abhijit
|
|
|
|
|
I need to assign some string with quotations. how can i give.
For ex:
string st1 = "<div class="nameMeaning"><div>"
i am getting error here..
But i need value of st1 with quotations. how can i get?
G. Satish
|
|
|
|
|
|
use escaping character like this
string st1 = "<div class=\"nameMeaning\"><div>"
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
some thing is missing in ur answer
G. Satish
|
|
|
|
|
for quotations use \ before quotations like
string st1 = "<div class=\"nameMeaning\"><div>"
Cheers!!
Brij
modified on Tuesday, December 23, 2008 6:30 AM
|
|
|
|
|
\" will insert a set of quotes in your string. The other way is to use single quotes, they work too in HTML
string st1 = "
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
hi friends,
help me to restrict session variable to share among the tabs of a browser.
thanks in advance
surender
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
I think you'll have some trouble doing that, as the session depends on the process your browser is open in. You'd be better trying to handle having two tabs open.
|
|
|
|
|
here the scenario is like,
m maintaining client ids in session, m doing some processing on one client id and if i open a new tab in the browser i can see the same client id in the second tab.
i want to restrict this.
pls suggest me how to do that.
thanks inadvance
surender
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
