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
My Grid is bound to a collection type datasource. When I try to sort the Columns in the Grid I get Javascript error saying sorting event not implemented. Why is the default inbuilt sort functionality not working which worked fine when I directly used a sqlDataSource using smart tag. Do I have to write some code to achieve sorting ?
View 1 Replieswe want to have an excel functionality in web page, like filters in headers, +in 1 column we will Dragging some text & it should automatically pasted in next rows...
View 1 RepliesI need good css for Gridview just like the mac css
can we provide the filter functionality to gridview like the excel filter.
Does anyone know of a way to display a grid where the user can select multiple rows from a single column to copy to the clipboard, as opposed to an html table where the text can only be selected by rows. In my work, we do a lot of copy/pasting of chunks of data. I would like to migrate our processes out of SQL mgmt studio and into a browser, but I need an html table that will behave more like a spreadsheet and less like a paragraph.
(see illustration below if you can't understand what I'm talking about)
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 RepliesI'm using the "Reponse.ContentType Method" for exporting from an ASP.NET page to excel using code similar to this:
[Code]....
That isn't my exact code since my code is in C# but otherwise basically the same. It works fine but when I open the file in Excel everything is formatted with the "General" data type. It doesn't matter if its a string, a number or a currency. I would like to be able to define how each column is formatted so that Excel displays the data properly with minimal if not any work from the user. I know the sw.ToString above is simply an html table that is in string form. Do I have to parse that string and add in something to format each cell or can I do something with the DataGrid object or something completely different? This seems like it would be a common problem or desire but I can't find much of anything on it anywhere.
how to count total record in my data grid and after that export the records to excel ?
Below are the coding of my datagrid .
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";
}
}
I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines.I think I'm missing to set some property or somethnig ehwn exporting.
View 6 RepliesI want to upload a Excel file into database. But File name and File Type is not specific. that means excel file may be created in Office 2003
or Office 2007 or Office 2010. Now I knew that Connection string is diffrent for each format. But how i can recognize the File Format ?
I want to fetch data from all type of Excel files. I am using FileUpload control for uploading Excel.
I want to import a spreadsheet into SQL. The import/export wizard forces Column A to be a double. In Excel, the column is formatted as text. When I try to convert from double to text/varchar/nvarchar, the import process fails. Why can't I convert a number to text in SQL?
View 3 RepliesI 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 Replieshow can i store image into database and view it in grid view?
View 3 Repliesi 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 want to do something like www.mysite.com/subsite, www.mysite.com/subsite2 etc
subsite/subsite2 are not actual directories. I did something like this previously using a custom 404 error page. I'm just wondering if there's a better way to do this now, especially in vs2010/.net 4.0 ? Or would using a custom 404 still be the best method?
I want to get code for how to insert records into multiple table of database from one excel sheet.
View 3 Replieshow 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";
}
}
I have an export that works with a GridView, but I would like to export a DB Table to excel by clicking a button.
What is the best way to go about exporting to excel without GridViews?
I 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.
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 RepliesWhen data comes more than 30 Rows in Grid then the Excel goes in different format.There is parsian/Urdu Font in Grid data.
<div id="PrintDiv">
<asp:GridView ID="gvExamReport" ClientIDMode="Static" runat="server" OnDataBound="gvExamReport_DataBound"
HeaderStyle-Height="20" HeaderStyle-HorizontalAlign="Center" OnRowDataBound="gvExamReport_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="مرتبة">
[CODE]..
I'm considering going at this myself because my requirements are particular and highly customized:
The grid is bound to a collection of complicated objects, each of which may contain child and grandchild objects. Depending on data and context, the template'd cells vary from TextBoxes to ComboBoxes to Calendars to a combination of controls.TextBox cells have Google-style auto-complete functionality. Also each TextBox cell can expand into a small TreeView pane that allows hierarchy-navigating selection of a value should auto-complete be insufficient.Values from other controls can be drag-and-dropped into cells.Columns are re-sizable and re-orderable. Clicking their headers sorts data.All of the above is AJAX / client-side / Web 2.0 of course.
Has anyone built anything similar from scratch? Or used an effective tool to accomplish this goal? How well would Telerik meet my specs? Is it right to have the hunch that something this specific is best done by taking a Microsoft GridView and extending it myself?
I'm considering going at this myself because my requirements are particular and highly customized:The grid is bound to a collection of complicated objects, each of which may contain child and grandchild objects. Depending on data and context, the template'd cells vary from TextBoxes to ComboBoxes to Calendars to a combination of controlsTextBox cells have Google-style auto-complete functionality. Also each TextBox cell can expand into a small TreeView pane that allows hierarchy-navigating selection of a value should auto-complete be insufficient
View 3 Repliesi have try to export data to excel using gridview.
I have export it successfully but some data is missing which is due to the column format in the exported excel file is not TEXT .
[Code]....
I need to set the exported excel file column format to TEXT but find no solution on this.
Have 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 .