Is it possible to split a single datasource, so that it can be shown in 2 separate gridviews that are side by side?
So what I am trying to do is change this:
HEADER A
HEADER B
1A
1B
2A
2B
[Code]....
I have a complicated report that nests six deep and so really hits the database hard. I want to use SqlDataReaders NOT DataAdapters and DataSets because I don't want big tables in memory.
MARS can get me the data fast, all from the one connection. But all the examples show it binding to a treeview.
I want to bind it to nested GridViews (six deep!).
Any examples of MARS binding to nested gridview/list/repeater controls of any kind?
I have already tried the change on Navri's blog about changing the css but this does not work, my tabheaders go off the page to the right and I simply want to split them onto two lines?
View 5 RepliesLike many organizations, our customer service department receives faxes and process them in many different ways. The faxes come in through a queue. The faxes are presented to the user through a windows interface.The user ties a customer number to the fax and is allowed to split the fax into several different pages if necessary. They then send these different pages to different people in the organization.Currently the windows application that process these faxes uses a product that use to be part of Windows called KODAK.
The hope is that the current windows tool could be converted into a web application that provides the same functionality that the windows application offers. a tool that could be utilized inside an ASP.Net web application that would allow the user to receive a fax and split it like KODAK does? This application needs to be built in-house because of the custom needs of our customers. Something imbedded in the ASP.Net application would work for us.
First of all, I'm relatively new to asp.net (3.5) and all of its controls. What I'm trying to do is to split up a detailsview. I have a submission form containing quite a lot of fields that are supposed to be filled out by the user. In my design I have a tabstrip with headlines about the different sections of the form. For example:
Tab1: Personal Info
Tab2: Info about your car
Tab3: Contact info
I have tested to add a new "user" via a DetailsView and it works. But what I want to do is to split up the contents within the <Field> tags In the DetailsView In different div classes (using css and javascript to hide/show the right tab contents). But when I try to do this Visual Studio says that characters like <p> and others aren't allowed within the Field tags, which makes sense. Is there any control to use for these kinds of situations?
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
I am having an issue with a simple databind to a datagrid. What happens is that for some reason, the first character of the data going into the 4th column is getting placed at the end of the data in the third column; but only on the first row. Here is an example of what I mean:
Form ID
Employee No
Associate Name
Start Date
End Date
Form Status
1234
5000187
Stan Marsh1
1/16/2010
11/30/2010
Approved
1234
5000187
Eric Cartman
11/16/2010
11/30/2010
Approved
1234
5000187
Kyle Broflovski
11/16/2010
11/30/2010
Approved
As you can see, in the first row of data, a "1" has been moved from the Start Date column to the Associate Name column. Because this is a databind I don't see how this is even possible. I'm just curious if this is a known issue or just some random fluke. Here is the relevant code:
[Code]....
I have a gridview that is being populated by an oracle DB. The gridview have 2 columns now one shows years and the other is a checkbox column. What is happening is my years column is very long and I wanted to know if I could split the column in half. I want say from 1970-1990 in the first column. The second column will have the checkboxes for the first. I want the third column to have 1991-present day and the fourth column to have the checkboxes for the third column. Can the grid view do this or is this something I have to do in oracle and have the gridview just display it?
ex.
1970 chk 1991 chk
1971 chk 1992 chk
1972 chk 1993 chk
1973 chk 1994 chk
I have this "how to" type of question. I have a page where there are four gridviews. Now these four grids pull data from four different tables. The 1st grid retrieves data from table 1 with a where clause in it's query that comes from a hidden fileld value in the page. Till this things are fine. However, the 2nd grid has a dependency on the 1st grid and the where clause in it's query should be the data selected in grid view1. The 3rd depends on the 2nd one..and so on.
View 2 RepliesHas anyone come across any books that covered the topic of gridviews REALLY well and just say what they do?
View 1 RepliesI have a couple grid views one for Team Goals and one for Indicators for the Goals I want to be able to click on an indicator and it highlight the Goal in the other grid view both on the same page. I also want to be able to click one of the indicators and open a entry screen I assume for that I use the select portion of the control?
View 2 Replieshow to move items between two gridviews. my requirement is as such that the items can be moved around and once the user clicks on the save button then only will the final items in the gridviews get committed to the database.
View 5 RepliesI do have a page that is literally overloaded with about 10 GridViews and there is a datasource for each particular one. Now, each GridView is hide inside a panel, so I only display one at a time depending on what is it that the user request. My concern is the followng: Even though I am only displaying one GridView at a time, do the others datasource are still working behind the scene on the blind side and therefore are putting a load on the server and on its performance. Or I do not have to worry about this because as long as the Panel.Visibility = False, nothing inside that panel is working.
View 3 RepliesI'm developing a bilingual web site, and therefore, I'm changing the text of the headings and the select buttons of my gridviews. I just discovered that if I set some code like below in the rowdatabound event of the gridview, the "linkbuttonish" headings get replaced by unclickable text. In another thread, I was told to change
If Session("lang") = "en" Then
If e.Row.RowType = DataControlRowType.Header Then
e.Row.Cells("name").Text = "Given name"[cod]...
in the myGV_DataBound sub.This works well, but not everywhere. A few gridviews are populated from codebehind, and this is where things go wrong. What happens is that - nothing happens (it's still the original heading). I added a Watch, but once the HeaderText property changed, the Watch never yielded another result, but stayed with the new value.
Now I suspect that even though the HeaderText property has changed, this doesn't get reflected in the GV when populated from codebehind.
I guess that I should write something else than "e.Row.Cells("name").Text" to still have the click-behaviour, but I don't know what.
The same question arises for the select linkbutton in a cell of the gridview's datarows.
I have a project I am doing where clients post the sale of tickets. They are stored in a DB and shown in a gridview when they login to their account. However, I need to figure out how to set the gridview to only show what they have posted. I know I can use the their login clientID(CID), but I can't figure out how to get the gridview to show post for the client that logs in. It will either show all the post by multiple clients or it won't show any at all. I am using response.redirect(clientlisting.aspx? & "CID"). I then set the where clause as ticketID(TID) = querystring to (CID) but it is not showing anything.How do I set the gridview to show only post by each individual client?
View 6 RepliesI am needing to display two gridviews in the same panel on a form. Each of the gridviews has their own sqldatasource. Both datasources pull from the same table but they have a different record selection. When I view this in the browser I only see one gridview displayed. Can someone tell me how to do this or is there a better way to get a two gridview look without using the gridview?
View 5 RepliesI am trying to loop through all gridviews on a page to hide them and set their page index to 0. This should be very easy to do and it seems like the code below should work but it doesn't?? How can I accomplsh this with the least amount of code? FYI- this code is executed on a button click.
foreach (Control childControl in Page.Controls)
{
if (childControl is GridView)
{
((GridView)childControl).Visible = false;
((GridView)childControl).PageIndex = 0;
}
}
I'm creating a new solution to print a grid of my system. I think that is the best solotion, but....I need to copy some TemplateFields between two gridviews, but on the DataBind of the new grid, trows the error "the databind method like eval() only called on context control templatefield". I have Eval() instructions and I can't remove it!.Follows the exactly code:
[Code]....
I have 5 textboxes in my webpage for entering address, i.e,
door no, village, city, district, pincode.
These are concatenated by comma (,) and stored into the database field address. at the time of retrieving, the concatenated address, should be separated and assign to each textboxes.
how can we read all rows data in rowcommand event of gridview?
View 2 RepliesI'm having two grid view and one button on aspx page , on click of export to excel button i want to transfer these grid view data to excel sheet.. My requirement is to trasnfer to same excel file with two sheets(One sheet for one grid view).
View 6 RepliesI have access to two seperate databases (mySQL) located on two servers. I need to get the data, link the tables on a key field and display the results in a datagrid. My challenge is that if the search criteria changes for the display it affects rows returned from on table and should thus automatically affect the linked table and resulting data returned.
what the best approach would be to achieving this? So far I have set up a dataset with a dataadapter and table for each connection and then linked the tables in the dataset. The problem that I'm having is getting the linked resultsets to work.
On my form I have the datagrid with two Objectdatasources one for each dataadapter and i believe that's where I'm going wrong...
I have my gridviews, buttons and labels put into tables:
[URL]
Here is how the page looks when I run it:
[URL]
Then when I select an Order this happens:
[URL]
Why is it when I select an Order and the second gridview pops up theat it moves my text and Ship button down? I thought I had it setup in the tables so this wouldnt happen?
how I can display gridviews stacked one after another with spaces in between??? <br /> doesn't work.
View 2 RepliesI have a SQL query that returns about 5-10 records. For each one of these records I want to query another table using values in that row as parameters and create/populate a GridView. Can I create these GridViews and SQL connections programmatically in a for loop? I mean, I can't just plop ten GridViews and SQLConnections on my page at design time because I'm not certain how many rows will be returned in the first query. What should I do?
View 4 Replies
