Forms Data Controls :: Data Structures Can Be Used As Data Sources For Gridviews?

Mar 31, 2011

so I know that DataTables are often used as the DataSources for gridviews. Lately, I have found that I can also use generic lists as data sources for gridviews. But I figured that out by simply trying it to see if it worked.

I have looked all over the web and simply cannot find any kind of inclusive list or description of exactly which data structures can be used as the data source for a gridview. Does anyone know if there is such a list, or some kind of reference that I can look to for this info?

Although it sounds like an obvious question, like there is obviously one out there and I just haven't looked, my experience has been that it's just not so.

View 1 Replies

Similar Messages:

Forms Data Controls :: Dynamic SQL Error(The IListSource Does Not Contain Any Data Sources)

Jan 31, 2011

I have a stored procedure written using dynamic SQL in the SQL Server and I am calling it on the code behind and adding parameters to it and filling a dataset and binding the data set to a Gridview. But I am getting this error when I bind it.

Can someone please tell me how to fix this?

It used to work fine when I did not use dynamic sql.

Line 237: da.Fill(ds);Line 238: gviewInvestigations.DataSource = ds;Line 239: gviewInvestigations.DataBind();Line 240: Line 241: }
Source File: s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs Line:
Stack Trace:

[HttpException (0x80004005): The IListSource does not contain any data sources.] System.Web.UI.DataSourceHelper.GetResolvedDataSource(Object dataSource, String dataMember) +8665698 System.Web.UI.WebControls.ReadOnlyDataSource.System.Web.UI.IDataSource.GetView(String viewName) +41 System.Web.UI.WebControls.DataBoundControl.ConnectToDataSourceView() +128 System.Web.UI.WebControls.DataBoundControl.GetData() +4 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +60 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 System.Web.UI.WebControls.GridView.DataBind() +4 Controls_InvestigationsControl.bindSearch() in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:239 Controls_InvestigationsControl.btnSearch_Click(Object sender, EventArgs e) in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:323 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

View 2 Replies

Forms Data Controls :: Display Gridview Data From Multiple Sources?

Jul 16, 2010

I need to display some data in a gridview. Its shipping data.

Part of the data can come from a generic database query. Static shipping data that can be looked up from the database. Part of the data is external and has to be queryed from USPS. Any suggestions on what is the best way to accomplish this.

Should I just programmatically fill the gridview from the code behind doing the database lookup manual and filling the gridview with manual data then going out and filling the rest of the gridview with the data obtained from the USPS service?

View 2 Replies

Forms Data Controls :: Multiple Data Sources For Datagrid?

Jan 17, 2011

I want to have one datagrid use two different data sources, the two datasaet I use have all the same cloumn names, the only difference is that the come form different databases. I wan tto have the data source be chosen by a dropdown list box. Is this possible or do I have to use two datagrid and just make on invisiable as needed.

View 1 Replies

Architecture :: Using Data Sources Vs. Using Data Access Layer To Populate Presentation Controls?

Mar 17, 2010

We are using a tierd design with a Data Access Layer and classes for everything we need. This serves as an advantage because we do not have to write querys over and we can separate the Presentation layer from the Data Access Layer and Business Rules.I have always in the past populated GridViews, DataLists, repeaters,etc with SqlDataSources. This is what I have become accustomed to and I feel like it is simple. For querys such as Select * from Members, I feel like using a DataSource is simpler than having to go in the code and calling methods to populate and DataBind these presentation controls.

I am working with a gentleman who has introduced me to the world of Data Access Layers and we are breaking everything down into simeple, but effective queries to populate controls and do what we need to accomplish with this application. He is not very approving of using any type of DataSource. We are disagreeing on the time and place to use these class methods to call the database.So my question is, which is more widely used in the programming world? Do most people use DataSources to populate presentation controls regardless of the Data Access Layer they are working with? Which type of queries are best suited for a DAL - simple, populating queries or complicated joins and upserts?

