I would like to be able to select a few rows from my database and display them on one page that I can share with other people. Therefore I need to generate a unique link that only displays the data I have chosen. It seems that using querystrings in this circumstance would create rather a long link, is there an alternative way?
View 1 Repliesi am creating a grid page for a first time.
I looked on some tuitorials also but i still have few confusions.
I have a few parameters on page A. After the selection of those parameters, i should pass to the new page which should have a list of fleet items. There will be few columns and at the right most, i want a tickbox whether to select that item or not.
As a default, i want each checkbox be checked but if user wants to uncheck it, they should be able to do it.
I have to create a customized Next/ Previos solution, the DataPager is not flexible enough for what I want. This is what I have so far.
1. A user does a search and 100 records are returned, I have 25 records per page and so get 4 page numbers -- this is already done on search.aspx
2. The user clicks their choice (let's say its 'Post 10') and is taken to that record on details.aspx -- pretty standard stuff.
What I now need is a Next /Previous links on the details page -- so if the user clicked Post 10, on the details page will be two links, Next linking to Post 11 and Previous linking to Post 09. (i'll actually be using the post title as the text in the links not simply Next/Previous) I'm unsure about how I should begin to struture this, should I be looking at creating Temp Tables in Sql Server and step through the records or can I access the dataset from the search page and step through that?
i want to create popup in save click how it can be done?is it possible
View 1 RepliesI'm trying display data from a sqldatasource but I need to customize fonts, sizes and layouts. What would be the best way to do this. There's not much data only 8 rows and 3 cloums.
It's for a display screen that will show workers how much product they have produced.
I was looking at binding the data to lables and laying out the lables in a table but that process looks intense and streching my knowledge.
I have an ASP.NET page that updates customer profile information.
After updating and when the user clicks on Update button, i want to display alert message.
Can we customize it to edit the MsgBox title?
Can we edit the default msg that is displaying? If yes, Can anybody provide any samples.
I earlier used customized popup from AjaxToolkit. I have issues with that in IE6.0. So I don't want to go for that.
i have a question, i ywant to know how to make if i pick an item from a drop down list it description goes to a textbox beside it automaticaly is very very important to me at this point
View 1 RepliesI have a gridview that displays the data of my database. What i want is a detailsview that gives me the details of the record i select in the gridview. Both the gridview and the detailsview are on one page. I use objectdatasources to get the data from the database. In the ObjectDataSource i select the gridview-control to get the selected value. But i get the following error: An object of type System.String can not be converted to DataTable. I also tried the following:
leaving the ODS control to none and passing the value via the protected sub ObjectDataSourceDetails_Selecting:
e.inputparameter("id") = gridview1.SelectedValue
The problem is this: when i click on select in the gridview, the data won't display any data in the detailsview.How could i solve this?
I have a problem with binding a DropDownList. Let's assume a database five years old with many historical records. In order to enable just working with active data every datasource has a column hidden which is occasionally set by administrator in order to clean up old records. The selection looks like
1) SELECT Id, Value FROM Table WHERE Hidden = 0
The issue arises when the user opens a form with old data. As some records in DropDownListhave have already been hidden an exception is raised as the component cannot find the data for the list. For this case the following selection is valid
2) SELECT Id, Value FROM Table
it is possible to combine these two selection queries? The display value should always use query 2 while the listed values should use the query 1.
I have drop down selection box as follow...
1 - Car
2 - Plane
3 - Train.
Now, based on user selection say, 'Car', I want to display Help text associated with selection on page. Help text description - 1000 characters. Now, how do I fetch Help Text Description from? should I store in Session scope or Application Scope or fetch from Database based on drop down selection.
I have a gridview with 50 rows. I want to display the rows according to the selection in dropdownlist. Say for ex - In my dropdown i have items 10,20,30,40,50. If i select 20 grid should display only 20 rows.
View 7 RepliesI'm having trouble figuring out how to display a gridview based on the selection of a drop down list. I manually entered the drop down list items, but in the configure/choose data source I don't understand how you make a relationship between each list item and the corresponding database table you want to show.
View 7 Repliesi have displayed a xml file in the tree view form by binding them....now i want a sample code to access the nodes which are being selected and to display dynamically in a grid view ..in asp.net/c#
View 4 RepliesHere i am using dropdown that will retrive from database when i will select an item from dropdownlist then item rate display on the selection of dropdown item name.
View 6 RepliesI am working on a medium size web site and I am kind of stuck. I need to do the following
1- admin user fill a form and submit (Done)
2- the system create new page storing the info provided in step 1
how can I do that? I need a page to be created I don't want to read the data from data base and display it on a template
What I am trying to achieve here is, I am supplying xml as string (varchar) to my stored procedure, In stored procedure I want to parse this xml and fetch each Promotion record and insert into my table. Also once each record is inserted, I need to fetch the Identity of that record alongwith the AreaID attribute from the Parent node "Promotion" of each Promotion record and insert into second association table. how would I go about doing it, my generated xml is given as under.
[Code]....
I am having a datatable in which the data is as follows
No Name Text
1 a abc
1 a xyz
1 a asd
2 b aaa
2 b bbb
I want to querry this data table to get the result as
No Name res1 res2 res3
1 a abc xyz asd
2 b aaa bbb
Using a GridView to display unique website department names from a database table, is it possible to create a hyperlink in the GridView to that specific departments page? I'm a beginner and haven't found any examples so unsure as to how this would be accomplished.
View 8 Repliesam using vs 2005 and sqlserver 2005.in my database table (name : users) there are more than 10 lac records.i have to display the user details in a grid.if i wrote the sql query as " select * from users" then it is throwing the "System.OutOfMemoryException"So i wrote the query using rownumber (i mean first it will get inly specified no of records ex:25 )so it is displaying only that 25 recordshow to give paging in this situation...?y requirement is in the grid i want to get and display first 25 records with the paging asirst Previous 1 2 3 4 5 6 7 8 9 10 Next Last
View 5 RepliesIn my asp.net+vb web there are gridview
in my first gridvew1 the fields are
ser, company,location
in my gridview2 the fileds are name,company,qualification
when i click the company name the persons working in that company should display
[Code]....
My question is: how can i create my own parameter based upon the QueryStringParameter?
Example:
[Code]....
I now called it QueryStringGuidParameter.
The purpose of this is: I'm not sending any querystring's via the aspx?querystring other thasn aspx?guid={guid identifier}.I hope my code below explains it al little bit.
[Code]....
A soon as a page Redirects f.i. with this example
[Code]....
Instead of calling Response.Redirect i call the Redirect i created. This transforms the querystring in a session with a guid and parameter. The Redirect only sends the guid in the querystring. and the receiving page picks up the guid and translates it back into a querystring.
Purpose is you have a secure way of dealing with info sending via querystrings. Lets say in the past you could easily get other info from the page by just changing a value in the key send via a querystring. In my case lets say the user request a Customer "A" with querystring ?ID=1.
Simple change the query in the addressbar to ?ID=2 (or something else) would give him another customer. Maybe a customer he is not allowed to see. (Of course this can be prevented also in the business layer, but that's not the point.)
So if i simply could create a new QueryStringParameter lets say called QueryStringGuidParameter which i can use in the ObjectDataSource but ideally just for all controllers which are able to use the QueryStringParameter , i don't have to go into code behind and set the SelectParameters in there.
I have an application as in the following,
[Code]....
The application works, but I would like to have 10 results per page. How easily can this be done? I don't want to use data view or grid view like most of the examples talk about, I would like to do this in the fashion that looks like what I have now, only not so many entries in a whole page.
i want to see the sales in the grid view based on the month selected from drop down list. Ex: when I select June 2010 from the ddl box, the sales for that month are correctly displayed in the grid view. I go to page 4 to look at some sales there and then switch the month to August 2010 to see sales for that month instead. Here is the problem. When I switch the month, it show August 2010 sales, but stays in page 4 instead of going back/resetting back to page 1 of August 2010 sales.
How do I reset the grid view page back to the first page of August 2010 sales?
I am fairly new to ASP. If I have missed an imp. detail in this post, let me know and I will get that info. out there.
I have repeater control on page which bind with sql data source.i have dropdown to filter the records of repeater on button click event it refresh complete page i just want to show a wait message to user and just refresh repeater data instead of complete page refresh.i do not want to use ajax update panel.
View 1 RepliesI have a asp.net gridview control on my page with several fields and a couple of command fields. However, the update command is giving me problems.
Here is what works. The update command works provided I put straight text into the textboxes that appear. I even have one field that contains a dropdown list which works fine.
Here's the problem. I have two fields that need to access their value programmatically. These fields will reflect the current datetime and the current loggedin user from active directory. I have already created public strings in the C# code.
When I run the edit command on the asp form the grid uses one "DataKeyNames" element. With this the grid can update the selectedrow. However, I haven't been able to access it programmatically in the C# code. I can access the selectedrow in the "selectedindexchanged" event but then I am not able to update my fields in the gridview itself. So, part one of my question is how to I access the "DataKeyNames" properties of a gridview control.
if I can't access the "DataKeyName" property perhaps I could set the label nested within the gridview to the "myCurrentUser()" public string. I am inserting my code to hopefully make this clearer.