I have a query expression which I am binding to a GridView in Page_Load. The data I want to capture in the SelectedIndexChaned event is in a BoundField defined thus:
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True"
SortExpression="ID" Visible="False" />
If I set Visible="True", I have no trouble getting this data. Is there a way to hide the ID field and still get the data?
I have a GridView, and I want Column1 to be equal to datatable data (filled by a SqlDataAdapter). Then I have two other fields by the SqlDataAdapter (first name, last name), and I want to have those two fields combined to form Column2. I have a TemplateField for my GridView that combines the first name and last name with Eval()'s, but the GridView places this combined field TemplateField and puts it as the first column.
How can I do this so that TemplateField can go in between fields that are databound?
I have an ASP.NET GridView control in a Web Form. For the sake of simplicity, I will say that this GridView is defined as follows:
[code]...
When each of these rows is bound (a.k.a. during the "myGridView_RowBound" event), I want to get the ID, Name, and Age values. My problem is, I cannot figure out how to get the "ID" value. The reason why is because it is in an invisible field.
Background: I'm populating lots of asp.net c# GridViews and ListViews from a database and subsequently users may export them to Excel. I want export as native Excel (not html). I can't use office automation, and I'm using JET which works fine. I have no control over users' machines. Question: When doing the export, you have to tell Jet what type each field is, in my case "text" (varchar) or "numeric" (double). The difference is that if you export a numeric column, the users can sum the data in Excel, where as strings are exported with a leading apostrophe and so are not much use in arithmetic.
Currently I parse the first data row of the Grid/ListView, check if each value is numeric or text, and assign a type to the column accordingly. That works, except for when I have something in the first column which looks numeric but in fact is a text string. I don't want to parse every row in order to be sure I have the correct data type as some of these exports are quite large. When I load the Grid/ListView from the database, the database certainly knows what type each field is. So my question is... how do I extract the type of the database item behind a a Grid/ListView item? I could explicitly code it as an attribute on the item, but that's duplicating information I already have, if only I can get to it. I know that where I have a DataTable then I can get the underlying type from that, but mostly I don't have tables handy, just the Grid/ListView. Note that Jet will throw if you try to insert an empty string into a nullable numeric column. The way to do this is to omit that column name from the insert statement, or output a zero.
I am using gridview to display some columns with autogenerate column as 'true' and not added boundfields,headers.
And i am used stored preocedure for data source in gridview and i used dataset for gridview databind.
The gridview columns comes dynamically for each time.
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 a 3 level deep nested gridview. The expansion/contraction of each record was originally done with javascript. There were html <div> tags around each gridview. Since these were HTML div tags I could give them IDs that were dynamically bound to record ID value within the database. I then had onclick buttons that passed in a bound record ID value that coresponded to the appropriate div tag that needed to be expanded (e.g. display: inline (show it) or if it is already inline then display: none).
This worked beautifuly. Unfortunatley I wanted to be able to do in-girdview editing of the child records. When expands a parent record and clicks to edit a child record the OnRowEdit event fires which automatically generates a postback and resets the variables within the JavaScript. THEREFORE THE ENTIRE GRIDVIEW STATE BECOMES CONTRACTED.
So finally I decided to change the div tags to <asp: Panel> and the onclick images to .net clickable images (all .net objects no framework). This works because the state is remembered within each postback. However, the problem I'm having is I can't dynamically bind ID's for panel since this is not allowed. HOW CAN I GIVE THE PANEL <% Bind("id") %>. THAT I CAN REFER TO SO I CAN OPEN THE APPROPRIATE PANEL.
Can we get a reference to a boundfield column value which has been made invisible ina dynamically created and databound gridview. I am able to get a reference to a
button field which is added to the grid dynamically like this:LinkButton _singleClickButton = (LinkButton)e.Row.Cells[5].Controls[0];
(the button field is the 5th column in the gridview and it is made invisible through visibility property)
I have a gridview that is populating from a SQL DB and working fine. However, based upon certain data I find in fields in the SQL table, I want to place a 'n' or a 'y' in extra columns in the gridview that I am assuming need to be templatefields. My thought was I could maybe add 8 template columns and then I could put a 'y' in the appropriate column based upon the data I find the table. For the life of me, I cannot figure out how to do this. I want to do this at rowdatabound time ( i think) but I just cannot find out how to, in my code, put that 'y' in the columns. Is this the right way to do this or do I need to do it another way? How do I get that 'y' in the proper column?
View 3 Repliesmy problem is that i have a gridview that fetch the data from database .I added the linkbutton on gridview that redirect to next page but cant working becouse at run time i add a bound field on gridview to calculate the time. source code
<asp:GridView ID="GridView3" runat="server" AllowPaging="True"
AutoGenerateColumns="False" CellPadding="4" Width="928px" Height="321px" OnPageIndexChanging="GridView3_PageIndexChanging" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" style="z-index: 102; left: 24px; position: absolute;
top: 248px" >
<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<%--<asp:RadioButton ID="RadioButton1" onclick="javascript:CheckOtherIsCheckedByGVIDs(this);" runat="server" AutoPostBack="true" OnCheckedChanged="RadioButton1_CheckedChanged" />--%>
<asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Select"
OnClick="LinkButton3_Click" Text="Update"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="id" HeaderText="Ticket Id" SortExpression="id" />
<asp:BoundField DataField="fname" HeaderText="Name" SortExpression="fname" />
<asp:BoundField DataField="phone" HeaderText="Phone No." SortExpression="phone" />
<asp:BoundField DataField="comname" HeaderText="Company Name" SortExpression="comname" />
<asp:BoundField DataField="sub" HeaderText="Subject" SortExpression="sub" />
<asp:BoundField DataField="mess" HeaderText="Message" SortExpression="mess" />
<asp:BoundField DataField="email" HeaderText="Email" SortExpression="email" />
<asp:BoundField DataField="status" HeaderText="Status" SortExpression="status" />
<asp:BoundField DataField="Dept" HeaderText="Dept" SortExpression="Dept" />
<asp:BoundField DataField="Prior" HeaderText="Priority" SortExpression="Priority" />
<asp:BoundField DataField="time" HeaderText="Time" SortExpression="Time" />
<-- <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />--%>
<asp:TemplateField HeaderText="Detail">
<ItemTemplate>
<a href=# " onclick="return jsPop('Detail.aspx?id=<%#DataBinder.Eval (Container.DataItem,"id")%>', 'win01', 800, 500);">
view detail</a>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
<RowStyle BackColor="White" ForeColor="#330099" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
</asp:GridView>
I have a DetailsView which has two fields - one that is visible, one that is not. The first the user fills out, the second I want to auto-populate. Unfortunately, I haven't been able to find a way to set the value in this second invisible field. I've tried adding code like this to the Page_Load:
If Not IsPostBack Then
DetailsView1.DefaultMode = DetailsViewMode.Insert
Dim txt1 As TextBox = DirectCast(DetailsView1.FindControl("Type"), TextBox)
txt1.Text = "administrator"
End If
But this returns an error of "Object reference not set to an instance of an object." how to accomplish this - either using the method above or another method? The hoped for end result is that when a new record is inserted via the DetailsView that this record will include the username (entered by the user) as well as the "type" of "administrator"
For example, let's say I have a HyperLink:
<asp:HyperLink runat="server" Text="Foo" NavigateUrl="foo.aspx" />
How can I set the NavigateUrl on the server side, without having to go the code-behind?
This doesn't work of course:
<asp:HyperLink runat="server" Text="Foo" NavigateUrl="<%= urlString %>" />
(where urlString might be a string I created earlier in the page)And this doesn't work because the HyperLink is not within a data bound control:
<asp:HyperLink runat="server" Text="Foo" NavigateUrl='<%# urlString %>' />
I guess I could just use a standard anchor element:
<a href="<%= urlString %>">Foo</a>
But I'd rather not mix up HTML and ASP.NET controls, and it would be handy to be able to do this for other controls.
I am using TempleteFields for all columns in my GridView. In that columns I am using only some fields for customization but not all.
Is there any performance issue with Databound Fields vs Templete Fields in a GridView...?
Do I need to replace the remaining columns with Databound Columns instead of TempletField columns...?
I have a menus in master page.I took treeview to display the menus.But i want to make visible and invisible of some main menus according to my requirement . when i login into the page form.aspx menus will appear. But when i click the submit button then those menus will disappear and some more new menus will appear.
View 3 RepliesI am using the DetailsView Control to read a LastUpdatedDate field (which can be null until an update is performed) from the database. The LastUpdatedDate is of type DateTime saved in UTC. With the DetailsView control, I can use the NullDisplayText property of the boundfield to safely display an custom message. However, once converted to a template field, that property is lost. Now, how would I display that message if the field is null as I am also formatting the date for display to show in local time.
[Code]....
Is it possible to make some of the AccordionPanes disabled dynamically from server side ? So that the header not clickable and the accordion content is not visible?
View 2 RepliesI m getting 9 columns from database in a dataset but I want to diplay only 4 columns in datagrid. Remaining 5 columns values, I want to display in the textboxes below datagird.
I tried it making column invisible. If I make it invisible, I m not getting any value for that column to display in the textbox.
let me explain completly. I designed an gridview, header template i added one textbox and button if the user enter something on Txtbox and click button then based on input i show corresponding rows only, all other rowss will be hidded using Javascript like below
tblOrders.rows[CurrRow].style.display = 'none';
now im doing something on the Gridview_RowCommand event at this time the gridview got refreshed so that the hiden rows are visible, but i dont want to show the hidden(invisible) rows while rowcommand event fired.
I have a gridview that is being populated off of a query that has joins in it. It works fine. However, I want to display one record of all information but then blank out all colunmns accept 1 for the other 3 records that it is picking up. In other words, right now, all three records have duplicate info in them accept this one column. can this be done? Can I somehow blank out other columns based upon what is in the single column? This is all being done in a gridview. I realize it would do a master detail type scenario but I want all of this information to display without someone having to click on a field or anything.
View 4 RepliesI've run into this before, but I was using a formsview and just changed the field to hidden. I am trying to get the value of a cell out of a gridview to a variable and here is the code:
[Code]....
This works perfectly if column 6 is visible, but because it's an id number (which is not the primary key) I do not want it visible, but changing it to visible="false" causes this code to return null. Changing it back to visible and it works.
I'm not sure why the visiblity of a control changes the functionality of it.
I bound the gridview having some fields(ID, StudName, City) Â and Display Button. When I click on the Disply button I approve the student and updation will happen.Â
Bu what happen the column ID is not in the sequence. Sometime it displays 1,2,3,4,5,6 ... Â next time it will display 7,8,9,10,11.... I want a sequence for the column ID. For that I used :Â
<%# Container.DataItemIndex+1 %>
and it is working fine.. But again I realize that these numbers are generating at runtime and i can't refer to that student. Also I don't want to display ID column on the grid view but I want to use on runtime generated column. [ i am using RowCommand for ID column ] How it is possible?Â
regarding gridview Template column.in my template column i have a textbox and i need to invisible to user. but when i set visible property "false" then textbox value is not render.
[Code]....
I have a Gridview with some template columns. Inside one of the columns, I have a ImageButton with a serverSide OnClick handler to show or hide a panel. And all the panels by default are hidden. What happens is that when I click the imageButton the first time the panel gets displayed, but if I click the same button, on the same row again, - where the panel is now visible - the panel doesn't hide itself. Here's what happens when the imageButton is clicked:
protected
void ImageButton1_Click(object sender,
ImageClickEventArgs e)
{
ImageButton imgBt = (ImageButton)sender;
Panel compRecDetails = (Panel)imgBt.NamingContainer.FindControl("CompanyRecDetailsPanel");
if (compRecDetails.Visible ==
false)
compRecDetails = true;
else
if (compRecDetails.Visible ==
true)...............................
Once again i am faced with an issue. I must allow a user to add as many pieces of data as they wish. I have therefore employed some javascript from an tutorial
[URL]
I would now like to return the data from the dynamic fields through the c#(.cs page)
I have created DetailsView in designer page with SqlDataSource, Details view is with autoGenerateRows="false" i.e. I have declared my own fields. it is fine there, but what if I want to add these fields dynamically from codebehind with select & edit commands. I want to to use Details View in designer page and want to add fields from codebehind
View 1 Replies