Forms Data Controls :: Change One Section Code From DataGrid To GridView?

Aug 2, 2010

I'm trying to change one section in code from DataGrid format to GridView format. The reasoning is that the sample application that was displayed was using a DataGrid even though it should have been using a Gridview for 2.0 and above. Most of it shows up without an error except one line in 3 lines which are pretty much the same. I bolded them and just want to know how do I re-write them for the Gridview?

Protected Sub NewsGrid_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles NewsGrid.RowCommand
Dim connection As SqlConnection = CreateConnection()
If e.CommandName = "Delete" Then
Dim com As New SqlCommand("DELETE FROM ElectPageEditor WHERE NewsID = @NewsID", connection)
com.Parameters.AddWithValue("@NewsID", e.Item.Cells(0).Text)
Try
connection.Open()
com.ExecuteNonQuery()
Catch generatedExceptionName As SqlException
Finally
connection.Close()
End Try
ElseIf e.CommandName = "Edit" Then
Dim command As New SqlCommand("SELECT NewsText FROM ElectPageEditor WHERE NewsID = @NewsID", connection)
command.Parameters.AddWithValue("@NewsID", e.Row.Cells(0).Text)
Try
connection.Open()
Dim record As SqlDataReader = command.ExecuteReader(CommandBehavior.CloseConnection)
If record.Read() Then
NewsEditor.Content = record.GetString(0)
EditedNews.Value = e.Item.Cells(0).Text
lse
NewsEditor.Content = ""
EditedNews.Value = ""
End If
' Will close the connection as well
record.Close()
Catch generatedExceptionName As SqlException
Finally
connection.Close()
End Try
End If
' Add code to delete row from data source.
ReadAllRecords()
End Sub

View 4 Replies


Similar Messages:

Forms Data Controls :: How To Change HeaderText In GridView From Code Behind

May 4, 2010

I am using Templates in GridView, but now I have to change the "HeaderText" of each column from code behind. I don't have <HeaderTemplate> so therefore I cannot use FndControl() in header row.

Is there a way to change the HeaderText of each colum without using <HeaderTemplate>

Here are the templates of the GridView which I am using

[Code]....

View 3 Replies

Forms Data Controls :: Gridview Change Text Of Column In Code Behind?

Jan 19, 2011

I want to display the value to different text in particular column.

I want to change Status column text.

The column will be shown three char values; O, P, C

However, I want to display three of status; On Order, Partly, Complete

I am trying to use code behind, but still I am finding solution.

Code behind:

[code]....

View 13 Replies

Forms Data Controls :: Change DataField Of The BoundField In Code Behind (GridView)?

Mar 20, 2011

I 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.

View 3 Replies

Forms Data Controls :: Gridview Columns Change After New Sqldatasource Changed In Code?

Feb 14, 2010

I have a gridview that loads with a new datasource on button click event. On the gridview (which is located in a table columm incidentally) are 2 columns, a descriptor and a checkbox. The problem is that after postback, the column widths change, the checkbox column expands and the other column contracts. Is there a way to keep the gridview column sizes the same after postback?

View 2 Replies

Forms Data Controls :: Change FOucs To Div Inside Datagrid

Feb 5, 2010

I have a Panel inside a datagrid which has some lables. my panel is hidden when page loads. my panel is displayed when some selection is made all this is done on client side using JS i want to change the foucs to my panel when the panel shows up (using JS) but looks like i cannot chane my foucs to a div so i added a anchor inside the panel. and tried to find that anchor and set foucs to that anchor.

View 1 Replies

Forms Data Controls :: Gridview Header Section Jump To Top Of Page?

Jun 2, 2010

I have gridview with div tag, i have put div tag becouse when user scroll in grid i dont want move grid header section. Its remaining ther and only move data section. Its working fine.

But my datagrid has facility to master details hiearchy of data, When user click one of button its expand details record of that particular parent item.

When user click expand button my gridview header section jump to top of page. How can i stop it

<div id="dvItems" style="height:300px; width:955px;">

View 3 Replies

Forms Data Controls :: Add Associated Control Id For Gridview Fotter Template Under Section 508?

Mar 15, 2011

I have gridview template field with 5 columns like First Name, Middle Name, P.No and Last Name. The grid has a list of people with a blank row at the bottom of the grid (in the footer) that allows the user to add a newperson to the list. I have added textbox under fotter template. i need to add associated control id for footer template text box.I have been asked to make the grid section 508 compliant. The requirement is that the column headers must have labels that referencethe text boxes in the footer row. On a normal web form it would look like this:

<label for="txtFirstName">First Name</label>
<asp:textbox id="txtFirstName" runat="server" />

