|
hello,
how to gridview data export to excel and it should save as zip file??
plz give me complete source code??
its urgent...
chotachetan
|
|
|
|
|
Take one image..on clcik of tht right following code
its save gridview data as .xls
not in zip file
protected void imgBtnExport_Click(object sender, ImageClickEventArgs e)
{
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
try
{
DateTime dtFromDate, dtToDate;
dtFromDate = Convert.ToDateTime(txtFromDate.Text);
dtToDate = Convert.ToDateTime(txtToDate.Text);
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=ExcelName.xls");
Response.Charset = "";
// If you want the option to open the Excel file without saving then
// comment out the line below
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
this.EnableViewState = false;
GridView grdExp = new GridView();
grdExp.AllowPaging = false;
grdExp.AllowSorting = false;
DataSet dsRawProd = objReportBL.GetRawProductivityData(dtFromDate.ToShortDateString(), dtToDate.ToShortDateString(), 0, 0);
if (dsRawProd.Tables.Count > 0 && dsRawProd.Tables[0].Rows.Count > 0)
{
DataTable dtRowPrd = dsRawProd.Tables[0];
DataView dv = new DataView(dtRowPrd);
grdExp.DataSource = dv;
grdExp.DataBind();
//grdExp.Columns.
grdExp.RenderControl(htmlWrite);
}
}
catch (Exception)
{
}
Response.Write(stringWrite.ToString());
Response.End();
}
|
|
|
|
|
But i want i should save as zip format...
it should be save as zip format omly...
|
|
|
|
|
anujchetan wrote: plz give me complete source code??
that would cost you One Lakh Crore
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
hi all,
I am binding a gridview with 18 to 30 thousand records and I have implimented datagrids defult paging concept.But during binding it doesnot give any error where as while rendering the page system hangs for some time and then giveng an error like :
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
[OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.]
System.IO.MemoryStream.set_Capacity(Int32 value) +59
System.IO.MemoryStream.EnsureCapacity(Int32 value) +47
System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count) +121
System.IO.BinaryWriter.Write(Byte[] buffer, Int32 index, Int32 count) +25
System.Web.UI.ObjectStateFormatter.SerializeValue(SerializerBinaryWriter writer, Object value) +4549
[ArgumentException: Error serializing value 'System.Data.DataSet' of type 'System.Data.DataSet.']
System.Web.UI.ObjectStateFormatter.SerializeValue(SerializerBinaryWriter writer, Object value) +4857
System.Web.UI.ObjectStateFormatter.Serialize(Stream outputStream, Object stateGraph) +140
System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph) +93
System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state) +30
System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph) +52
System.Web.UI.HiddenFieldPageStatePersister.Save() +125
System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state) +148
System.Web.UI.Page.SaveAllState() +979
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5018
I am using asp.net 2.0 with vb.net. Please provide some solutions it's urgent.Is there any setting in default pagging so that it will work fine for large data also.
regards
bikash 
modified on Wednesday, April 15, 2009 7:19 AM
|
|
|
|
|
bikash pattanayak wrote: I am binding a gridview with 18 to 20 thousand records
bikash pattanayak wrote: Please provide some solutions it's urgent.
Don't bind so much data to the grid view.
|
|
|
|
|
Good day,
I'm doing an ASP.NET web project. One of the site's functionallities is that the user can upload / download files ( the uploaded files are not supposed to be with size ovr 1 MB). Since there are about 10 000 visitors per day and A LOT of people download and upload files a big problem occured. As you know the hhtp web traffic and web space are quite expensive and 1000 people uploading and downloading 1mb files a day costs a lot.
So i decied to buy an FTP space where i'm going to upload and download the files.
Here i'm stuck! What is the best way to upload / download files on anftp server? I'm thinking of two ways:
1) The client anthenticates on the web server and uploads the files. The server uploads the files on the FTP
2) The clients directly authenticates on the ftp server and uploads files withougt the web server.
However the 1) has a disadvantage that the server makes "double traffic" ( one for receiving the file and one of uploading the file on an ftp server)
The 2) is that the password must be stored on the client and there is a serious security risk
Please Help
Best wishes, Hristiyan
|
|
|
|
|
Hristiyan wrote: the uploaded files are not supposed to be with size ovr 1 MB
To begin with 1MB is not that much of data by today's account
Hristiyan wrote: Since there are about 10 000 visitors per day and A LOT of people download and upload files a big problem occured.
Do you expect all the people to upload 1MB of data? If so 10,000 x 1MB = 10,000MB = 10GB. Do you expect this to be daily uploads and downloads? If so, we have very high traffic.
Hristiyan wrote: So i decied to buy an FTP space where i'm going to upload and download the files.
How do you think FTP will solve you the storage space?
What is the realistic upload do you expect? How about download?
We have an application that can upload upto 700MB and servers thousands concurent users downloading files. I don't see where is your problem.
Now, as for ftp: if you have to do it with option 1, then why don't cut off the ftp and handle it in your own. If you can upload that much data, then you are all set
Look here[^] and here[^]
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Maybe i didn't make myself clear. The project that i'm making requires that every day aroung 1000 to 5000 people are gonna upload / download files which are around 1 mb. I'm on a web hosting plan which requires $5 for each 5GB additional traffic. Which means 30x5$ = 150$ per month for additional web traffic and 5$ for each 5$ for each 500MB web space. You can immagine the sum.
Since i ALMOST don't benefit from my web site, thats quite an expense. So some time ago i saw some FTP hostings which are A LOT more affortable ( The FTP traffic is much cheaper, the ftp space is much cheaper). So my main idea is to store those files on an that kind of FTP server. However i need logic so i can upload files on that FTP server. In my oppinion there are two ways to achieve this:
1) The client authenticates to the web server -> Uploads the file on the web server -> The web server uploads the file on the FTP server. However this method has a disadvantage - the web server will have to make twice as much traffic. Once for the client to upload data on the web server and once for the web server to upload data on the ftp server.
2) When the client is uploading the file directly upload it on the FTP server withought the intervention of the web server. However this means that "somewhere on the client side" is supposed to be stored the password of the FTP server ( so the client can upload the file )
However i think that there might be a another way. Like:
The client authenticates to the web server. "Somehow the web server tells the ftp server that the client is gonna upload a file and the ftp server accepts the connection" ( Thats some really newbiesh way to explain it though )
Any suggestions ?
Best wishes, Hristiyan
|
|
|
|
|
Hi every body,
I am using Ajax timer control for getting
the pop ups at the right bottom side.I am able to get
the pop ups at the right bottom side for every specified
time interval.But for each and specified time interval
the page is getting loaded and pop up is been displayed.
my problem is how to avoid the page loads in timer control
for specified time interval.I dont want to see the page loads
as its very disturbing for the person who works on the application.
can any body tell the solution for this problem.
Thanking you
Ramesh y s v k
|
|
|
|
|
I am totally confused.
Member 4470223 wrote: I am using Ajax timer control for getting
the pop ups at the right bottom side.I am able to get
the pop ups at the right bottom side for every specified
time interval.But for each and specified time interval
the page is getting loaded and pop up is been displayed.
Ok good
Member 4470223 wrote: my problem is how to avoid the page loads in timer control
for specified time interval.I dont want to see the page loads
as its very disturbing for the person who works on the application.
what is the problem?
Member 4470223 wrote: can any body tell the solution for this problem.
because you coded it that way. Read your first paragraph. If you don't want to show the popup during development, comment out the code until you complete other sections
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Hi friends,
How to maintain a session state(user state) between multiple URLs?
|
|
|
|
|
|
hi
i m using the object tag in my aspx page
like
while i m trying to access this control in a function then
it is showing a error
Error 1 Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). D:\naveen attri\infosys\test2.aspx 275
what should i do ?
nowhere i m playing with this guid
i m new to asp.net
|
|
|
|
|
What is the value you have given for the 'classid' or else 'progid' property in the tag? If you are using this property give the value in the prescribed format xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
What is the control you are referencing using the object tag?
"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)
|
|
|
|
|
Hi friends,
Here i explain the requirments. If a user login he is activated in current members. If he logout using the logout button, he is deactivated. I did it using the database.
But the problem is if the user straightly closes the Browser window, his name was not deactivated in the database.
Can anyone tell how to solve the problem ??
|
|
|
|
|
Work with timeouts. As every user has its own session, you can catch the session-timeout-event. When this event fires you know that the user didn't take an action during the last xx minutes. Deactivate the user in your database according to this event.
Regards
Sebastian
P.S.: A handler for this event can be found in Global.asax.
|
|
|
|
|
Cant understand. Can u explain briefly?
|
|
|
|
|
It means you're probably not clever enough to be attempting this task. Which part of the clear explanation you were given used terms you're not able to comprehend ?
There is a better way, but it's also more complex, so there's probably no sense in trying to explain it.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Do the following:
1) Open the Global.asax-file of your ASP.NET project
2) Go to the method void Session_End(object sender, EventArgs e) ...
3) Call the method you are using to deactivate the user (if he clicks at the logout-button) within session_end
@Christian Graus: I'm interested in the better way to do this you mentioned. How does it work?
Regards
Sebastian
|
|
|
|
|
Hi,
I am using an Update Panel. inside the Update Panel I vahe 5 DropDown List control
for this Update panel i am using an UpdateProgress control of AJAX. In UpdateProgress control I have used div tag with z-index property.
I want that when I run the application and choose any items from any DropDownList, an UpdateProgree should overlap the entire UpdatePanel.
But i am not getting an output.
So, If u have a solution for this, please Help me............
|
|
|
|
|
hi,
I am devloping a web application in which i am using gridview with its template field and apply update panel on it. but what happen the validation on gridview is not working properly.and when i remove the update panel its working correctly.
I m unable to find why its happen can any on ehelp me for the same.
|
|
|
|
|
hi ,
I am devloping a web application in which i have an menu from which diffrent pages can be open now what i want is to restrict the user to open the same page from the menu more than once.so how do i restrict.
Thanks in advance for your help.
|
|
|
|
|
If the pages are popups, then you can do this using javascript. keep a reference to each open window and focus on it if someone tries to open it when it is already open.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Thanks for replaying
But these pages are not popups these are the master form ,
whats the requirement is that when once the form is open and user agian tries to open it it should not do any thing.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
