I want to hide some of the columns of the gridview before printing.
For example gridview contains customerid,city and postal code.
Now i want to show city and postal code during printing.
So how can i achieve this?
[URL]....
I have been through ur previous article in which ur exporting the selected columns in grid to Excel...
I need to print the selected columns in Gridview...
My question is how to freeze specifi columns of Gridview control ? Freeze means...for example say if we are freezing the first column of grid then on scrolling a horizontal scroll bar of the grid will scroll all columns other than the first column. That means the first column will be visible always without any movement. But the first column should move if we use the vertical scroll bar.
View 1 RepliesHow to disable editing the data in the cells of datagridview in c#?
View 1 Repliesi have done sending gridview data as excel to mail, it is working fine
then i had 5 columns in gridview but i want to send 4 column instead of 5 column.
protected void Button1_Click(object sender, EventArgs e)
{
fn_AttachGrid(); // here calling function to send mail gridview data as excel format
}
[Code]....
I have a datagrid which displays a list of user data, such as name, his or her status, age. I have created a list of rows of user data but where the column shows status for example Single, Married, i want it to create a dropdown list where i can easily change the user status by selecting it from a dropdown and clicking the update button at the top of the datagrid. The update button will update all records that have been changed not just from the dropdown. I assume the dropdownlist requires a columnbinding event but i can't find any straight forward tutorials.
View 2 RepliesHere Am Using This Query to
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = 'TableName')
But Am getting Total Records instead of i need Specific Columns.....
I have a table dt_details which includes columns - name, address, phone,emailid, website,remarks,paid.
In the datagrid i have to display full columns only if paid is yes and if paid is no only name & phoneno should display.How to do that ?
I use these code for my grid view [URL] ....
Here have Customerid ,Name ,Company column when we click on edit that edit Name and Company Column .
I want when user click on Edit they can edit just Name column I want they can't edit Company column how i can do it?
I know how to export GridView to excel but it exports all Columns
I want to export only some columns and not all of ASP.Net GridView to excel.
i have record for 10 student... i want to enter marks and give status pass or fail..i m using grid view to show data.....like
student name class marks Pass/fail(should be drop down) marks
above are my coloum....and i want to edit only pass/fail and marks entry......how can do it in grid view.
in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]
View 1 RepliesI have a table in my database called "Profiles". This holds data on Female and Male personal characteristics.On my aspx, I have a formview in edit mode which is binded to an object data source with a GetDataByUserId Select methodwhich retrieves data from the "Profiles" Table via a DAL.The "Profiles" table has some columns which relates to females only and some just males and some are generic to both.See example below
UserId - / of Type GUID
GenreId / of Type BOOL.
Hip Size (For females)
Dress Size ( For Females)
ChestSize (For Men )
TrouserSize (For Men)
Weight ( For both )
When the User logs in , they go to an update Page which has the Formview in Edit Item Mode and contains drop down Lists whichare binded to the Users Selected Value. The DDL are in turn bound to their related table such as HIP, Dress, Chest, Trouser etc.bjectiveIf a female user logs in I just want to show them the (Hip Size) DDL and DressSizeDDL in the Edit item template of the formview and not the ChestSize DDL or TrouserSize DDL.At present the GetProfileByUserId returns all colums from the tableMy question is how do I do this and just show DDL which are relevant to the Female or Male Only. In some cases the usermay not have selected an item in the previous form so they could also be NULL.Am i on the right path by writing a Select Query that checks to see if the User is Male or Female by checking the Genre column in Profiles first.Do I also need 2 panels, 1 to hide Female DDLS and the other to Hide MaleDDLs subject to logged in user genre.
I have my code output a gridview with all the data with an option to select records. I'm trying to make a code which would allow me to select a record, and then print this record using a specific Report stored in MS Access.
I've located the code to print the Report it self, but it prints ether all the records or a range.
Question for Print functionality in ASP.Net GridView control artical. I tried you code in my project, when click print current page, nothing happens.
So I download your code into my test web project "WebSite1", greate, it works.
Then in your CS.aspx page,
I added (which is the case of my project of using AJAX).
<asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate>
<div> <asp:GridView ID="GridView1" runat="server"
.......................... gridview stuff gose here .........................
</div> etc etc to close all the tags.
Now run, click print button nothing happens, no any error.
Can you see why put updatePanle for AJAX causing problem ?
I also have to pur EnableEventValidation="false" at top of the page to avoid
I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and
rows as columns like below:
EMP1 1 2 3 4
EMP2 1 2 3 4
I want to print gridview data but don't want print all data. I want to print only Item Templete Data.
View 1 RepliesHow to print gridview header on all pages when we print gridview data then gridview header print on all pages
View 1 RepliesHow to put the title of the report on the page within this cluster of your code?
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView_EngrDisp.RenderControl(hw);
[Code]....
I experimented with a couple of things and looked at MSDN on stringwrite/stringbuilder, etc before bothering you. Keep in mind I'm not talking about the gridview column headings; I'm talking about the report title before the gridview.
I have a GridView that has several dynamic columns (I do not know how many at design time and it could be 0-12 columns, hence need for dynamic columns). I have the columns in the grid and data bound to them - works great. There are other standard, design-time TemplateField columns with TextBox controls in them. These are bound with values that the user can edit. The grid is posted back via a Submit button. My question is "Why does gv.Columns.Insert() cause all my TextBox data to be null on Postback, but gv.Columns.Add() works like a champ?"
protected void BuildColumns()
{
// The first column to begin to insert the columns in the GridView
int columnIndex = 5;
BoundField aoColumn = new BoundField();
aoColumn.HeaderText = "New Column 1";
gvMyGrid.Columns.Insert(columnIndex, aoColumn); // kills txtQuantity.Text on postback
gvMyGrid.Columns.Add(aoColumn); // works fine
columnIndex++;
foreach (MyEntity my in _myEntityCollection)
{
BoundField myColumn = new BoundField();
myColumn.HeaderText = String.Format("{0:d}", my.StartDate);
gvMyGrid.Columns.Insert(columnIndex, myColumn);
columnIndex++;
}
}
I then go on to assign values to these BoundFields in the _RowDataBound method and all of this works great. However, when I post back and try to reference some TextBox and they are all null. And yes, I have the BuildColumns() call wrapped in if (!IsPostBack) on Page_Load. Of course I would like to use .Insert() so that the columns can go in the proper location and not at the end of the Columns array.
I have an aspx page (c# using visual studio 2010) in which I have a terms of service. I would like to allow the users to print the terms of service without having to print the rest of the page. (The rest of the page is various other information)
Therefore I would like a way to specify a panel ID and when the "Print TOS" button is pushed it will only print the information which is in the specific panel specified.
I am printing a GridView on a Panel using the PrintHelper sample code. Two issues arise from the result. One: I would like to print the text of one column, without the hypertext underlining. Two: I would like to print strings ("Active" or "Inactive") for one column instead of a CheckBox.
[Code]....
How to add Title on top of all pages while printing gridview records...
View 1 RepliesHow to take print out show the company name in top of the gridview using asp.net using c#.
View 1 Repliesin my webform --
when user input the valid data then there will be generate a areport and that report displays in a gridview itemtemplate. when i print the report, only first page data printed properly on a predesigned designed paper. and others are not. then how to print each rowdata of gridview on per page.