|
|
I have a web page where I need to diplay some data that is retrieved tbough an ObjectDataSource. Behind the scense ObjectDataSource is populated through a SQL server stored procedure ( let's say GetData() ). This stored procedure returns around 10K rows and depending upon some criteria I need to dipaly this data in three different Grid view controls. My questions is
1. How can I split data in one recordset that can be used in these three grid views.
2. Is there any better way of doing it rahter than using objectDataSource.
Any specific links and example code will be highly appreciated.
TIA
|
|
|
|
|
imak wrote: 1. How can I split data in one recordset that can be used in these three grid views.
How do you want to split the data? By a specific number of rows? You could add some paging logic to your stored procedure to do this. If each grid view displays different types of data, you would need to write separate stored procedures.
imak wrote: 2. Is there any better way of doing it rahter than using objectDataSource.
The ObjectDataSource control allows data-bound controls to bind to custom objects/collections of custom objects. If you just want to bind a control to the results of a SQL Server query, use the SqlDataSource control.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
* As paul said you can implement paging logic so, that the Ods is not heavy.
* why are you complecating the things? why don't you use 3 ods for 3 grid views
-Ram.
|
|
|
|
|
Thanks Paul and Ram for your responses. I actually gave a simplified version of the actual problem. Let me provide detail so hopefully it will provide some clarification. There are actually 30 different web pages and number of grid ( and varios other controls) vary on each page (depending upon page, number of controls vary between 20 - 40). I am using objectDataSource as this product has multiple flavors that provides ability to connect to various types of data sources(SQL Server, oracle, mySQL etc).
Now in order to populate all controls on one page I was trying to avoid going back and forth between database. That's why I do not want to bind individual controls with so many ods; rather return all possible rows in one stored procedure, Call this stored procedure to fetch all data and then on client side populate different controls by splitting data. Is this a reasonable design? If so, is it possible to split data within objectdatasource logic? If so, can you provide any code examples?
|
|
|
|
|
So I'm writing a web app that surveys users. A checklist basically. I'm planning on accessing a database to get the questions and haven't decided on how to present the data to the user.
I was thinking about using an ActiveX control written in C# but can't quite figure out how to pass session/login data to the control from the server without exposing the information to the client.
Since there doesn't really seem to be much support out there for C# ActiveX controls, does anyone have any alternative solutions that would avoid using postbacks?
|
|
|
|
|
Why activeX? Have you considered one of the AJAX frameworks to eliminate your need for postbacks?
|
|
|
|
|
Why ActiveX? Mostly laxiness to stay in something I'm familiar with (C#) and avoiding learning something new.
I suppose the time has come to familiarize myself with AJAX and all its goodness.
Thanks for the reply.
|
|
|
|
|
Can anyone point me to an article that explains how a web server process an sql statement in c# page and sends it to sql server and then back
thanks!!!
|
|
|
|
|
The web server doesn't really process the SQL at all. Are you looking for a simple data access article? I'd suggest looking at the quickstarts on www.asp.net.
|
|
|
|
|
Webserver won't process SQL statements. It would be send to the database server as packets and database server will execute it.
|
|
|
|
|
Ah yes i think i muddled up my words yday!!
thanks for the info though
if anyone does have some articles about how a web server interacts with a sql server that would be great
cheers
|
|
|
|
|
hi i used
formauthentication.hashpasswordforstoringinconfigfile("password","SHA")
to hash my password before stroing into my access database programmically
now i am trying to retrieve the data back to show to the user anyone know how?
|
|
|
|
|
You can't retrieve the original string, hashing a string is one way operation.
|
|
|
|
|
neodeaths wrote: now i am trying to retrieve the data back to show to the user anyone know how?
Retrieve what? The password? You can't. That's the whole point of hashing - it's a one way process. The plaintext password cannot be determined from the hash.
Do you actually understand the point of hashing a password?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Common design indicates that the user not be shown his or her respective passwords because it opens up a programmatic door for developers (and others) to easily decipher passwords. I read a study, maybe in 2600, that indicated a large portion of users will use the same password on all systems.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
i am having a text box where i entered the date as 14/01/2008 now i want this string date format to convert into mm/dd/yyyy format for validation
|
|
|
|
|
I believe this is what you're looking for:
DateTime x = DateTime.Now;
x.ToString("MM/dd/yyyy")
|
|
|
|
|
DateTime s = DateTime.ParseExact("14/01/2008", "dd/MM/yyyy", null);
I believe there is also a corresponding js function as well.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
Hi Jagadeesh,
You may use CONVERT(CHAR(10), CURRENT_TIMESTAMP/date, 101)
where 101 is UK date format(dd/mm/yyyy) 103 is dd/mm/yyyy.... etc.,
hope this will help.
-Ram.
|
|
|
|
|
hello guys,
i'm using localization for my site. i have a dropdown with different language and a textbox for currency.
what i want when a user select the particular language then when user type the currency in the textbox it must be come in the relevant language format.
how to do it?
Amit Agarwal
|
|
|
|
|
use System.Globalization
and use Cultureinfo and regioninfo class
if you create object of an regioninfo class you can get the CourencyFormat!!
if you want to create own or cutome CurrencyFormat ..
use sysglobl.dll and use CultureRegionandInfo Builder Class. 
|
|
|
|
|
iam getting the date in dd/MM/yyyy format with the time but i dont want the time how can be possible to remove the time with dd/mm/yyyy format
|
|
|
|
|
|
Hi Jagadeesh,
DateTime yesterday = DateTime.Now;
yesterday= yesterday.Date;
the second line will set the date to mid-night, Hope this will help.
-Ram.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
