basically I had a repeater that i needed to be able to now update row by row. I thought the easiest way would be to replace with a datagrid.
Here is the code:
Code:
[code]....
If I take away the select filtering, I then get this error on rowdatabound
Unable to cast object of type 'System.Data.DataRowView' to type 'System.Data.DataRow'.
how to join two datatable datas into one datatable to show in one gridview
i.e in 1 datatable i have username and pwd and in another datatable i have that user details. how to show all these in one datatable to get those values display in gridview(asp.net)
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 need to perform some string manipulation to a columns contents in a GridView, and I'm using the DataBinding event for the template field for this. I'm converting all Environment.NewLine's to 's for outputting.
Here is the code:
[Code]....
It writes the correct, newly modified, string at the top - but why isn't it feeding back to the grid view?
I am databinding a SqlDatasource to a GridView in 2 different ways.
1) Declaring the SqlDatasource in the .aspx page and setting the DatasourceID property on the GridView to its id
2) Creating the SqlDatasource in the code behind and binding to the datasource property
When I use the declarative method (1), sorting works fine without any extra work on my part, but If I create the SqlDatasource in the code behind and try to sort, I get an exception saying 'The GridView 'myGridView' fired event Sorting which wasn't handled'.
I assume that there is some sort of extra plumbing that occurs when using the first method. Does anyone know what the datasourceid method does that the programmatic one doesn't? I would like to duplicate the logic in the code behind if possible.
I created a GridView in code with a DataTable as its data source which worked fine. I have now moved the GridView creation into a .ascx file to make it easier to format.
For some reason this has started triggering the HttpParseException:
Databinding expressions are only
supported on objects that have a
DataBinding event.
System.Web.UI.WebControls.HyperLinkField
Original code:
// Set up columns for datagrid
var boundField = new HyperLinkField
[code]...
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=
how can I display a linq query in a gridview that has data from multiple tables AND allow the user to edit some of the fields or delete the data from a single table?
I'd like to do this with either a linqdatasource or a linq query. I'm aware I can set the e.Result to the query on the selecting event. I've also been able to build a custom databound control for displaying the linq relations (parent.child).
However, I'm not sure how I can make this work with delete? I'm thinking I may need to handle the delete event with custom code.
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 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 RepliesI have a gridview databound to an objectdatasource. Everything worked great until I changed 2 columns from asp:BoundField to asp:TemplateField. These are the UPC column and the Part column. I wanted to show a link button for each of these fields that take the user to another page. Now asp.net expects these two fields to be parameters on the update store procedure. Why is this? How do I get it to not assume these columns need to be passed to the store procedure?
Here is the code for the grid view:
[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]....
I have a gridview which I load with data on click of a button. For some reason the paging did not work. The paging number shows up but clicking on page # 2, 3 or 4 does not take you anywhere. the grid just disappears on clicking them. right after that when i click the button to generate the grid, the grid came up this time the gird is on page 2 or 3 instead of 1.
I have the following on page_indexing properly.
Protected Sub GV_Document_Hide_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GV_PSIDocument_Hide.PageIndexChanging
GV_Document_Hide.PageIndex = e.NewPageIndex
End Sub
I even tried by adding the databind() code inside the pageindexchanging as suggested in other threads but that didn't make any difference.
The only way I could get this going was by populating/loading the grid on page_load. I have to assign datasource & databind it every time irrespective of even postbacks. I tried IsNotpostback then the paging failed again Why does gridview needs loading on page_load every time if the paging needs to work properly?
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.
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]....
'DataTable' is an ambiguous reference between 'System.Data.DataTable' and 'Microsoft.Office.Interop.Word.DataTable'
View 3 RepliesI 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've coded a GridView in the markup in a page. I have coded a DataTable in the code-behind that takes data from a collection of custom objects. I then bind that DataTable to the GridView. (Specific problem mentioned a couple code-snippets below.)
GridView Markup:
<asp:GridView ID="gvCart" runat="server" CssClass="pList" AutoGenerateColumns="false" DataKeyNames="ProductID">
<Columns>
[code]....
Goal: I'm basically trying to find a way to update the data in my GridView (and more importantly my cart Session object) without having to do everything else I've seen online such as utilizing OnRowUpdate, etc. Could someone please tell me why gvCart.Rows is empty and/or how I could accomplish my goal without utilizing OnRowUpdate, etc.? When I execute this code, the GridView gets populated but for some reason I can't access any of its rows in the code-behind.
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?
how to get datatable from gridview?
somthing like this:
DataTable dt = gridview1.DataSource as DataTable;
I don't want to save data in session before grid binding.
First off, im using a checkbox to highlight a true or false value from a dataset which I want to be able to change it. Unfortunately databinding the DataTable to the GridView checkboxes doesnt work (as you probably know) as it requires it to be in "edit" mode.
The way I've gotten round this is having the checkbox reading the data table value seperately rather than being databound and locked:
Checked='<%# Convert.ToBoolean(Eval("myValue")) %>'
So that solves checkbox values from DataTable -> GridView, now I need to do the opposite having the changed checkbox values go from GridView -> DataTable as it is not ready to submit it to my data source (SQL) just yet.
I figure I need to run a loop through the GridView rows, thats a give'un, what I can't figure out is how to replace/update just a single value in a row of a DataTable , only the ability to add or remove an entire row by the looks of things (something I don't want to do).
So can anyone offer a workaround?
Or is there a way to have a databound but always editable checkbox in a gridview?
I have a set of productIDs in a DataTable.
I would like to display the relevant data about the specific productIDs in the DataTable in a DataList with the Product data being drawn another Database called Products.
How do I do this?
And how do I write the select statement in VB.net in the SqlDataSource of the Gridview?
I thought of a SELECT .. WHERE .. IN?
I was reading: [URL]
But I have give a compilation error:
CS0246: The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?