i have a gridview in which there is another gridview now i want the data in the primary as well as the nested gridview in pdf and excel format. i have tried all sort of things how ever none is working can anyone send me the working code for pdf and excel for grid with in a grid.
View 3 RepliesI'm getting some Xml back from a service. I would like it to be the datasource of a grid view on my aspx page. Here is a sample of the Xml
<?xml version="1.0" encoding="utf-16" ?>
<ArrayOfTripTollCompleteDC xmlns:xsi=[URL]"
xmlns:xsd=[URL]>
<TripTollCompleteDC>
<TripTollId>5</TripTollId>
<DMSLaneModeID xsi:nil="true" />
<HOVOnly>false</HOVOnly>
<CreateDateTime>2010-06-07T15:54:01.023</CreateDateTime>
<ConfigVTMSDelaySeconds>5</ConfigVTMSDelaySeconds>
</TripTollCompleteDC>
and here is my code that parses the xml and tries to bind the grid. What am I missing here?
var retVal = service.GetTripDetailsByTripID(tripId);
var xmlTrips = XDocument.Parse(retVal);
var tripTolls =
from t in xmlTrips.Elements("TripTollCompleteDC")
select new {
TripTollId = (int)t.Element("TripTollId")
, DMSLaneModeID = (int?)t.Element("DMSLaneModeID")
, HOVOnly = (bool)t.Element("HOVOnly")
, CreateDateTime = (DateTime)t.Element("CreateDateTime")
, ConfigVTMSDelaySeconds = (int)t.Element("ConfigVTMSDelaySeconds")
};
grdTripDetails.DataSource = tripTolls;
grdTripDetails.DataBind();
I realize these are anonymous types. Is that a problem? I have verified the service is returning the Xml as stated above. Can anyone out there point me in the right direction? Just for completeness, here is the grid markup <asp:GridView runat="server" ID="grdTripDetails" />
i have one grid and one button when i click on that button then it expand and showing another grid under the row of parent grid how to do that.
View 2 RepliesI have a GridView that I want to export to Excel. When I use the sample code I find online, it exports the content to Excel just fine, but for some reason it also clears out all grid lines outside of my exported table.
For your average excel user this is easy enough to fix, but I need this solution to work for everyone.
So then is there a way to export the data in a GridView into an Excel Workbook so that it looks like it was just typed into Excel? I've pasted the code I am using below, assume that a GridView called toPrint exists and has accurate data.
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=" + name + "_Registration_Forms.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
Page.EnableViewState = false;
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
toPrint.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
EDIT: Found one partial solution. If I export as a comma-delimited list and set the header to be a CSV file, it opens fine and all grid lines (even those outside of the exported data) are showing. The only problem with this of course is having to strip out every comma and newline character from my values before exporting them.
Problem in YUI:I am using YUI grid,my dataset contains some special character.i bind my dataset into the grid,but its not displayed in my grid? how to solve this
View 1 RepliesHave a GridView with a templated select button hidden and using
e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .
When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .
I have Parent/Child Grid (also called Nested Grids).
Parent Grid (PG) :: PG has two template fields. 1st template field has "Category ID" and 2nd template has Child Grid
Child Grid (CG) :: CG is populated in PG's RowDataBund event based on "Category ID". In CG's DataBound event, I am doing something which I need to display in CG's footer row.
Problem :: In the footer row of each CG, I have to show the "Category ID" which is in PG' row. How can I get hold of the PG's row which hascurrent nested grid (there will 'n' child grids, one for each 'Category ID' in the PG ) so I can read the "Category ID"
I was thinking if I could do something (DataBound event of CG) like this..
string catId = ChildGrid.Parent[get the index of the current row in PG].Cells[0].Text;
how to remove grid lines from Grid View suing style sheet...
View 1 RepliesIn a ASP.NET application I have a paging RadGrid which shows up textbox in each row. Outside the grid, there is an OK button to save the content of all the textbox. If user changes text in any one or more of the textbox and without clicking on the "OK" button, tries to move to a different page number (of the grid by clicking on the page number), he should be prompted for confirmation of save or cancel the changes.
I am guessing that one can write a Javascript function which would look for any form input control (textbox in my case) and detect changes and If there are changes, would prompt the user. However, I am not sure where I can call this function from?
I am using RadGrid but I guess this should be applicable to GridView as well.
i am trying to add subtotal in gridfooter with has grid inside grid
View 1 RepliesHow i can able to print only a grid view in pdf,doc and in ms excel? I am using visual studio 2005
View 5 RepliesI have an entity "Order", which contains a set of states. Every state has date and name.
I want show grid with all orders and in grid one column with last state of order. But I dont understand how to do it.
I am trying to create a second grid in the same page with detailed info for a given record of the first Grid, but when I press select in the first grid nothing happens. I follwed everything I read.
<asp:GridView runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" style="margin-right: 0px" Width="659px"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AllowSorting="True" DataKeyNames="accession_num,organ"
EnablePersistedSelection="True" EnableSortingAndPagingCallbacks="True" onselectedindexchanged="Unnamed1_SelectedIndexChanged"
>
<Columns>
<asp:BoundField DataField="organ" HeaderText="organ"
SortExpression="organ" />
<asp:BoundField DataField="weight" HeaderText="weight"
SortExpression="weight" />
<asp:BoundField DataField="unit" HeaderText="unit" SortExpression="unit" />
<asp:BoundField DataField="accession_num" HeaderText="accession_num"
ReadOnly="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:pdmstestConnectionString %>"
SelectCommand="GetGrossOrgan" SelectCommandType="StoredProcedure"
UpdateCommand="UpdateGrossOrgan" UpdateCommandType="StoredProcedure"
DeleteCommand="DELETE FROM [Pathology_Gross_Organ] WHERE [accession_num] = @accession_num AND [organ] = @original_organ"
OldValuesParameterFormatString="original_{0}"
> <SelectParameters>
<asp:ControlParameter ControlID="accession_num" Name="accession_num"
PropertyName="Text" Type="String"/>
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="accession_num" Type="String" />
<asp:Parameter Name="original_organ" Type="String"/>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="accession_num" Type="String"/>
<asp:Parameter Name="organ" Type="String"/>
<asp:Parameter Name="weight" Type="Int16" />
<asp:Parameter Name="unit" Type="String"/>
</UpdateParameters>
</asp:SqlDataSource>
I have a grid view that does add, edit update and delete. ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that.
View 4 RepliesI'm using ASP.NET/VB and am wanting to nest a grid inside of another grid. I've seen them but am unsure how to make them work. I have a Orders table with an OrderID and it is linked to a Orders_Detail table. I would like to be able to select the order and see the details. I've done it differently with 2 grids outside of each other, but this isn't the solution I need.
View 1 RepliesI have a Select All checkbox in my grid that calls this function...works fine. Outside of my grid I'd like to use another checkbox for something else, but when the select all checkbox in the grid is selected, it also selects my checkbox outside of the grid. Is there way to make the checkbox outside of the grid independent from the ones in the grid?
[code]....
Is there any chance to add more than one grid row in single grid row like this.
<h1> Question</h1>
<table width="100%">
<tr style="background-color:Gray; color:White;">
<td>
Name
</td>
<td>
Product
[code]...
how to import excel file to grid view and that data can be store in database in asp.net?
View 1 RepliesI cant bind my Grid. I dont know what I am doing wrong, the grid appears empty when I run the program.
here is my code ::
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
this.BindGrid(this.GridView1);
}......
i'm looking for a control with following functionality in GridView or other data control
1. Excel Type Editing, with ability copy to and from excel
2. Ordering the rows with Drag and Drop functionality
how to count total record in my data grid and after that export the records to excel ?
GridView id="grdCustomer"
void Data()
{
qry = "select * from customer order by customerId DESC";
DataSet ds = new DataSet();
ds = DBUtil.getTable(qry);
if (ds.Tables[0].Rows.Count != 0)
{
grdCustomer.DataSource = ds;
grdCustomer.DataBind();
}
else
{
lblMsg.Text = "Customer List Is Empty";
}
}
Export to Excel with two sheets from two grid views. I am in need of export two grids into a single excel with two sheets.
View 2 Replies[Code]....
i have successfully showed data using puting directpath in to a textbox(e.g, filename=TextBox1.Text;). but the code above is not working. i dont know why.
What are my options for turning a grid of data in my webpage turn into an excel file.
Is it best for me to return data to the server for the excel file to be made...
I've seen IE open excel files kind of natively - how is that done? Can I hyjack that functionality somehow??
I have a file pdf, in file pdf of me has a table with many columns. How to Fill data from file pdf to columns of file Excel?I want fill data from file table of file pdf to file excel following format of file pdf.
View 1 Replies