I am using a formview and trying to get the empty data template to display. How do I do this? I've tried not databinding, databinding when there is nothing in my table and it just doesn't show the empty data template.
View 7 Replies
I having problem to show footer template at data grid when there is an empty data. I need to show the footer template in order to let user input new record.
[Code]....
When I click on the Alphabets it will show the details of a player...however, when that particular letters has no details of the player..I want to show."No results can be found"..Is there anyway to do it?
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["CurrentAlphabet"] = "ALL";
this.GenerateAlphabets();
[code]...
I want to change the text of gridview empty data template based on diff scenerio's.
View 3 RepliesI want to show a message when there's no data in my datalist. I found the following, but, I get an error on the bool. If you have another way to do this, great, but, I'd also like to try to do it this way as a learning experience.
<asp:DataList id="DataList3" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
<asp:HyperLink ID="ID" runat="server" target="_parent" NavigateUrl='<%# "Employment_detail.aspx?"%>'
Text='<%# Bind("WJTTL") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="lblEmpty"
Text="Nothing here." runat="server" Visible="true">
%>Visible='<%#bool.Parse((SqlDataSource1.Items.Count==0).ToString())%>'> </asp:Label>
</FooterTemplate>
</asp:DataList>
I have a sql database that on some field will have a empty string/field. I am using a Datalist to display my results. How do I not make the labels that are empty not display? Currently if the field is empty it will leave a space there which my goal is if the field is empty do not leave a white space instead move the other colunms up.
View 2 RepliesI would like to find controls in the detailsview control placed in the EmptyData Template of the gridview. I am trying to create Insert new record for the gridview control.
1. If there are existing records in the table - works fine and sets my two values: I placed Detailsview and Insert Button in the footer of the gridview. I needed to set the values of two fields. When I click on the Insert button it saves new record and sets the field with the value (code attached - works fine). I also have a popup extender that opens detailsview - this works just fine.
2, If ther are not records in the table - saves record but cannot find and set controls on the detailsview Same thing setup in the EmptyData Template. The record is saved but I cannot Find and set the field value on the control.
1. Link button (on click) in the gridview footer (works fine)
protected void LinkButton1_Click1(object sender, EventArgs e)
{
string zupa1;
zupa1 = ddlSelectEmployee.SelectedValue;
try
{
DetailsView zupa = (DetailsView)gvTraining4.FooterRow.FindControl("DetailsView1"); TextBox zupa2 = (TextBox) zupa.FindControl("txtInsertEmployee");
zupa2.Text = zupa1;
}
catch
{
}
DetailsView dettraining = (DetailsView)gvTraining4.FooterRow.FindControl("DetailsView1");
TextBox training = (TextBox) dettraining.FindControl("txtTrainingType");
training.Text = "4";
}
2. EmptyDataTemplate.FindControl - can save record but cannot access txtInsertEmployee and txtTrainingType
DetailsView zupa = (DetailsView)gvTraining4.EmptyDataTemplate.FindControl("DetailsView1");TextBox
zupa2 = (TextBox)zupa.FindControl("txtInsertEmployee");TextBox
training = (TextBox)dettraining.FindControl("txtTrainingType");"4";
How do i access the controls placed in the empty data template?
I am using the following link to create empty data template and i have added text boxes in the footer
[URL] ....
How to display empty GridView to insert new record if no data retreived for some record on the result from data table?Actually i am trying to give a user an option to add recrod from Gridview. On result of some query it is perfectly displaying data and a footer row with the insertion textbox but when there is no data in the gridview it is not displaying. It should display with footer having insert textbox.
View 5 RepliesI have a listview control bound to an SqlDataSource. As part of the formatting I want to add a title to the data returned from my database. For instance if the data base returns a phone number I want to add 'Tel.' first. However I do not want to diplay this
title if the datafield is empty. Here is what I have done so far.
<ItemTemplate>
<asp:Label ID="BusinessLabel" runat="server" Text='<%# "Tel. "+Eval("Business") %>' CssClass="TeleStyle" />
Or This:Tel.
<asp:Label ID="BusinessLabel" runat="server" Text='<%# Eval("Business") %>' CssClass="TeleStyle" />
</ItemTemplate>
Business is a phone number. If the data field contains a number I get: Tel. 1234 123456. If the field is empty I get Tel. If Business is null I want nothing dsplayed, how do I do this?
is it possible to display Null. if my sql data is null while binding it with gridview in asp.net
[Code]....
[Code]....
for example like this
[IMG]http://i53.tinypic.com/n51ogh.jpg[/IMG]
i was able to implement a gridview with insert, edit and delete features, but I NEED to be able to display an empty row for insert even if the select statement returns no row. How do I do that?
Here is the code I have so far:
<asp:Label ID="Label2" runat="server" Text="Accession # "></asp:Label>
<asp:TextBox runat="server" ID="accession_num" AutoPostBack="True"></asp:TextBox>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:pdmstestConnectionString %>"
[Code]....
I am having a bit of frustration trying to display an image save in a folder after upload in a datagrid. The image path is being return but the image does not displays. When I check the image properties is empty. THis is what I've been trying.
[Code]....
Here is where the image is being save: imagePath = "C:\inetpub\wwwroot\soweb\page_images\image1.png" If I change the path in the database to: page_imagesimage1.png, the image is display in the datagrid.
I have a ListView control that might be empty sometimes. I would like to show a text message like: "No items to Show" when the ListView is empty.
I have read the FAQ of this forum. This issue is not there.
I'm trying to execute a query and display the result in grid view.Its working well...
However,I wish to display some simple text like"No tuples selected" making gridview visible to false if there are no rows selected for that query executed.Is there a way to do that?
How to set letter NO in gridview is empty record...
View 1 Repliesmy data is in dataset is like this:
firstname lastname middlename
xyz xyz1 xyz2
Pqr pqr1 pqr2
i want to it display like this format in datalist
firstname xyz Pqr
lastname xyz1 pqr1
middlename xyz2 pqr2
i am not able to set this table formate in item template of datalist.
I have a datatable with the following column names
ProviceID, ProvinceName, Year,
TPM, PM 10, PM 2.5, B(a)p
I'm trying to display data from this table in a gridview using template fields. Here's an example of a label in my item template
[Code]....
When i bind data to this grid view, i get an error saying column "PM 2" was not found. For some reason, the program is dropping the .5 from the column name. I am exploring the possibility of replacing the number with alphabets only but this may not be possible as the end user may not find it user friendly. Is there a way for me to get around this problem? I get a similar problem with B(a)p, it drops everything after the B. Any ideas on how to get the gridview to bind column names with special chars in it?
I have seen several Web Sites that use GridViews that have lookup fields with different Value and Text Fields (as in drop down lists) but I can't seem to figure it out how to display the Text Field in the Item Template when the Text Field is not in the datasource. .
Here's what I have. I have a Gridview whose datasource is a Linq to SQL Invoice table, e.g.
InvoiceID
CustomerID
InvoiceNumber
THe Customer table is related to the Invoice Table thru the CustomerID. The relationship is defined in SQL Server and is displayed in the DBML.
I have created a template field for the CustomerID field in the Gridview. I would like to display the CustomerName when the Item Template is displayed and a DropDownList in the Edit Template. The DropDownList works great, but I cannot seem to figure out how to display the CustomerName in then Item Template.
I seem to remember seeing in some video that you can simply drag the CustomerName into the CustomerID Item Template Field. But I can't seem to find the customerName field. The DataSource includes the Customer Table because of the relationship, but no fields are displayed.
I suspect this is real simple, but I cannot seem to find an article or video that explains how to do this.
i'm using a repeater with an hyperlink and i'm displaying some data from a table x and when the link is clicked i want to add some from the displayed data in another table y..I used a datasource for selecting information , should i use another datasource for the insert command or what to do ..
<asp:Repeater
id="rptproduct"
DataSourceID="SqlDataSource1"
Runat="server">
<ItemTemplate>
<asp:label
id="labCode"
[code]....
I 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
I have a gridview. In that i am displaying links. See belw code
<asp:GridView
ID="grd"
AutoGenerateColumns="False"
[code]...
I wish to add a sub to vb file that changes the display value of several asp:panels located in a Formview Item Template. My only question is what is the proper event to run this in. (databound, item created etc...) If it matters this formview appears in a Gridview Item Template.
View 7 Repliesbelow data are getting from the db
COL1 Col2
a b
c d
i want to bind the col1 and col2 value in one template field column inside gridview .is this possible means how to do this below is the format i expected. i don;t want to do this in db ..
COL
a(b)
c(d)
I have a gridview ...asp 2.0 and VS 2005.The Gridview has template fields and I am using a Header Templete and an Item Template field.Within the Item template fields I am using a asp: table and within the table I am using different asp controls to bind data to the gridview
Here is the issue ...I want that each datafield should align with each other eactly i.e. symmetricaly each column wise.The problem as of now is that as each row of data is displayed in a new table and as a result each column aligns differently.How can I align the columns with each other?
<ItemTemplate>
<asp:Table>
<asp:label> ...<Eval(datafield) </asp:label>[code]....
