Gridview Row Eval - Column As Name Parameter Instead Of Index
Feb 17, 2011
I have a gridview and the OnRowDataBound event is linked to this function:
if (e.Row.RowType == DataControlRowType.DataRow)
{
ThisRow = e.Row.DataItem as MyObjectModel;
if (ThisRow.Property1 == null) { e.Row.Cells[5].Text = "-"; }
This code looks at the value of a property of the object in the data source and if it's null, converts the null to display "-" in column 5. The problem I'm having is that if I change the order of the columns of the gridview, then I need to change the index of every other modification. What I'd like to do is change the statement "e.Row.Cells[5].Text" to something that says "the cell whose column header is xyz".
protected string CheckValue(string strValue1,string strValue2) { if (strValue1=="1") { return "No Record Found"; } else { return "No Record Found"; } }
when i run my page i get errorin my .aspx page Text='<%# CheckValue(Eval("Imagespath")+","+Eval("Imagesname")%>'> is there any way i can send my value CheckValue method which isa .cs file how can i send 2 paremeter from.aspx page can anu one tell me the syntax for it
I have a grid view with 4 columns and 12 rows. Getting the row index is not problem; ;however, I cannot find a way to get the column index of the cell that i select.
I am trying to write a small method to loop through and find a GridView Column by its Index, since it can change position based on what might be visible.
Here is what I have so far:
private int GetColumnIndexByName(GridView grid, string name) { foreach (DataColumn col in grid.Columns) { if (col.ColumnName.ToLower().Trim() == name.ToLower().Trim()) return col.Ordinal; }........
Is there a way to find out which column is selected in the Gridview row command? When I click on a gridview row in a specific column, is there a way to get the column index of the selected row?
I have been trying to hide a column but make use of the value in another function but the function i am trying to hide it give me and error at the embolded line. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Public Sub FetchDetails() Dim valtable As DataTable = New DataTable() valtable.Columns.Add("LINK") valtable.Columns.Add("WATCH PERIOD") valtable.Columns.Add("DAY ENTRY") valtable.Columns.Add("listid") Dim seltext As String = "SELECT [Watchlistname], [Watchlisturl], [Watchlistdate],[listid] FROM [Watchlist]" Dim madap As SqlDataAdapter = New SqlDataAdapter(seltext, Connection()) Dim mdset As DataSet = New DataSet() Dim i As Integer = 0, pager As Integer = 0 madap.Fill(mdset, "WATCHLIST") Session("tab") = mdset.Tables("WATCHLIST") For Each arow As DataRow In Session("tab").Rows Dim valrow As DataRow = valtable.NewRow() valrow("LINK") = arow("Watchlisturl") valrow("WATCH PERIOD") = arow("Watchlistname") valrow("DAY ENTRY") = arow("Watchlistdate") valrow("listid") = arow("listid") valtable.Rows.Add(valrow) Next 'Dim str As String = ChrW(8358) gridWatchlist.DataSource = valtable gridWatchlist.DataBind() gridWatchlist.HeaderRow.Cells(1).Visible = False gridWatchlist.HeaderRow.Cells(2).Text = "WATCH PERIOD" gridWatchlist.HeaderRow.Cells(3).Text = "DAY ENTRY" gridWatchlist.Columns(4).Visible = False End Sub
i know how to find the index of selected row in asp gridview , but i need to find the index of selected column in asp gridview ?for ex:i have i gridview contains columns with header ( the header is the primary key i looking for ) , this grid contain linkbutton , i want to get the column header name on click on linkbutton ?
I have a Formview ('formview1') with a pager. I also have a gridview ('gridview1') linked to a SQL datasource ('History'). I need to set the SelectParameter ('Serial') of the datasource to be the value of a field on the current page in the formview. The value i need to get is in the ItemTemplate and is a label called 'SerialNumberLabel'. So, something like:
<SelectParameters> <asp:ControlParameter Text = "Eval fromview1.currentpage.itemtemplate.SerialNumberLabel" >
I also need to ensure that the SQL source and gridview rebind when the pager is activated.
In my asp.net+vb web. In a gridview there is a hyperlink filed . it works fine for all company except for company name like lerson & turbo . the code i used is as below
I have a listview control on an .aspx page. Inside this list view i want to check "Type" property which comes from database. here is the example code :
[code]...
As a last resort i tried to user DataBinder.Eval() but i get the exception "Expected class, delegate, enum, interface, or struct". What can i be doing wrong? Writing a function in code-behind isn't an option for me.
in a sql table like this how to get the column index of a particular name like out put will be for "mnp" index is 3....(not according to id) what will be the sql query or if it is a datatable then what will be the code to find the column index...
AutoGenerateColumns: Flase/True ( i tried both) If i remove the gvOff.Columns[index].HeaderText portions, GridView works fine, but when i put the gvOff.Columns[0].HeaderText, i get the exceptional error.
, i couldn't solve it. If you need further info, inform me.
EDITED:
Hold on! I commented the HeaderText portion and tested int i = gvOffer.Columns.Count; I found count is 0 eventhough the columns print out with DataBind()... Why? NOTE: AutoColumn in this case is set to true. I guess i will have to edit the column names from DataTable.
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
I have a column in SQL Server 2008 called MapLocation which is stored as the geography data type. This column is used to store the location of a building in one table, and the location of landmarks in another table. I have to list all landmarks within 4 miles of a building.
I have a clustered primary key on an automatically generated int column in each table. I assume that I need to create a spatial index on the MapLocation column in the landmarks table. This I guess would aid finding all landmarks within 4 miles.
My problem is that I am not sure what settings to use for this spatial index. I have set the spatial index to have the following settings:
Cells per object: 16 Level 1: Medium Level 2: Medium Level 3: Medium Level 4: Medium Tessalation Scheme: Geography gridAre these the best settings? Am I doing the right thing?
