Listview And SQLDataSource Render Nothing?
Feb 12, 2010
I've never used either of these 2 controls before and I'm stuck with no visible rendering of the page (compiles and runs but produces nothing); I have no code behind file with this simple asp.net page and I am using Visual Studio 2008:
<%@ Page Language="C#" AutoEventWireup="true"
CodeBehind="Index.aspx.cs" Inherits="zList.Index" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListView ID="CategoryList" runat="server"
DataSourceID="Categories">
<LayoutTemplate>
<ol>
<asp:PlaceHolder runat="server" ID="itemPlaceholder">
</asp:PlaceHolder>
</ol>
</LayoutTemplate>
<ItemTemplate>
<li><%# Eval("AttrDesc")%></li>
</ItemTemplate>
</asp:ListView>
</div>
</form>
</body>
</html>
<asp:sqldatasource runat="server" id="Categories"
ConnectionString="<%$ ConnectionStrings:ZIPeeeConnectionString2 %>"
SelectCommand="SELECT AttrID,AttrDesc FROM dbo.tblAttributes1">
</asp:sqldatasource>
Here is the connection string section from web.config (I have tried both connection strings separately and they both result in nothing rendered):
<connectionStrings>
<add name="ZIPeeeConnectionString" connectionString="Data Source=MOJITO;Initial Catalog=ZIPeee;Integrated Security=True" providerName="System.Data.SqlClient"/>
<add name="ZIPeeeConnectionString2" connectionString="Data Source=MOJITO;Initial Catalog=ZIPeee;User ID=sa;Password=" providerName="System.Data.SqlClient"/>
</connectionStrings>
I am getting no runtime errors and no errors during the build. The simple query works fine from SQL Query Analyzer (i.e. SQL Server 2000). Any ideas?
EDIT-UPDATE:
Here is what I have in my .ASPX.CS code behind file and I cannot get the debugger to stop on the breakpoint on the .DataBind method:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace zList
{
public partial class Index : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
CategoryList.DataBind(); // breakpoint set here but debugger won't stop here
}
}
}
By the way, I fired up SQL Profiler and it appears the SQL select is not even being fired against
the server. As I said, the page is empty - just this junk when I scrape it via View Page Source:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1 /DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head><title></title></head>
<body>
<form name="form1" method="post" action="Index.aspx" id="form1">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKMjAyMTkwMzQ3OQ9kFgQCAw9kFgICAQ8UKwACDxYEHgtfIURhdGFCb3VuZGceC18hSXRlbUNvdW50Av////8PZGRkAgUPD2QPEBYDZgIBAgIWAxYCHg5QYXJhbWV0ZXJWYWx1ZWQWAh8CZBYCHwJkFgMCAwIDAgNkZBgBBQxDYXRlZ29yeUxpc3QPZ2TCuhjvuwDRjaGJssTwiDXpAv/fdw==" />
</div>
<div>
</div>
</form>
</body>
</html>
View 1 Replies
Similar Messages:
Dec 24, 2010
My problem is this source, never render form tag in first row. It works fine. Firefox, Chrome, IE6, IE7 displays fine but IE8 overflows first row. When i set form tag style display:none other rows does not show cart image but first row still shows.
[Code]....
View 2 Replies
Jun 9, 2010
i'm using ASP.NET + a MySql Db. I'm trying to configure a ListView so i've written:
<asp:SqlDataSource ID="dsDatiUtente" runat="server" ConnectionString="Server=12.28.136.29;Database=mydb;Uid=m111d1;Pwd=fake;Pooling=false;"
ProviderName="MySql.Data.MySqlClient"
SelectCommand="SELECT * FROM user WHERE idUser=@IdUser"
/>
At the beginning of my aspx page i've added
<%@ Import Namespace="MySql.Data.MySqlClient" %>
But if i click to the sqldatasource and click "Refresh Schema" i got this error:
"Unable to retrive schema.... Unable to find the requested .Net Framework data provider" For instance, i've installed it , but i've also uninstalled old version, then installed new versions. In my project i simple copy Mysql dll into "bin" folder, then add a reference to that dll. I'm not sure is the corrected way...
I need to have the "refreshed schema" to permit vs.net to build automatically my listview ... if i can't to "auto build" listview, i have to write all code by hand, and it is a too expensive work me :(
View 2 Replies
Sep 16, 2011
I'm trying to update items in my SQL database from a ListView. It works, but all entries in the database update. Not just the one I'm working on. I backed up the database prior to testing, so there's not any issues there.This is how my SqlDataSource UPDATE command is setup:
SQL Code:
UPDATE entries SET duration = @duration, checkinDate = @checkinDate, receivedBy = @receivedBy, cosmeticDmgIn = @cosmeticDmgIn, STATUS = N'closed'
I don't have any code setup to update the database, which is probably the issue.When I load the ListView, select edit, type in my edits, and click "Update", all the rows in my database, for that column, are updated with that data.I tried inserting the parameters manually, within the ItemUpdating event, but it never works.
View 5 Replies
Sep 29, 2010
using asp.net 4 and vs 2010 I have a listview that displays data from a database. I have to configure it to display all column data where present, however, not all columns have data, with the result that blank spaces get rendered where this data would normally be displayed.
The code:
[Code]....
So, for example, some of the individuals that exist in this table might no longer be associated with a specific department, institution or have data in the "Address2" column.
View 4 Replies
Jul 5, 2010
I have a ListView control that is bound to an SQLDataSource.
View 6 Replies
Feb 12, 2010
This seems so very simple yet I am very stuck. Following some articles on the web, I came up with an ASP.NET web app page that is all declarative (no code behind) yet when it produces NOTHING I feel so totally stuck about what I've done wrong. Here is the entire little page:
[Code]...
View 9 Replies
Dec 19, 2010
I have created a asp.net webpage for viewing daily downloaded newspaper, saved as a pdf file in a selected folder (~/NEWS/{0}) within the web root directory. Also i have a SQL datasource linked, where the news table has two columns viz: date and filename.
I want to create a tiled listview where the date text is visible on the hyperlink. on clicking the hyperlink, the file name is retreived for the corresponding date and the pdf file opens in a fresh page.
I have tried going to the item template in listview and replacing the label control with a hyperlink control, but then not able to successfully proceed ahead.
View 6 Replies
Aug 5, 2010
using .NET 4, SQL 2008 R2 and VS2010:
My issue is that the first row of data in my db table does not seem to be output to my ListView control when I run the page. The first item in the ListView control is the 2nd row of my db table.
If I execute the stored proc listed below in SQL Server Mgmt Studio all rows are returned to the query results window.
The ListView control is defined as follows:
[Code]....
View 4 Replies
Jun 18, 2010
i am facing a minor problem but can't find out its syntaxi have listview, and inside the template i have 2 labels, in design time i bind 1 label to one column thatis 'type' and depending upon this type i want to bind other labels to different columnsif type is question than 2 label will have to show data of question columnif type is job than 2 label will have to show data of job, so on........how to accomplish this,in databinding event handler i can check the value of typebut i want to know the syntax of binding 2 label in run time, with different fields using EVAL
View 3 Replies
Feb 12, 2011
I've been watching a video on Scott Hanselmnn teaching MVC 2 tricks/tips. He mentions how MVC 2 by default uses ASP.NET Web Forms view engine to render the output of the views; he mentions that the web forms view engine is a little slower than it could be for MVC 2 since it generates a control tree and then outputs the HTML to the page (I hope I said that right).
I was wondering what he meant by web forms generating a code tree before outputting the HTML to the page. Does anyone have insight on the view engine of Web forms and the steps of the rendering process works for ASP.NET and MVC2?
View 2 Replies
May 14, 2010
I am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...
[Code]........
View 2 Replies
Feb 4, 2010
I have a ListView, I've setup to use an ObjectDataSource, I've created my Layout and Item templates, and I'm able pull and view a list of my data no problem. However I want to add delete capabilities to my
ListView and my reference material tells me to go into the "Configure ListView..." option under the ListView's smart tag, the only problem is I don't have that option, the only three options in my smart tag are "Choose DataSource", "Configure DataSource..." and "Refresh Schema", what am I doing wrong?
View 7 Replies
Mar 13, 2011
I have anested ListView control. I also implemented a jQuery to automatically expand the TextBox control inside of the nested ListView Insert Template. The problem is, when the Textbox expand, the outer ListView control is not; therefore, the Textbox control expands underneath the buttons of the outer listView control. How do I expand the outer ListView control as the nested ListView textbox is automatically expand? One great example is in Facebook where if I add a response comment, it'll automatically push any comments below mine down. If nested Listview control is not the best way to do this, what are my options?
View 8 Replies
May 11, 2010
Does anyone have an example for how to create a Dynamically Templated Listview with prefernces page to specify which columns & column order)? Also the listview would also have Edit, delete and insert options if possible. And uses the n-tier approach with Bus Layer and does NOT use LINQ.
View 1 Replies
Jan 6, 2011
Is there any way to enable alternative ListView (LV2) or any other control in case when ListView (LV1) returns no records from DB? I already have emptydatatamplate designed for this case, but I need to enable a new ListView below in this particular case and I don't know how to achieve this!
View 2 Replies
Sep 30, 2010
I try to datbind a listview which is inside another listview InsertItemTemplate.
[Code]....
I'm binding the listivew in the parent listview onitemcreated events. I receive the error Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
View 4 Replies
Aug 26, 2010
I am having trouble finding how to solve the following issue :
I am using nested listviews to display Sales and Sales details.
The main ListView displays General Information about Sales and the child ListView displays the detailed information about one sale. the child listview is shown only when the user clicks on a link (see included code, DataBind is made on PageLoad) :
ASPX Markup Code :
[Code]....
C# Behind Code :
[Code]....
If I removed the datapager part, I can manage show/hide the child list view on the button click event. but if I want to use the DataPager with the PreRender event handling, the child listview is not longer shown on button click.
View 8 Replies
Apr 2, 2011
I am trying to implement a nested user control in listview and the user control doesn't get bound.
Here is my code.
[Code]....
View 1 Replies
Aug 17, 2010
Ok, background first:
The form allows a user to create and edit one estimate.
Each estimate can contain multiple Jobs, which are represented in a ListView.
Each Job can contain multiple Parts, which are contained in a ListView that sits in each item of the Jobs ListView.
A user can add and remove as many Jobs as they want.
A user can add and remove as many Parts to/from each Job as they want.
I have no issues adding to each of these, but I do have a problem removing a single part from a single job.
For a reference, here is one Job in the Jobs ListView on the form:
I want to make sure that no matter what a user does, the part of the form they are working on saves what they have. Removing a row from that Parts ListView is no exception. What I want it to do is save the values in each of those textboxes and then delete the necessary row.
Here's what I have in the codebehind:
[Code]....
The EstimateRow variable I create does not get a value from theListView)HFERID.Parent.FindControl("LVEstimateRow") bit of code. There must be another level of nesting that I'm not accessing correctly, because it can't seem to find that nested ListView.
View 5 Replies
Sep 20, 2010
I have a datakey defined on my outermost ListView. When I click on a linkbutton in a row in this listview, the second listview is displayed. This inner listview has several controls and also a linkbutton. When I click this linkbutton, it gets handled by its own event; linkbutton_click. In this event all the data is collected from the innermost listviews' controls, and sends it to the database. The only thing I need within this event is the datakey from the outermost listview.
View 6 Replies
Sep 10, 2010
how to do this when the checkbox in listview layout template check select all checkboxes in listview itemtemplate.I dont give 'Eval 'field to checkbox present in itemtemplate.
View 3 Replies
Mar 22, 2010
I am trying to populate the ListView using LinqDataSource data source but the issue I am having is.I need to load the listview on Search button click action.
IN the page_load I kept like this:
===========================================
LinqDS.Selecting += new EventHandler<LinqDataSourceSelectEventArgs>(LinqDS_Selecting);
protected void LinqDS_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
e.Result = ObjectDS;
}
=============================================
This works fine but this happens on page load,i want this binding to happen on button click?is there a way to do this?
View 2 Replies
May 31, 2010
I have a ListView1 control that his <ItemTempleae> has a another ListView2. ListView2 is surrounded by <UpdatePanel> with trigger and also UpdateMode="Conditional". But, I don't know why ListView2 is not being update as it should, I need to refresh all the page to see the new data enter to ListView2 only. What is the problem? How can it be fixed? I think that the problem is something in the structure. There are about 10 ListView2 with updatepanel surronded them, so when I am looking to update a specific ListView2, it doesn't know which one to update because there are lots of them. What to do in order to solve that problem?
View 3 Replies
Feb 17, 2011
How to handle the itemcommand event for the inner listview, here is my code:
[Code]....
View 2 Replies
