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:
239
Stack Trace:
[Code]....
[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
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.
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?
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.
Recently I have developed a new dynamic data website and it works fine the the VS2008 dev server.
However upon deploying to iis 6.0, I'm getting the following error:
Server Error in '/jdj' Application.
Specified cast is not valid.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Specified cast is not valid.
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?
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.
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.
I have the this current design. I use a web service/jquery perform client-side validation and to return 1 of 4 integers. At present I store it in a hidden field but it could be passed directly. I then deploy4 validators that when validated, validate the integer and trigger a custom error message. The ideal scenario I would like to be able to do this with one validator and switch the error message accordingly. On the server side the code could look like this:
[Code]....
As you can see my error messages are held as strings elsewhere which I reference for continuity throughout the project. unformtunately I don't know how to achieve this client-side by calling a javascript function. Sure I could hard code the messages in the javascript file as well, but this would mean that they were held in two places and suseptable to error. It may be an option to return an error message in the web service rather than an integer and trigger if it is blank.
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.
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?
I need you assistance, Dynamic Delete LinkButton with CommandName=Delete gives me an error: Delete can only be called on a valid data item. nfact I am designing a Complex Grid using .Net 3.5 ListView Control with Scrollbar and Fixed Toolbar: This grid consist of 3 Tables:
1- footer 2- Toolbar Control 3- Scrolling Data Grid with Header
ListView give us only one ItemPlaceHolder to Bind Data as per LayoutTemplate, so I cannot able to manupulate my Toolbar Controls with ItemTemplate :(, therefore I decide to use ItemDataBound to add ImageButtons Dynamically using Init Page Event and I am able to get the result as you saw above:
ImageButton with funnel icon is with CommandName="Filter" ImageButton with magnifier icon is with CommandName="View" ImageButton with stop icon is with CommandName="Delete"
Now I can able to handle Filter and View with OnItemCommand Event but when I click Delete button I am getting an error as shown below: The grid used CSS I am sending you the HTML and code behind to resolved this problem: HTML CODE:
I have a dynamic Table which contain 8 rows and 8 Colums
Table t = new Table(); TableRow rr = new TableRow(); TableCell cc = new TableCell(); and in the each Cell CC I add a dynamic Button(Or Linkbtn) LinkButton LB1 = new LinkButton(); LB1.Text = "AM"; LB1.ID ="Link1"; cc.Controls.Add(LB1); rr.Cells.Add(cc); LB1.Click += new EventHandler(LB1_Click); t.Rows.Add(rr);
i have a table with 8 rows , 8 colums and each cell contain a LinkButton (which diffrent in IDs) I want to add Lable in the same cell of this LinkBtn(LB1) which it clicked but I cann't What shoud I write here?
I'm creating a page that allows the user to create a new object that will later be stored in the database. The problem is that the design of ASP.NET data controls seems to insist upon only working with pre-existing data that has been stored in a database (or XML, etc...).
I'm basically trying to get the user to compose a list of items and specify a quantity for each item. I could do this by generating table rows but the rows are lost at each postback. The data view controls seem to be designed only to be bound to a data source but until the list is complete, the data can only be in memory.
What control is appropriate for this and how can I achieve this with that control?
In windows forms, there is the "show data sources" under the "data" menu item, and I love it because I can drag and drop the fields I need onto the form and it makes the control automatically.In web forms however, this option isn't there. Why? I try to drag and drop fields from the "server explorer" but it generates grids, I don't want grids I just want to drag and drop the text boxes or checkboxes etc.
I have a ReportViewer control on an ASP.Net page and an RDLC set up that uses a TableAdapter that pulls one record. This works fine.I'd like to have the *same* RDLC use a different TableAdapter (schema of table is the exact same, but may have multiple records). I've tried putting two DataSets in my RDLC and having the code dynamically select which one to use, but it's not working quite right for me.
I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:
[Code]....
When I transfer the *.rpt files to a different server, the reports display data from the development server; even when I change "Constants.DatabaseName" to point to the new server. It seems like the *.rpt file saves the database connection information from the ODBC File DNS used when creating the report.Has anyone experienced this problem? I'm looking for a solution so I don't have to create multiple copies of my *.rpt files for each server environment (i.e., Dev, Test and Production servers).
I am writing a currency converting module for one of our applications. I have a list of products, a list of currencies we are interested in seeing prices for, and a list of currency rates. I want the user to be able to select which currencies from the list they see in the GridView. I also want to be able to amend my list of currencies and include a new currency, without having to make additional changes to this module. So my GridView display has to be "dynamic". Essentially I am planning on ending up with a GridView that has the following columns:
Part No - Description - USD Price - AUD Price - GBP Price
The USD price would be static as it's our base currency, the AUD and GBP are user selected and could have potentially any number of currencies listed. I would normally use a DataSet and DataTables for this work, but I am sure there is a "better" way to do it using System.Collections.Generics. Right now I have all of the data I need in List collections, but there does not seem to be a way to define how these collections relate to each other, or combine these collections into one so it can be bound to a GridView. Should I be looking at something other than List to achieve this or do I need to go back to my original approach of a DataSet and DataTables.
**UPDATE / SOME CODE**
I will explain a little bit more about what I have setup so far.
1) List of Products & Currencies - These come from an SQL DB via LINQ, so they can be any of the System.Collections.Generics objects, e.g. List, IEnumerable etc.
2) Currency Rates - These I am pulling from the European Bank public XML file. I download the file, strip the data I need out of it and currently store that as a List object.
I could store the currency rates in the database table as well, but then I have to have some sort of background process that goes and updates the rates each day. This way the rates only get updated when someone accesses the report function (which is only going to happen occasionally). So I would rather grab the latest rates "on demand". What I know I need to end up with is some object that has the following structure:
Where the number of Currency Prices is undefined, as it's based on what currencies the user wants the report to display. It's the undefined part that I am struggling with, essentially how can I create a structured object, that I don't know the complete structure of until runtime?
When I am designing a report, I usually leave the Website Data Sources window up so that I can access the datasources in my project. I can then drag fields to the surface of the report to design the layout.For some reason, the list of entries in the window is getting more and more cluttered with references. I have no idea how these are being added and I can find no way to remove or "exclude" them from the list. Entries included are:
System Microsoft.ReportinServices.RdObjectModel Microsoft.ReportingServices.Common System.Collections.Generic More....You can see a screenshot of what I mean here:
http://img6.yfrog.com/i/wsds.jpg/
w how to remove these from the Website Data Sources window?
I created this simple dynamic data form using Dreamweaver cs4, ASP VB technology and a MySQL Database: I love all of the extended functionality that VWD 10 provided, but the most important functionality for me is to be able to completely design a dynamic data table any way I want.
I noticed after researching extensively that the GridView, ListView and DetailsView templates still leave me very limited in what I can design. My question: is there a way for me to design a table in a details page with record placeholders that will be fetched from a master/detail page set?
