|
I am exporting a data table to Excel, but my row height get wildly large, how can this be changed to actually set the row height?
public void ExportToExcel(DataTable dataTable)
{
string filename = "Report.xls";
StringWriter tw = new System.IO.StringWriter();
HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
DataGrid dgGrid = new DataGrid();
dgGrid.DataSource = dataTable;
dgGrid.DataBind();
dgGrid.RenderControl(hw);
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
}
|
|
|
|
|
use EPPLUS. You can easily set a DataTable object to Excel (2007 and newer) and Fully layout your sheet.
Heights, fonts, colors and much much more.
See here[^].
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Different between String And StringBuilder
|
|
|
|
|
|
In String Builder When we change the variable value then it does not create new object,It modify again and again same object,but in string if we modify the string variable value then it again and again create a object.So if we have to update string again and again then recommended to use String Builder always.
|
|
|
|
|
|
Hi I am planning to develop a software app using ASP.NET and SqlServer DB. I just wanna know what all the software I need to procure for complete implementation
and from where
|
|
|
|
|
You Need a Microsoft Visual Studio and Microsoft Sql Server only dear.
|
|
|
|
|
You can get these free - Visual Studio Express and SQL Server Express (Google them)
|
|
|
|
|
If you are using Windows OS than u need to install Visual Studio and Sql Express.if u have UNIX or iOS than u need to install mono.
|
|
|
|
|
HI,
I want to know that What is DAL???
And it's use???
As i search in google also but i am Confused???
As anyone know's Please Reply...
|
|
|
|
|
|
Whenever we create an enterprise level apllications then we break the entire architecture into different layes like UI (user interface) layer, Entities (containing plain classes)Layer, DAL(Data access layer) and Service layer. Now, as u asked, all the data base related logic like--
1> to access database
2> to perform CRUD operations
3> to create instance of database objects.
All these logics are written in data access layer for the purpose of seperation of concerns and to provide more robust and neater code.
please have a look at these articles.....
Creating ASP.NET Applications with N-Tier Architecture[^]
http://www.codeproject.com/Articles/36847/Three-Layer-Architecture-in-C-NET
|
|
|
|
|
DAL is part of Factory Model in asp.net.there is have model 、BLL and website item.
In China ,A Programmer dev a tool ,that can use hid tool generate DAL BLL and Model,when soft generate the code,you want It needs fine-tuning a litter.can save more time.
wish can helo you.
|
|
|
|
|
Need Samples to display the PDF Content and also some html controls in MVC application
|
|
|
|
|
Please search the articles section of this website along with google. There you'll find plenty of samples.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Normally you display a pure PDF page as a page.
I suppose you can can display a PDF page as an image element, but you might have to create a PDF thumbnail, in which I haven't figured out how to do yet.
You can also add buttons to a PDF document to perform certain functions like print, and hyperlinks to move to sections of the page.
But combining HTML with a PDF may be tough to do, I don't think it can be done.
I searched and found nothing.
|
|
|
|
|
You can either display the file in an <iframe> , or use PDF.js[^] to display it inline.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
In MVC My Application, we are showing the pdf with the help of pdfviewer in popup, when printing the pdf through wireless printer in IPAD 8.0 it prints white page...
Kindly reply for this to get solution.
|
|
|
|
|
Sounds like you need to do some technical support troubleshooting with the pdfviewer and Ipad.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
i use this admin panel in my project university management system.if any free project download site can suggest it will be helpful
|
|
|
|
|
Need more info. What admin panel?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hi,
Iam stuck up with this thing for past couple of days.
Iam saving company details in access database with compLogo as one of the field name to store the logo image as an OLE Object.
I can display the image in the form but i cannot display it in the crystal report.
I created a dataset with a datatable and created a column called compLogo with data type System.Byte and added this datatable to the database field of the report and dragged and droped the compLogo fieldobject.
And in the code i retrieved the image as a byte array and passed it to the datatable field, but it shows the following error:
System.ArgumentException: Input String was not in a correct format. Couldn't store <system.byte[]> in compLogo Column. Expected type is Byte.
Thanks in advance!!!!
|
|
|
|
|
You'll need to post the relevant code.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hi,
I do have a website that is acting like a FTP site for uploads and downloads.
The workflow is:
- A user account is created
- A folder is created (kind of a home directory)
- A user logs in
- Uploads a file
- An agent logs in
- Download the file
When ever an agent logs in, there is a check for user accounts with no activity for 90+ days.
If found, the user account is deleted and the associated folder too.
THAT's where I have my problem.
1) The user is removed from the role (all good)
2) The user account is deleted (all good)
3) The files and the folder are deleted (issue: permission denied)
Looking at the file permissions in the Windows Explorer, none of the accounts listed does, indeed, have permission to delete the files.
The files to be deleted are ALL created one way or another via the website (either by upload of code behind file creation)
I Googled around and it looks like the Impersonation is the way to go for the deletion.
Now, I found this tutorial on this website but it's all in C# and my page is in VB.NET:
A complete Impersonation Demo in C#.NET[^]
I did find a VB version of the impersonation (lost the link) and when it ran, it crashed the website completely.
I now found this one:
https://code.msdn.microsoft.com/windowsapps/VBImpersonateUser-d8467be8[^]
Before I start to use this (since it's a production website), can anyone tell me if it's any good?
Or...maybe has a better idea on how to delete files created by the website that cannot be deleted by that same website.
Thanks.
|
|
|
|