This allows a text reader to figure out that the words "First Name" are associated with the text box "txtFirstName" and helps a blind personunderstand how to fill out the form.Now, back to my problem. I need to figure out a way to get the header of a Grid view template column to work the same way. The biggest problem is that I have no idea what the ClientID of the textbox will be.

View 1 Replies

Forms Data Controls :: Gridview Server - Column Data In The Details Section Does Not Line Up

Jan 5, 2010

I had problems with using the gridview. For example I can bind or a a row of data to the gidview but the column data in the details section does not line up appropriately as far as justification with the grid view headers. I have tried different alignment combinations but that does not work.

View 1 Replies

Forms Data Controls :: DataGrid Freeze Header Code Not Working?

Feb 14, 2010

I have searched numerous articles for how to accomplish freezing the Header Row of a DataGrid or GridView component being to simply hide the header and then build table cells just above the component to define the columns. But the one that I'd like to get to work is by the use of CSS code. Problem is that this code seems to work for everyone else but it isn't working for me. Here's my Stylesheet code:

[Code]....

When I run my page I get all the styles applied but the header scrolls with all the other rows in the grid.

why this code is probably not working? I am using .NET Framework 3.5 and developing in VSS 2008 which may be why this doesn't work?

I have successfully downloaded sample code from Code Project which works using other techniques as well, but the code was written in .NET 1.1 Framework and VB.NET.

View 2 Replies

Forms Data Controls :: Datagrid Cell Editing - Code Is Not Properly Working?

Apr 9, 2010

How to do the datagrid cell editing? My need is "I want to update the datagrid cell values individually". At that time of editing, i want to pick the values from dropdownlist, calendar,etc.. controls.I tried a code, but its not working properly. I always taking the cell value only, not the control value. H

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="TestGrid.aspx.vb" Inherits="TestLeadManager.TestGrid" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" > [code]....

View 3 Replies

Forms Data Controls :: Using Code To Convert Items In A Datagrid Row From UPPERCASE To Title Case?

Nov 11, 2010

I'm using code to convert items in a Datagrid row from UPPERCASE to Title Case. It works good, but the problem is if it comes across a hyperlink field, it will put in a blank value. Not sure why its doing this, but here is the code below. Wondered if any one has came across this problem and managed to solve it?


The code:

aspx page:

<asp:GridView ID="SectionsGridLevel1" AutoGenerateColumns="False" onrowdatabound="SectionsGridLevel1_RowDataBound" emptydatatext="No data available." runat="server">
<Columns>
<asp:hyperlinkfield headertext="Section - click to view sub-sections" datatextfield="SectName" datanavigateurlformatstring="BrowseSections2.aspx?type=sect&list=1&level=2&section={0}" datanavigateurlfields="SectID" />
<asp:hyperlinkfield headertext="View" Text="View All" datanavigateurlformatstring="BrowseSections2.aspx?list=1&section={0}" datanavigateurlfields="SectID" />

[Code]....

View 3 Replies

Data Controls :: Add Items In DataGrid In Text Change Event?

Nov 13, 2013

I am dynamically bind the textbox in the data grid and in the text box change event i need to add the numbers in all the text box and show in the separate label.

I am using the text box change event and post back to true, I can able to calculate the result but the problem is that on text change itself i need to calculate and show the result, but in my case, when i move the focus from the that text box, the results calculated and focus get lost.

View 1 Replies

Forms Data Controls :: Failed To Load Viewstate When Gridview Control - Replace Gridview With Datagrid

Apr 5, 2010

Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.

The above error occurs with gridview control , when used with template field columns with item template / and edit templates etc.
updating a row within gridview, at the time of loadiong it loads perfectly fined, but when tried to modify an existing row within gridview control, then it produces the error. Make sure the grid view control has to be a child control which manages the child table info with in a master form. to reproduce the above problem the grid view must be loading the child records info of a master within the masterform, meaning both master data and gridview data all to be managed in one single form.

I had to replace gridview control with datagrid and then it worked perfectly fine. I wasted almost 4 days of my time., there is no way we could figure out the problem. here is the full info of the problem.

Server Error in '/' Application.

Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.

Source Error:

[Code]....

Stack Trace:

[HttpException (0x80004005): Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.] System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +306 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Page.LoadAllState() +312 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1661

Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082

View 2 Replies

Forms Data Controls :: How To Change The Values In Gridview On Text Change Of Templated Control Without Databind Again

Apr 20, 2010

How to change the values in gridview on text change of templated control without databind again?the value of templated text boxes should change If i change the value of one of the templated textbox then accordingly(By mathematical calculations) the vlaues of all tempated textboxes should also change.

View 7 Replies

Forms Data Controls :: Test Mode Change In Gridview / Stating can't Change String To Decimal?

Sep 14, 2010

When i run the following code i get an error when gridview changes mode to Edit. stating that you can't change string to decimal!

