How can I add a column, and then under that column fill in the data based on a databound column? Please read my code below. The code below adds a row like I want, but adds another cell.
Code:
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
If (DataBinder.Eval(e.Row.DataItem, "court") = "D072") Then
[Code]...
I have a web page like the page in the link given below.
[URL]
In this there is filtering colums. I want to display these in the left side of the list not on the top.
I have given an access to stored procedure, which i'm not able to edit. This Stored Procedure returns a Table with 2 Column, what I did is set a GridView's DataSource using SQLDataSource in this stored procedure. but I want this GridView to Sort an specific column to descending whenever this GridView Loads.
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource2" ForeColor="Black"
Width="58%" Height="125px" AllowPaging="True" AllowSorting="True"
PageSize="5" >
<Columns>
<asp:BoundField DataField="DateOccur" HeaderText="Login Date"
SortExpression="DateOccur" />
<asp:BoundField DataField="TotalMinutesPlayed" HeaderText="Total Minutes"
SortExpression="TotalMinutesPlayed" />
</Columns>
<AlternatingRowStyle BackColor="#EFEFEF" />
</asp:GridView>
Using ASP.NET Web Forms.I am databinding a DataView to a DataGrid with AutoGenerateColumns set to trueThe final column of the DataView is not rendering.Using the debugger I can see that the column definitely exists in the data grid's datasource. The column is of type decimal and some of the rows in the column have data in them.The column has a column name.The other columns are rendering fine.What's going on?Some more infoFunnily enough, I can set AutoGenerateColumns to false, then just add the columns manually:
datagrid.Columns.Clear();
foreach(DataColumn column in dataView.Table.Columns)
{
datagrid.Columns.Add(new BoundColumn {
HeaderText = column.ColumnName });
}
datagrid.DataSource = dataView;
This works fine. Why can't .NET do this with AutoGenerateColumns?
I have a data bound column in grid view. When a particular value in a cell is getting processed I want to display an image in the cell.
View 2 RepliesI have a condition on which i have to set the column of the datalist at run time.IT may be 2,3 or 4 at run time. How i do it. plz replay as soon as possible.
Is this possible that on the item bound event i set the html <tr><td>.
I have a stored procedure (For Eg: sp_GetAvlData) that accepts a number of parameters, 3 of which are TimeFrom, TimeTo (as varchar) and TimeInterval (as int), formulates a Dynamic query and executes itself. So for instance, if I call the proc as follows:
[code]....
dtAvl is the datatable containing the results of my stored procedure.
The next step for me is to make each of the cells (except the cells in the first column) as a Hyperlink so that when clicked upon a cell, it populates 2 textboxes with the selected Timeslot and Name or ID (ID field is not displayed in Gridview). The textboxes are located on the same page but outside of the Gridview control.
The Challenge that I'm facing out here are:
1) As you can see, the field names being generated are not fixed and I have no control over them.
2) Because the field names are not fixed I'm not sure I can implement this using the Templatefields or BoundFields of Gridview.
Is there any way to achieve the Hyperlinking of these cells within the Gridview?
i have a FormView, and i already have a Label control that gets the value of theselected propery inside the FormView, so each time the FormView displays data, i have a Label control that displays individual values, according to the value of the FormView, here is the code:
[code]....
What i would like to do is to know how i could add a DataList instead of a Label, and then each time the FormView databinds an item, to show the value of the DataList How would i go about doing that?
I want to render something like this (with ASP.Net Controls in the codebehind):
<ul>
<li class="first"><h1>This is a caption</h1></li>
<li><a href="#" title="" target="_self">Foo</a></li>
<li><a href="#" title="" target="_self">Foo1</a></li>
<li><a href="#" title="" target="_self">Foo2</a></li>
<li><a href="#" title="" target="_self">Foo3</a></li>
<li><a href="#" title="" target="_self">Foo4</a></li>
</ul>
<ul>
<li class="first"><h1>This is a another caption</h1></li>
<li><a href="#" title="" target="_self">Foo5</a></li>
<li><a href="#" title="" target="_self">Foo6</a></li>
<li><a href="#" title="" target="_self">Foo7</a></li>
<li><a href="#" title="" target="_self">Foo8</a></li>
<li><a href="#" title="" target="_self">Foo9</a></li>
<li><a href="#" title="" target="_self">Foo10</a></li>
<li><a href="#" title="" target="_self">Foo11</a></li>
</ul>
The amount of li elements that will be rendered into each ul is determined at runtime. Each link in a li belongs to into a specific ul (the one containing a specific caption. Imagine this as a kind of a treeview with nodes and subnodes) During the bind Event I need access to an ASP:HyperLink that will be rendered into the a-element. Which databound ASP.Net control should I pick for this? Looks like a repeater in a repeater, which should make the databinding process ugly. I'm thinking about creating this HTML-Output with StringWriters myself.
I am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 RepliesI want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
1) For some reason the MainDivision column in this is displaying bold and centered (the rest are left and not bold). Anybody see something that creeped into this markup that might be causing this?
HTML Code:
[code]....
2) How can I add a non-databound checkbox to a gridview? It only seems to appear if I bind it to something, but I want it so the user can check which rows he wants to perform an action against, so it has no value other than UI interaction.
I'm working in a web application and my page is using a databound formview control.
When i first enter the page via my code, I am unable to retreive a value from any of my controls -e.g. when i debug, i see that tbDate.text has no value (see code below).
I know that the page is getting the data, because after the code runs, i see all the data on my form, but how can i pull values from the controls via my code?
Code:
if (!this.IsPostBack)
{
TextBox tbDate = (TextBox)FormView1.Row.Cells[0].FindControl("txtDate");
}
i am new in ListView Control. I have a List view to show shopping products. in each data Item i put a link-button for "Add to cart" button. in my scenario clicking on this button causes ShoppingCart.Instance.AddItem("Product GUID") to call. how can i perform that?
i set CommandName="Select" in Link Button and performed this:
[code]....
In my XML, it's possible for an apostrophe to appear in a node's value:
[code]....
I've noticed that the text is correctly displayed in the asp:TextBox but not in the INPUT element. I'm assuming that it's because server controls correctly escape the apostrophe. To work around this, I tried changing the Description node in the XML to the following:
<Description>This is section 'A'</Description>
Again, this displayed correctly in the asp:TextBox, but not in the INPUT element.
My next attempt was to wrap the node's value in a CDATA:
<Description><![CDATA[This is section 'A']]></Description>
Finally it was displaying correctly in the INPUT element, but now the asp:TextBox displayed the two "& # 3 9 ;". I've even tried "& a p o s ;" but the result is the same.
What is the best approach for the use of apostrophes in XML where the value can be displayed in either a server control or HTML element?
I'm currently analyzing the code behind for a web application. The Default page contains a GridView with several bound DataFields that are supposed to be populated, when the page loads and reloads, with data based on a URL parameter that's passed on initial load. The way it works in summary is this:
-I have a GridView1_Init method that is called when the page loads, this retrieves data using an OldDbConnection and a URL parameter appended as part of the OleDbCommand SQL statement.
-The data is read and stored in the Web.config file. At this point, when debugging, I can see and verify the there is data being retrieved.
-Now I'm calling a GridView1_RowDataBound method to populate each row. I have it in the Default.aspx page within the GirdView parameters as OnRowDataBound="GridView1_RowDataBound"
My problem is that this method never gets called for one of the URL parameters I'm passing and as a result the Databound rows in the GridView don't get populated and the page displays nothing. I have another URL parameter I use to test and it works perfectly with that one, i.e. the page loads with the Gridview displaying all the data as expected. I'm not sure why the method GridView1_RowDataBound is getting called for one URL parameter, but not for the other. I've debugged using both and also ran the query in SQL Server Management Studio and I am getting data back for both.
I do not know why it did not return any records. I ran the sp , it return record. if I change the sp to DBComm.CommandType = CommandType.text and put the sp into the text.
It worked ,too. See below my sp.
Public Sub LoadCertification()
'Dim myConn As New SqlConnection
Dim DBComm As New SqlCommand
Dim ds As New DataSet
If myConn.State = ConnectionState.Closed Then
myConn.ConnectionString = ConfigurationManager.ConnectionStrings("NurProfileString").ConnectionString
myConn.Open()
End If
Dim drCertification As SqlDataReader
Try
DBComm.Connection = myConn
DBComm.CommandType = CommandType.StoredProcedure
DBComm.Parameters.Add("@EmpID", SqlDbType.Int).Value = Session("EmplNO")
'tblNurProfileCertification
'
http://www.shotdev.com/aspnet/aspnet-vbnet-gridview/aspnet-vbnet-gridview-databound/
DBComm.CommandText = "NurCerti_Log_Read" '
drCertification = DBComm.ExecuteReader()
dgCertification.DataSource = drCertification
If drCertification.HasRows Then
Response.Write("ABC")
End If
dgCertification.DataBind()
drCertification.Close()
drCertification = Nothing
DBComm.Dispose()
Catch objError As Exception
Dim myarraylist As New ArrayList
myarraylist.Add("fliao@holyredeemer.com")
Exit Try
Finally
End Try
End Sub
Here is my stored procedure
USE [InternalEduTest]
GO
/****** Object: StoredProcedure [dbo].[NurCerti_Log_Read] Script Date: 03/03/2011 13:12:14 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[NurCerti_Log_Read] ( @EmpID nchar(10))
AS
SELECT [EmplID]
,[Certification]
,[CDateObtained]
,[CDateExpiration], ID
FROM [dbo].[NurProfileCertification] where EMPLID = @EmpID
I have a table in the itemtemplate of a gridview.
My requirement is something like what's shown in the below link
[URL]
i.e. Say 3, 4 and 5 are user id's. The middle column can contain some information about that user. Say for User 3 we have Info 1, Info 2 and Info 3 in those three rows. Similarly, for user 4 and 5, we would have some values in the middle column.
The number of rows in the middle column can vary. It depends on the number of rows returned by the DB call for that user.
So, how can I achieve this using grid view?
Will it be possible for me to add rows in the databound event dynamically by looking at the previous or next row in the datasource? If so, how should I go about it?
Depending on the case, I'd like to hide a databound control in a page. But no matter what I try, it seems like the control will try biding no matter what. I've tried setting Visible="false", but it would still try to bind. I've tried putting the control into a placeholder and then hide the placeholder, it will try to bind anyway. I've also tried putting it into a MultiView, same thing. You would think that in a wizard interface using a MultiView you would not want the controls in the next steps of the wizard to bind, but no. It binds anyway...
The only way I've found is to unset and set the DataSourceID property which seems to prevent binding.
Is this really the only option?
I use a repeater on my website.
My code for this example is
<ItemTemplate>
Item: <%#DataBinder.Eval(Container.DataItem, "Col")%><br>
</ItemTemplate>
Now, depending on the result of the dataitem will depend on what I want to display. For example, The databitem may show a true or false value, and depending on which one I want to show a different result on my page. So instead of it display true, it display a string. EG, if true, the text 'in stock' would display.
At the moment, I am using a method to call a function (please correct my terminology - or let me know my terminology is right!).
html:
<ItemTemplate>
Item:
<%#CB(DataBinder.Eval(Container.DataItem, "Col"))%><br>
</ItemTemplate>
code behind:
public string CB(object o)
{
//perform something
return string.format("");
}
Is this the best way as it appears to be an ugly fix in my opinion. Especially as I have several items on my page which will have to use this (ususally just checking if there is a value in the dataitem or if it is empty/null)
I have a content page that displays search criteria in a div. I would like to hide the criteria div when results are returned, but keep it visible if no results are found. I have code in the DataBound event for the gridview that displays the number of rows returned from the query which works fine. To show the search criteria, I have a RegisterStartupScript which calls the javascript function to show the div. Even though the RegisterStartupScript code is executed, the javascript never runs (I put an alert in the function that never fired). Is this a lifecycle timing issue? I just don't see how I can register the javascript earlier in the page lifecycle if it is. I would think this is a very common requirement.
Sub Master:
[Code]....
[Code]....
Sub Master.cs
[Code]....
[Code]....
Content Page:
[Code]....
Content.cs
[Code]....
I use a ListView along with an ObjectDataSource tied to a business object. This object is defined as follows:
public class Employee
{
public int Id;
public string Name;
}
When I try setting the DataKeyNames property of the ListView to Id, ASP.net blows up and says: DataBinding: 'Employee' does not contain a property with the name 'Id'. However, when I change the object to that:
public class Employee
{
public int Id {get; set;}
public string Name;
}
It works!!!I couldn't find any documentation about this behavior. Why is it not accepting a simple variable for DataKeyNames and instead it insists on a property?
I have a control that inherits CompositeDataBoundControl. Based on the values of the bound data, I create som dynamic controls. In order to preserve state, I need to recreate the control tree on every request(from CreateChildControls):
[code]....
The problem is that on postback the PaymentMethod object is null, so I have no method of knowing what kind of control to recreate. That means that the control state is ruined. If I hardcode the type of payment control to make, it works as expected:
UserControl userCtrl = (UserControl)Page.LoadControl("~/WAF/View/VisitControls/Shop/CreditCardForm.ascx");
dataContainer.Controls.Add(userCtrl);
userCtrl.ID = "CreditCardForm";
how I can find out what payment method is used, so that I can create the correct control on postback?
Say i have a TextBox control inside of a ListView where the text is DataBound and I want to use TrimStart. What is the proper way to define the char parameters? When I enter an apostrophe I get a server tag not well formed error... Example below:
<asp:ListView> <!--here-->
<asp:TextBox runat="server" Text='<%# Eval("Value").ToString().TrimStart('.',':') %>' />
</asp:ListView>
This is a simplified example of what I am really doing. In my situation I must do this trim in the aspx page.
i have a RadioButtonList and the list is bounded by a datasource.
By default, its default selected item is empty, i would like to know how i could make the first thing it databounds into, should be the selected item.