I was wondering what would be the best pratice to databind a gridview programmatically.Normally i put my databind code in the page_load() but is there a way to reduce the number of times the databind method is called?I mean... the page_load() method seem to be called a lots of times when doing callbacks with the grid.
View 5 Repliessomewhere on the net I found very useful example of programatically databainding the treeview control (code blow). I use this treeview as menu bar in my masterpage. It works fine but with one exception: when I click the node of this treeview I'm redirected to the correct page but after page is reloaded my treeview is collapsed and node I chose just before is not highlighted. What to do to correct this problem. Do you know better examples of programatically databainding of the treeview control? Maybe it will be better to bind data to the sitemapdatasource and next to the treeview. Then I shouldn't have to worried about this?
[Code]....
Regards. Pawel
I'm trying to extend the GridView control to enable sorting and paging for any situation.
When using my control I am fetching data from a database and filling a DataSet with it, then binding the GridView upon every page load. My first question would be, is this the correct approach?
To sort the GridView I am overriding the OnSorting method which stores the sort expression and direction in the ViewState, then creates a DataView and utalises the Sort method to sort the underlying data. It then sets the Data Source to this DataView and rebinds the GridView.
Paging is handled by OnPageIndexChanging which simply sets the PageIndex property and again rebinds the GridView.
My problem is; when any control causes a postback my GridView is no longer sorted, presumably because it is persistently rebound. If I don't rebind it then the GridView is empty on postback since the data isn't automatically stored in the ViewState. I have considered saving the data source in the ViewState but I would assume that this is bad practice for large amounts of data? - also DataViews are not seralisable.
The only solution I can think of currently is to override OnDataBound and sort the data every time. This results in a double sort when paging triggers a postback which seems inefficient. Code illustration of this below,
[Code]....
I'm looking for the cleanest 'best practice' solution as this is a learning exercise more than anything else.
I have a gridview in which I have two drop downs. One is populated with values that are static, so I have a regular sub that does that in the code behind. I tried to add code for databinding the other ddl to a datatable. I cannot get this to work. It just comes up empty. My asp code is fine, and the datatable definately has data in it - just nothing gets populated.
One other thing - the code for the static ddl has worked fine, but when I add this other block (either to the same sub as that, or dow the rowdatabound event) the static one doesn't work either.
[Code]....
I have a GV & a FV both linked to same sqldatasource.
When a GV row is clicked, the FV becomes available for editing the row but the GV as a result is reduced to only that row. I want to GV to remain showing all rows. I am using GV selected_index event to invoke "SqlDataSource1.SelectCommand=
I am having issues with databinding a textbox within a tab within a gridview. The textbox displays the data information properly; however when I try to edit a row in my gridview anything I type within that textbox is not saved in the database. Also my other fields for my gridview are editable, I am only having issues with this textbox within a tab. Here is the code:
[Code]....
I am trying to create a Gridview in which I can update the Project Officer name in the Gridview from a DropDownList.
The Project Officer DDL comes from a seperate query (SqlProjectOfficerName) as the other information (SqlDataSource1)... as you can see below.
When I select EDIT, the DDL appears and I can select from the list of Project Officers, but when I select UPDATE, the name of the Project Officer doesnot change.
review the code below and assist as appropriate to write the Project Officer's name back to the table.
[Code]....
On every row in my datagrid, i need to set a control to visible/invisible depending on how many entries are shown in the grid.
If total rows are > 1, the control needs to be visible on every row. If rows = 1, it needs to be invisible.
BUT, how do i do this? If i just check my GridView.Rows.Count, the first row will (of course) be invisible, while the rest will be visible.
Can i check how many rows are pulled out of my datasource, or do i need to go through each row, setting visible true, AFTER the grid is populated.
im building a simple message messenger web application, i currently have a column in my database dedicated to the status of a message. Its bound to the third column in a datagrid.
After converting the column to a TemplateField and using a Label to fetch the data how do i change the text from the database to a small message, e.g. if the data in the database (as an interger) is 0. how do i change the interger to a string to display "UnRead". Do i need to do this during the databinding call or after the grid has been databound?
I know it would be easier to use a boolean and checkbox control but the interger column represents more values than true or false.
I have a gridview which I have databinded via the quick config facility, but I need to databind one column to a completely different sql table data field - how do I do this?
If I go into Gridview tasks and select the column and edit the data binding parameter but what is the format for a table outside the source definition for the the rest of the gridview?
I have tested and tried to fix this until I am blue in the face and can not figure it out...
[Code]....
The SQL works fine if I just query in SQL - I only get the error when I try to get anything from the SalesPerson table and display it in my gridview.
I have manually databinded my gridview , but problem is it won't show 2nd page index .... here's a chunk of code :
<asp:CheckBox ID="SARecords" OnCheckedChanged="SARecords_OnCheckedChanged" AutoPostBack="True" CssClass="tooltips" data-original-title="View all mapped phases." data-rel="tooltip" data-placement="top" runat="server"></asp:CheckBox>
<asp:UpdatePanel ID="ExistingMappedUpdatePanel" UpdateMode="Conditional" runat="server">
[CODE]....
I have problems building a GridView programmatically. My code is:
[Code]....
This displays the GridView with the following problems:
1. The Html constructed in the Subject column displays on the page as raw Html. The source code shows the Html characters in their ASCII form. The function HTMLEncodeSpecialCharacters is obviously incorrect.
2. The PagerSettings display the page numbers only (1 2 3 4) and not the First and Last text (want to display << 1 2 3 4 >>) despite setting PagerSettings.Mode = PagerButtons.NumericFirstLast.
3. Clicking the page numbers is always one page behind. For example, when the page is opened, page 1 displays. If I click 2, page 1 still displays. Then click 3, page 2 now displays. Click page 4, 3 displays. Click 2, 4 displays etc etc.
4. The column headings are aligned in the centre despite setting HeaderStyle.HorizontalAlign = HorizontalAlign.Left.
I have a GridView which pulls info from a SQL DB. It works fine. I use a CMS to upload the data which includes thenumber referred to below.
The last (rightmost) column in the GridView is a number.
I'd like to know how to know how to:
1) Make a further column visible (to the right of the number) which contains a Button BUT only when the user is logged in.
2) Make that Button call a function (the workings of the function are irrelevant here) and pass to that function the number in the previous column.
I know I could use a LoginView with two GridViews, one for logged in (showing the Button) and one for anonymous (without the Button), but then I'd have to put the Button in the database... I think.
A better idea would be to add the Button column programmatically.
how this can be done and how the Button in each row, when clicked, can pass whatever number is to its left as a parameter?
i have this code for making gridview datasource :
[Code]....
how i can add checkBox in gridview instead of (alpha or beta ) at tbl.row.add for is_active ?when is_active is true then checkbox.checked = true and else if is_active is false then checkbox.checked = false ??
Few Issues with below xml:
<?xml version="1.0" encoding="utf-8"?>
<Results>
<Products xmlns="">[code]....
1) How to bind this xml Using DOM Model to GridView from serverside? I don't want to pull xmldatasource and gridview with columns on FRONT end(aspx).
2) How to dynamically bind the nodes DesignDate, SoldDate....as columns to Gridview, coz there can be many columns with different column names and I don't to specify by saying: HeaderText="DesignDate". I would like to generate this dynamically from serverside.provided with a code to make this working.
How can I programatically call a gridview row when it is loaded based on the primary key. For example, say I have a record in the gridview where the column name is ID (Identity Field) and has the number 37 in it. When the gridview loads up, I need to get the rowindex where the primary key = 37 and have that row automatically selected.
View 5 RepliesI have already google the question, but couldn't found any relevant post.1) I want to make gridview's one column () editable according to some boolean value (flag). If flag is true when the edit is clicked, related column would be editable (text field), otherwise related column would be label.2) Same again, I want to make enable delete button in some rows and not some rows according to that flag.
View 1 RepliesI have to add row in gridview dynamically when a button is clicked on my page
Each Row which have to be added contains a dropdownlist(ddlQues) in which questions are binded
On selecting question from ddlQuestion I have to bind another dropdownlist(ddlAnswers)with respective
answers in that row of gridview
So autopostback property of ddlQuestion is set to be true
Everytime when button is clicked a new row is inserted in gridview and same process repeats............
I had tried following javascript:
<script type="text/javascript">
function AddNewRecord()
{
var grd = document.getElementById('<%= gvResponse.ClientID %>');
alert(grd);
var tbod=grd.rows[0].parentNode;
var newRow=grd.rows[grd.rows.length - 1].cloneNode(true);
tbod.appendChild(newRow);
return false;
}
</script>
and calling this function on button
<asp:Button ID="btnResponse" runat="server" Text=" New Response" CssClass="button3" OnClientClick="return AddNewRecord();" />
Also I tried to solve it by C#
By both ways(either by javascript or by C#)New Row is added in gridview
But when I select question from ddlquestion then page is loaded and and the inserted row in gridview disappears
I am using asp.net 2.0 with C#
i want to create a gridview programatically and add the data programatically.
View 1 RepliesAfter binding a gridview to a datareader - Im trying to set the width of the first column by using :
[Code]....
this is giving me an error : Index was out of range. Must be non-negative and less than the size of the collection.
I've programatically created a DataView item by adding columns and rows to a table in the class file. Then I add that to my webform using a GridView. I'd like to hide some of the columns so that the end user doesn't see them but still be able to access their values.
How do I do this programatically? The table.Columns.Count returns the actually number of columns. Somehow when it converts into a DataView, it is only returning 1 column.
//From class file
[Code]....
//From webform
[Code]....
In this example, I want to hide the ID column.
I have a gridview with bound fields and a templateField that receives data from a submit button which, depending upon the selected object, i.e. dropdown 1, 2, or 3, return a result set. The gridview also has a checkbox column which is used as a marker to determinie the rows to be added to and existing table. If a user selects multiple row, those rows are written to the database. Everything works.
Now, I need to add additional functionality to the gridview:
Upon selecting the checkbox, programmatically the accompanying row must become editable; for each row presented.
Deselected the checkbox, return the gridview row to a read-only state.
There are 14 columns, one of which is a dropdown which needs to maintain its default value.
I want to hide the select button in my grid view programmaticlly in the form startup. how to do this?
View 7 RepliesIn my table I have 3 fields:
[inFrmDate] (this is the key field), [inFrmData], [totFrmData] (this accepts nulls)When I try to add [inFrmDate], [inFrmData] to the GridView I get the messageto the effect that the:
@inFrmDate scalar is not declared.
But as you can see from below it is declared:
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
[code]....