To get around the occurance i want to disable code when in Edit mode or resolve another way?

GridView1_RowDataBound
For Each row As GridViewRow In GridView1.Rows
Dim cell As TableCell = row.Cells(7)
Dim invoicetotal As Decimal = CDec(cell.Text)

View 2 Replies

Forms Data Controls :: Gridview Change One Field And Cause Change In Another?

Mar 7, 2011

I have a gridview in which I have several editable fields. The user wants a non-editable field to be modified if another field is modified in the same row. e.g. if Age>=65, Status should ="Retired"

I am using the following demo: [URL]

to create a bulk edit gridview so some columns are automatically editable and others aren't, with a single update button. I can set Status="Retired" in the xml generated, or as a rule in database table. But I'd like the status field in the gridview to change when Age is modified and to be shown to user before they press the single Update button. I'm using update panels and ajax on the page also.

View 1 Replies

Forms Data Controls :: Convert From DataGrid And GridView?

Jun 30, 2010

Does any one know the way to convert the following from DataGrid to GridView?

[Code]....

View 1 Replies

Forms Data Controls :: On Fly Programatic Datagrid / Gridview In VB

May 12, 2010

I have a interesting problem and being relatively new to .NET I thought to try the forum for some guidance. I need to present information from a database, typical, but I need to create stand alone views of the data based on the "category" for the reported information. I don't know how many or how few categories I might need to generate but each needs to be displayed in its own datagrid or gridview. I did a prototype report where I could dynamically generate a variable number of columns in a generic datagrid already placed on the page based on the database but the user "changed their minds", also typical, and want a different view (actually views). Does anyone have any thoughts on creating anywhere from 1 to a dozen (or more) datagrids in the code behind and then pushing them out to the aspx page for the user? Can you dynamically generate datagrids and gridviews on the fly? Or would you need to?

View 3 Replies

Forms Data Controls :: Should Use Datagrid, Gridview Or Datalist?

Dec 23, 2010

I am going to have a page that list an (image, description, category) this needs to be an editable list (the user should be able to edit description or select a cateogry from a dropdown or delete the whole image). lets say I need to display 20 rows per page.here are my questions:1) should I use datagrid, gridview or datalist?2) would PagingBulletedList works well with any of the above control3) when I go to the database to get the rows , since i am going to have 20 items per page should I just bind the control with all the rows or should I just display the first 20 items and when the user click page 2 i go to the database to bring the second set of 20 items?

View 2 Replies

Forms Data Controls :: How To Filter Child Datagrid On Parent Datagrid Row Select

Apr 6, 2010

I have 2 grids gvParent & gvChild I would like to filter gvChild when a row is selected in gvParent the linking fields are contractNo

I added a column for selecting:

<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
OnClick="LinkButton1_Click" Text="Select"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>

I know how to handle the filtering of the grid (create a criteria and set to rowfilter of the dataview) But, I dont know how to get the value of the column of the selected row.

View 5 Replies

Forms Data Controls :: Sort The Datagrid (gridview) Programmatically

Dec 7, 2010

i want to sort the datagrid(gridview) programatically.

View 4 Replies

Forms Data Controls :: Save Batch Of Changes From DataGrid Or GridView

Jan 29, 2010

I have a set of data that has been displayed as just a simple GridView with the item name being a hyperlink to view details. I'm attempting to update this scenario so certain fields (sortOrder and isApproved) are editable from the main page and do not require visiting each item in the grid. I have converted the GridView to a DataGrid and have included a TemplateColumn for the columns in question. I have them hooked up to display the values appropriately. At this point, I'm trying to find a way to peek into the DataGrid and it's related data source to determine if the values have changed on the click event of a button. At that point, I could persist those changes back to the respective SharePoint list.

I'm not very familiar with the DataGrid, or GridView for that matter. Can anyone point me in the correct direction on how I could gain access to the data source at an item/row level during a button click event where the button exists outside the context of the DataGrid?

View 1 Replies

Forms Data Controls :: To PIN The Header Part Of DataGrid Or GridView?

Jan 29, 2011

I want to PIN the header part of my DataGrid or GridView? How is it possible? Ex: Suppose we have 100 rows in data grid, and 1 row with header. If you scroll data grid, header row shouldn't scroll. It should be fixed or PINNED. Only rows with data should scroll. Is there any in built function in data grid to achieve this functionality or any other methods to do this?

View 1 Replies

Forms Data Controls :: Want To Capture - Datagrid On Clcik On Datagrid Row Value Using C#?

Mar 4, 2011

I have Datagrid , i want to clcik on row and get data in textbox , but my textbox is FreeTextBox control,i tried to use javascript but work for asp.net control not working for freetext box control, how i can capture this code is sample code but it work for asp.net control but not working for my freetextbox

[Code]....

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved