I have the code below, it all works if the BoundField is set to Visible = "true", but if i change it to "false" then my conditions are not being met and page logic doesnt work.
What am i doing wrong?
[Code]....
I am using gridview with sqldatasource , now i have a column
<asp:gridview ID="MyGrid" runat="server" AutoGenerateColumns="False" datakeynames="Seq"
DataSourceID="ExistingConsPhaseSource" >
<Columns>
<asp:boundfield datafield="Seq" headertext="Seq" readonly="True" Visible="False" sortexpression="Seq" />
<asp:templatefield headertext="Description" sortexpression="Description">
[Code] ....
I also have a button outside gridview , on its click event i want to delete all rows in a grid view. So far i have done like this :
protected void DelAllExisting_OnClick(object sender, EventArgs e) {
foreach (GridViewRow row in ExistingConsPhases.Rows) {
string query =
"UPDATE [dbo].[myTable] SET IsDeleted = 1, DeletedBy = @DeletedBy, DeletedDate = GETDATE(), DeletedByPrefix = @DelPrefix WHERE Seq = @Seq";
SqlCommand comm = new SqlCommand(query,_connection);
comm.Parameters.AddWithValue("@Seq", ???);
comm.ExecuteNonQuery();
_connection.Close();
}
}
What to type instead of ??? I want my bound field of Seq to be place here ? how ?
Hi I have a situation where I want to set the initial visible property of an Image to False and then in my code change it to True and then run a sub routine. My problem is that no matter how I order the code the sub runs before the image becomes visible. When I debug the image only becomes visible when it hits End Sub. Is there any way around this? Here's my code:
[Code]....
I have a form with a ton of gridview controls on it. All of which are driven by a dropdown list control. When I select a value from the dropdown list control it populates the 5 gridview controls with data from the database.If there are no rows associated with the record from the dropdown list then I am going to set the visible property of all of the gridview cotrols to false.
I know how to set the property I just need to know where I would set it and what I would check.I can put my code in the selectedindexchanged event for the dropdownlist control but how do I check to see if there are no rows associated with that value? Maybe some sort of If gridview1_rowdatabound = 0 then...
I have a listview that renders like this:
yearsexp: 4
desc: a description text on the row databound, if there is no value for yearsexp or desc, I would like to make it not visible. The other one needs to still be visible. So far I have
[Code]....
<asp:ButtonField Text="Void" ButtonType="Link" CommandName="Void" />
' RowCommand
Dim f_iIndex As Integer = Convert.ToInt32(e.CommandArgument)
Dim f_oSelectedRow As GridViewRow = grdMeterCorrection.Rows(f_iIndex)
Dim f_oCertIdCell As TableCell = f_oSelectedRow.Cells(11)
Dim f_sCertId As String = f_oCertIdCell.Text.Trim
If e.CommandName.ToLower = "void" Then
Dim f_bVoidRet As Boolean = VoidCert(f_sCertId)
End If
The problem is the CertId field in the GridView has visible set to false. I think this makes the value unaccessable to the RowCommand.
I'm trying to make my TD visible or not inside a repeater. I keep getting an error "Object reference not set to an instance of an object". here is my code:
[Code]....
and my code behind:
[Code]....
I know it has something to do with how my findcontrol code is written, but I can't figure it out.
I have template field named "MenuItemId" which is visible false and in that i have taken hidden field (Htmlinputhidden) control. my requirement is i dont want to show that MenuItemId in the gridview but want to access the value of that column (i.e. hidden field). I am creating node of the xml from the headertext.
[Code]....
I have a gridview that serves as a confirmation for user input in a previous form from a previous page. The grid is databound to a temporary table where I store the user's initial selections. The user can confirm what they had submitted, (which may be more than one row of information, up to three classes) or go back and change. When they hit the confirm button, I loop through the gridview and enter a row in a permanent database for each row in the gridview. This works great.
However, I don't want the gridview to display all of the columns that are actually in the temp database, because I'm carrying over 'usersubmitted, datesubmitted', etc, from the previous page for each class selected and this is redundant. (I do need to use all of the columns when they submit, however, to make a new row with complete information for each selected class in the permanent database) So, when I set the usersubmitted column visible false, for example, in the gridview, the dataset table adapter insert function fails with a data type mismatch error. I'm assuming becuase the column has to be visible, becuase when I make it visible again it works.
Can you loop through a gridview and call on cells in columns that are not visible?
The first page is like this:
the user fills out his info once in text boxes
name ____
address____
then selects up to three classes in dropdowns:
class one dropdown ...
class two dropdown....
for each dropdown, I insert name, address, class selected into a temp db Second page.
Gridview should display only classes selected, one row for each, and not
name address class selected
name address class selected
then when they submit, I insert
name address class selected
name address class selected
one row for each in permanant database
I have a problem that in DetailsView Edit Mode, if I go to edit fields, and set a fields visible property to false, when I update the record through the built in update options it sends a null value. If I change the field back to visible, it passes the data just fine.
Consequently, I tried just setting the field to Read Only = True, and got the same result even though the current values do show up in the edit mode, just read only.Is there anyway to hide the field but still allow it to pass the data it currently has "BACK" into the record.
How can you access data in a GridView cell with Visible = false?
[code]...
I have a database field called ImageLocation, I have the ImageUrl property bound to: Eval("ImageLocation", "{0}")I would like to bind the Visble property to false if the ImageLocation is null data. I can not figure out how to set the control properly, currently the Datalist shows me all the data and when the image location is null it shows me the name of the Hyperlink control which happens to be Hyperlink2.
View 2 RepliesI have a problem displaying data in a Grid View control when set a row to visible = false when a certain condition is true.
For example, if a DataRowData value has a condition set to true (custom in table) I set the visible property to false, so the data row will not be visible at run time.
The problem is that I'm using paging (10 rows per page) and if 8 of those rows fall into the true condition that won't show the row, that grid view page will only show two rows of data in page 1. The worst scenario is that if I go to page 2 of the grid view and all the rows (10) fall into the true condition, that grid view page will not show any data at all.
How can I show 10 rows of data at all times in a gridview? In other words, I would like to just show the visible rows at all times.
I have a datagrid control, the first column is Revno, currently presenting info in linkbutton. i want to do a condition based on another field docid, which gets true or false value from database. if true then present Revno in linkbutton otherwise show the revbnno just as a label., thatway users does'nt have ability to clickit.
<ItemTemplate>
<asp:LinkButton ID="lblRevision" runat="server" CssClass="Textboxes" Text='<%# DataBinder.Eval(Container.DataItem, "RevNo")%>' CommandName="FileDownloadRecord"></asp:LinkButton>
</ItemTemplate>
this docid field has flag true or false.
if true meaning show the revno as LinkButton, otherwise show the revno as label.
GetDocdetail(DataBinder.Eval(Container.DataItem, "Docid")
on the codebehind side i can use this function.
Public Function GetDocdetail(ByVal DocID As boolean) As String
If DocID = "true" Then
Else
End If
End Function
I've GridView with Template field as
<asp:TemplateField HeaderText="Review">
<ItemTemplate>
<asp:ImageButton ID="imgBtnReview" ImageUrl="~/images/agt_reload.png" runat="server" Visible="false" CommandName="Review" CommandArgument='<%#Eval("id")%>' />
</ItemTemplate>
</asp:TemplateField>
Gridview is bound to a table. If a row in table has price greater than zero then the above mentioned Imagebutton should br visible in that row only.
Is it possible to do so.
I have an Objectdatasource configured with Select, Insert, Update & Delete queries in a Dataset. This datasource is linked to my Gridview. I do not require all fields in the table to be displayed or updated in my grid so i have turned off the Visible property on several.
However, when i go into Edit mode and trigger the UPDATE to the database table, i get NULL values updated in the columns i set False for the Visible property.
How can i remove these columns from the GridView and the Edit mode and still have them UPDATE with their current values instead of being overwritten with NULL's?
I have Gridview with boundfield and one of the fields is weblink in data likewww.yahoo.comI want in Gridview display it shows up as hyperlinks in row.How should I modify the code for the Gridview boundfield for this field ?
View 5 RepliesI am wondering if its possibl to change the DataField value of the asp:BoundField in the code behind.aspx page:
[Code]....
I would like to change DataField="From" to DataField="To" before I call the GridView.DataBind.Please let me know if this is possible and if so how can I do it.
Probably a Q more suited for a SQL forum, but I guess it comes up a fair bit in ASP.net web site design?
View 5 Repliesi have gridview in my page
i don't want show header in my gridview i search all property of this control but i didn't find anything
I was hoping this is simple but i have problems.
Basically i was only able to set the string color with itemstyle-Forecolor.
But how do i set the background of a column and also set height,width.Ok height may not work because i have an itemtemplate with predefined height.
Can this be done in a simple boundfield or must i have all my datafields in itemtemplates?
What i do for one column:
[Code]....
[URL]
if the ABOVE pic is not visible CLICK HERE to view
I want to change the colors of the values from the table SALARY
if the salary is > 20,000 i want to change it to GREEN color
if < 20,000 then it should show RED color
in a posyback button click event i get the status(condition ) from database by executin query as said earlier currently i have this controls visible true/ false on server side code in posyback button click event after getting the condition but as suggested by u as it takes longer time on server side to makes controls visible true false to do it on client side so in posyback button click event i assigned a hidden control with the condition value now i want to pass this value to client side script so that i can toggel the visiblity depending on hidden control value from posyback button click event i am activating the setype function in client side which has the code as mentioned...wht i need is pass the hidden value to clinet side & make & position the controls on client side.
View 1 RepliesI have the following simple code:
[Code]....
So when i select "Yes" from the first drop down, the "hiddenDetail" label becomes visible and when i select "No" from q1 the "hiddenDetail" label becomes invisible.The problem is that because i am using AutoPostBack when you select "No" the "hiddenDetail" loses its children (i.e. the label inside it) which is obvious why but i am wondering, is there anyway i can make the "hiddenDetail" invisible (sort of like display:none in style) in VB without losing its children. Or is my only option to work with this in
I am basically trying to check the contents of a field in a data base (Course) to determine if a button (btnMisfills) shoulf be displayed for a specific user. I am sure ther are probably better way of doing this, and any suggestions would be appreciated. However I am using the few tools I know how. Everything works as expected as long as the DetailsView is visible, but I have no need to display the detailsView. When I change the detailsView to visible = false, my logic does not work. Apparently visible = false means the detailsview is not created. If this is true, how else can I check for the contents of the course field?s there a way to check a field in the sqldatasource?
[Code]....