View 9 Replies

DataSource Controls :: Importing Data In SQL Server From Diffrent-2 Data Sources

Apr 12, 2010

I developing a application in Asp.net3.5(C#) and Sql server2005, my problem is that i have to Import data from diffrent-2 data sources like MS Access, Oracle, ODBC, XML to my Data base(in Sql server) using C# code. I don't know any thing about importing data from these data sources.

View 1 Replies

Forms Data Controls :: How To Read Rows Data In Gridviews Row Command Event

Dec 8, 2010

how can we read all rows data in rowcommand event of gridview?

View 2 Replies

Forms Data Controls :: Exporting Data From Two Gridviews To Two Sheets Of Same Excel File

Apr 6, 2010

I'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 Replies

Forms Data Controls :: How To Bind Nested GridViews To Multiple Active Result Sets Data

Oct 7, 2010

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?

View 1 Replies

Forms Data Controls :: Passing Data Between Two Gridviews?

Jul 22, 2010

I'm using two gridviews the first includes a checkbox column , what I need is to copy each selected row will be copied to the other ?

function {}= ?

View 4 Replies

Forms Data Controls :: How To Show The Same Data With Two Gridviews

Jan 9, 2011

im building my news website , for my town ,,

i have dababase that contain all the news called AllNews ,

and so i have the index.aspx that just contain the hot "news"

how can i show the first 5 rows of DB in page , and from the 6 to the end in another grid view ?!

View 5 Replies

Forms Data Controls :: Gridview Which Sources Information Dynamically From Database?

Sep 20, 2010

I have a gridview which sources information dynamically from database.

Here when i go for the default "AllowSorting" flag equal to true, i am able to achieve sorting of all displayed columns except the textBox control column whose values refreshes to zero.

View 2 Replies

DataSource Controls :: Query Over Two Data Sources?

Jan 12, 2010

I need to create a query which does a join between two tables which are in different databases. I can easily connect to each database, and write queries in each, however, I can't seem to find a way of generating a query which does a join between two tables from different databases.

View 2 Replies

Forms Data Controls :: Dependent GridViews?

Mar 15, 2010

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 Replies

Forms Data Controls :: Books On Gridviews?

Mar 9, 2011

Has anyone come across any books that covered the topic of gridviews REALLY well and just say what they do?

View 1 Replies

Forms Data Controls :: Two More GridViews Acting On Each Other

Mar 28, 2011

I 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 Replies

DataSource Controls :: Convert MDF & LDF Data-sources To SQL Server

Feb 6, 2010

I just installed the SmallBusiness Starter kit from MSDN. I believe the starter kit by default points to MDF and LDF files in App_Data folder but I would like to use my SQL server instead. Could you please provide me with instructions on how to convert these two files in actuate tables in SQL server?

View 5 Replies

Forms Data Controls :: How To Move Items Between Two Gridviews

Sep 16, 2010

how 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 Replies

Forms Data Controls :: Overload Page With Many GridViews?

Nov 4, 2010

I 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 Replies

Forms Data Controls :: Sort Not Working In All Gridviews?

Nov 2, 2010

I'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.

View 2 Replies

Forms Data Controls :: Client Login And Gridviews?

Sep 19, 2010

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 Replies

Forms Data Controls :: Multiple Gridviews On A Form?

Jan 31, 2011

I 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 Replies

Forms Data Controls :: Loop Through All Gridviews On Page?

May 26, 2010

I 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;

View 4 Replies

Forms Data Controls :: Copy TemplateField Between GridViews?

Mar 17, 2010

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:


View 1 Replies

Forms Data Controls :: Gridviews Move Other Objects On Page?

May 19, 2010

I have my gridviews, buttons and labels put into tables:


Here is how the page looks when I run it:


Then when I select an Order this happens:


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?

View 4 Replies

Copyrights 2005-15, All rights reserved