I currently use this code to get the ID of the selected data on the grid view
vb Code:
Dim ID As Integer = (GridView1.DataKeys(row.RowIndex).Value)
Now i would like to get the data that is on the 7th column, it's a text, how can i do that?
I have the gridview inside another gridview, i want to sort that both gridviews, I don't know how to achieve using asp.net 3.5 visual studio 2008 c# code behind. Following are my aspx page,
<div
id="divclm"
runat="server">
<asp:GridView
ID="claimgrid"
runat="server"
AutoGenerateColumns="False" AllowSorting="True"
Width="100%"
AllowPaging="True"
CssClass="gareahead"
EmptyDataText="No Records To Display"
OnRowDataBound="claimgrid_RowDataBound"
OnRowCreated="claimgrid_RowCreated"
GridLines="Both"
OnPageIndexChanging="claimgrid_PageIndexChanging"
OnSorting="claimgrid_Sorting"
CaptionAlign="Right">
<Columns>
<asp:HyperLinkField
Text="<img id='upimg' src='Styles/Images/appschg.gif'/>"
ItemStyle-Width="10px">
<ItemStyle
Width="10px"
/>
</asp:HyperLinkField>
<asp:BoundField
DataField="name"
HeaderText="Name"
SortExpression="name">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:BoundField
DataField="code"
HeaderText="Code"
SortExpression="code">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:TemplateField>
<ItemTemplate>
</td></tr>
<tr>
<td
colspan="6"><div
id="<%#Eval("code") %>"
style="display:none;position:relative">
<asp:GridView
ID="Gdclmline1"
runat="server"
AllowPaging="True"
AllowSorting="True"
AutoGenerateColumns="False"
OnSorting="Gdclmline1_Sorting" BorderColor="Green"
BorderStyle="Solid"
BorderWidth="1px"
OnRowDataBound="Gdclmline1_RowDataBound"
OnRowEditing="Gdclmline1_RowEditing" Font-Names="Verdana"
Font-Size="8pt"
Font-Strikeout="False"
OnSelectedIndexChanging="Gdclmline1_SelectedIndexChanging"
OnRowUpdating="Gdclmline1_RowUpdating" PageSize="1000"
RowStyle-Wrap="false"
Width="100%"
CssClass="gareahead"
EmptyDataText="No Records To Display"
GridLines="Both">
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<Columns>
<asp:TemplateField
HeaderText="phone"
SortExpression="phone">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lblphone"
runat="server"
Text='<%#Bind("phone") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField
HeaderText="address1"
SortExpression="address2">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lbladdress1
runat="server"
Text='<%#Bind("address1") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle
CssClass="gr"
Height="100px"
HorizontalAlign="Left"
Wrap="true"/>
<SelectedRowStyle
CssClass="gr"
/> <PagerStyle
CssClass="gareahead"
HorizontalAlign="Left"
Wrap="False"
/> <HeaderStyle
CssClass="ghead"
ForeColor="White"
Wrap="true"
/> </asp:GridView>
</div>
</td>
</tr>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<HeaderStyle
HorizontalAlign="Center"
VerticalAlign="Middle"
CssClass="ghead"
ForeColor="White"
/>
<RowStyle
CssClass="gr"
/>
<SelectedRowStyle
CssClass="gs"
/>
</asp:GridView>
</div>
that aspx page contains gridview that contain one more gridview inside in it.Now i want to sort out both the grid i.e)claimgrid and Gdclmline1 i want code in c#.
I can't figure out how to do this. I have a gridview and I want the user to click on a row and pass some of the cell data to a model popup. For example, if I have a button called Delete on each row and they click the button, I want to popup a box to show the data from that row and ask to confirm to delete. I also need to use the data from that row to delete when they click Yes.
I'm sure I just missed on how to do this from searching. I'm looking for an example on the web.
The data in my dataset looks like the following:
Here is how the data looks in the dataset :
Deal Cashflow Date
-----------------------------------------------
0007 1228888 01/12/2011
0007 898998 02/12/2011
0007 999999 03/12/2011
0008 888888 01/12/2011
0008 777777 02/12/2011
When I transpose the data, it should look like this:
Deal 01/12/2011 02/12/2011 03/12/2011
0007 1228888 898998 999999
0008 888888 777777
I add a 'Command Field' in a data gridview, and i put a code in DataGridView1_RowDeleting and it is working..my problem now is how i can put a confirmation message before deleting a record in a datagrid?
View 1 RepliesWhen the data is retrieved through a stored procedure using the SQLDatasource control that is binded to a gridview control, I want to change some data that is in some of the columns. Can i do this in one of the events either in the gridview or data control? I know you can do some formatting on the aspx page side such as dates, etc. but was wondering if I can do it on the vb code side?
View 8 RepliesI have a gridview control on a .aspx page. It is a bound control. So basically I didn't have to write any code to pull the data from database and show it on the grid.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionStrdatabase %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT * FROM order WHERE SETTLEMENT_DT > AS_OF_DT"
</asp:SqlDataSource>
<asp:GridView ID="GridViewMissingCusipNumbers" runat="server"
AllowPaging="True" AllowSorting="True" SkinID="Professional" Font-Name="Verdana"
Font-Size="10pt" Cellpadding="4"
HeaderStyle-BackColor="#444444"
HeaderStyle-ForeColor="White"
AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" DataKeyNames="BO_SECID"
onrowcommand="GridViewMissingCusipNumbers_RowCommand" Height="285px"
onrowediting="GridViewMissingCusipNumbers_RowEditing"
onrowupdated="GridViewMissingCusipNumbers_RowUpdated"
onrowupdating="GridViewMissingCusipNumbers_RowUpdating" Width="426px"
onrowcancelingedit="GridViewMissingCusipNumbers_RowCancelingEdit">
<Columns>
<asp:BoundField ReadOnly="true" DataField="BO_SECID" HeaderText="BO SECID"
SortExpression="BO_SECID" />
<asp:BoundField DataField="CUSIP" HeaderText="PROXY CUSIP" SortExpression="CUSIP" />
<asp:BoundField DataField="PRICE" HeaderText="PRICE" SortExpression="PRICE" />
<asp:CommandField ShowEditButton="true" />
</Columns>
<HeaderStyle BackColor="#444444" ForeColor="White"></HeaderStyle>
<AlternatingRowStyle BackColor="Silver" BorderColor="Black" />
</asp:GridView>
So far so good. But where is no data is not returned from the database, I want to display something on the page saying "No data returned". But I don't know which gridview control event gets fired so that I can write some code in it to check if the records returned are zero.
I am using the SQLDataSource control and binding it to a gridview. When there are no records returned the gridview header is not showing. I want it to show no matter what is returned. I am not calling a stored procedure - I am writing my own select statement in the SelectCommand. How to show the header with no results? I searched but did not find an answer when using the SQLDataSource.
View 3 RepliesI am trying to create a bound column and bind the data with the below piece of code . And the column has two files Name and Fee but the code binds only the Fees column and Name column become empty..
Code:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
[Code] ....
Design Part
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<style type="text/css">
[Code] ....
this my gridview data with button's i want as soon as i click the button(Button here is not the Button Web Control) i refer button here as Gridview Button(click me/Gridview Button) the corresponding value should populate my textbox's just trying something in asp.
View 8 RepliesI just upgraded one of my solutions from VS 2005 to 2008, and it completed successfully. The only thing that changed in the solution was that I went from .NET 2 to 3.5 framework.
Now when I debug and select a page where a GridView displays a table of 4580 rows the time to display it goes from 5 seconds to 5 minutes. Everything else in the project behaves as normal. Why would performance degrade on one GridView when going to VS 2008?
It's also noteworthy that changing the GridView parameters to AllowPaging="True" PageSize="25" will return performance to under a second response, as one might expect.
I have in my laptop VS 2003, VS 2005 and VS 2008. I am making some SMS application in which I am using some DLL which need asp.net 3.5 so I am making application VS 2008. Now in my application I am using DAL and BLL method where in I am making .xsd file with TableAdapted from that I am making BLL files.
I added Formview in my aspx page configure it with Objectdatasource . IDE was not invoking the wizard for objectdatasource after lot finding. I got from some forum that after removing bin folder from application. It will start working. This was the first problem now I add gridview in my aspx page now and configure with Object data source. But when I go property builder of gridview I cannot see Edit Template, I can see only Empty template and Pager Template. Here my question this is new in VS 2008 as when i was working with VS 2005 I could see all Template. Next thing when change anything through property builder, I can see changes in the design view mode but I cannot see any changes in HTML source view. Again when I switch back to HTML source view to design mode all changes will go away. Why is it so !! For more info I will put my aspx, aspx.vb page code here.
[Code]....
Right now when I bind data to my gridview, I have a column MemberNo that I use in the RowDataBound in another column for creating a link. Anyways, in the DataBound event i hide the MemberNo column. But I also have a routine where I need to loop through the rows and use the MemberNo. Can I unhide the column MemberNo to use for this routine and then hide it again? I assume I cannot use the data if it is hidden right?
View 2 RepliesIm using Visual Studio 2008 and i have created a GridView which displays data from an SQL Table, how could i export this data into an Excel sheet on click of a button.
View 1 Repliesi m having sub-grid/Nested Grid concept using grid view control ., i.e., inside grid in sixth cell i m having another grid.,
i n Sub-Grid i m having The Follwing Events
OnRowDataBound="Gdclmline1_RowDataBound" OnRowEditing="Gdclmline1_RowEditing"
OnSelectedIndexChanging="Gdclmline1_SelectedIndexChanging" OnRowUpdating="Gdclmline1_RowUpdating" ., all the events are working Fine Except OnRowUpdating="Gdclmline1_RowUpdating" this event.,
we are developing the software in Visual Studio 2008 ., our Server is Visual Studio 2010 .,
in my development machine its working fine., but in Server machine its row updating event not working .,
note:- we have used proper conversion method from vs 2008 to vs 2010
Can Visual Studio 2008 Gridview control do grouping? And how?
View 1 RepliesI am using C# and VS 2008 with access database. I have a nested gridview (2) with two access database tables. Date1 (takes System date) is the primary key in table1 and also present in table2 as foreign key. User data is stored in gridview 2 w.r.t to the date in gridview1. What i am tryin to do is to mail todays date (System date) data of Gridview 1 and data corresponding to it in Gridview 2 to a specific mail id.
View 8 RepliesI have been asked to replace DATAGRID with GRIDVIEW on WEBFORM1.ASPX. For Pagination, I am having problem due to lack of knowledge to replace page 1,2,3,4,5,6,7 8, 0 with NEXT , PREV like I did it for DATAGRID. Have to use NEXT and PREV because the GRIDVIEW Pagesize = 20 while the rows from the TBLSALESTRANSACTION exceeded 350rows
View 6 RepliesI have a simple .aspx page.
I want to show the data either in Chart control or Gridview control. When the user selects an option to see the data either in chart control or grid view control, that specific control has to show up and other control has to become invisible.
So far, I am able to populate data successfully in the chart control. If the user chooses "Grid view" option, how can I show the data in grid view control in the same location. I don't want the gridview control to be shown in a pop up window or any other window.
If VS 2008 and VWD 2008 are both installed on the same machine, will they both use the same Projects folder to keep my projects in?If so, can I open the projects and run them interchangeably with VS2008 and VWD 2008? This is the folder that is located at " User>Documents>Visual Studio 2008>Projects
View 1 RepliesI have a gridview in an update panel which is declared in an ASPX page, and bound to a SQLDataSource in code. The gridview's 'allowsorting' attribute is set to true, and because it is bound to a SQLDataSource, I expect the sorting to be automatically handled.
Yet I am getting the "Message: Sys.WebForms.PageRequestManagerServerErrorException: The GridView 'grdStatusItems' fired event Sorting which wasn't handled" error. I am using Visual Studio 2008, IE8, IIS7. What am I doing wrong? I have done anextensive search for this error, but it seems in most cases where this error occurs, the people are not using a SQLDatasource, so have to handle the sorting event themselves. Is this the case here? Here is the updatepanel and gridview declaration in the aspx file:
[Code]....
In the past I have always added rows of data by binding the gridview to a sqldatasource control. Is there a way to manually (by code) add rows myself from the VB code? I need to call a stored procedure by code and wrote the results one at a time to the gridview.
View 3 RepliesOn my gridview I allow paging. After the user leaves for a new screen is it possible to have them return to the gridview page they had?
View 8 RepliesI've a problem of losing data when I need to edit my row in the Gridview.
I've two columns and one of them, a templatefield, shows data in html format. So I use a literal control and everything works fine. At the RowEditing event, my literal turns into a FCKEditor but I lose my data.
This is what I wrote into the RowEditing event:
VB Code:
[code]....
Some specifications:this code works greatly in other case where I have the boundfield which is converted in textbox. Riempigriglia is a custom procedure of Grid databind.
I am trying to get the value of a cell in a gridview when the user clicks a button field in the same row.
So if the user clicks the 3rd row I want the value of the cell in the the 3rd row and (say) 2nd Column.
[code]....
This is the code I have so far that will tell me which row the user has clicked. Where I am strugling is to now get the value of the cell.