|
Hello, everyone:
Now i want to export my query result to excel. At first, i have tried to export the results displayed through datagrid directly to excel. However, the amount of query result is quite large, in this case i decide to use page sorting datagrid. but most articles in CP tell us how to export only one page to excel, not all the datatable.
Therefore, is there any better approach to export all the datatable directly to excel? Any idear will be appreciated! Thanks in advance!
|
|
|
|
|
The above link will solve you problem, very nice code and easy to use.
http://www.codeproject.com/csharp/datasettoexcel.asp
Ram
|
|
|
|
|
In a DataList, when the user clicks on the Edit button, a cell (TableCell) and a link are created at runtime. When the user clicks on the link, a calendar pops up. It closes itself when the user clicks on a date. My problem is that I don't know how to populate the cell with the date that the user chooses from the calendar. I can, however, get the date from the calendar to populate the text outside the datalist. I'd be appreciate if you coud show me some samples on how to achieve this. Thanks.
The problem here is i am able to populate the textbox outside the datalist but not inside a datalist.
frossie
|
|
|
|
|
I want to know once we set AuthenticationTicket and encrypt it and place it in the authentication cookie then how asp.net validates the information we just placed in the cookie , how it only accepts an encrypted instance of AuthenticationTicket. Can someone tamper with a cookie on the client side and fool asp.net. How asp.net prevents this kind of attacks ?
My another question is about Context.User . We know HTTP protocol is statless , once we set the authentication cookie and set Context.User in code for some page then in later requests for another pages when we check Context.User we see that its value is maintained. I want to know how this takes place . can someone tell me the full process .Does asp.net do it using the authentication cookie ? is yes Where it takes place ? If someone can show me a flowchart about the actions asp.net does it will be good.
|
|
|
|
|
|
Thanks for your help. I apologize for the bold text.![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Why Application_PostAuthenticateRequest and Application_AuthenticateRequest events happen twice ? When I put a breakpoint in their code I see that when I run the application they are called twice ? Can someone tell me why they have to be called twice ? Illustrating their position in the asp.net's events flowchart will be helpful . Help me please .
|
|
|
|
|
Basically, when a web page is processed, the application will get through a couple of events starting with the BeginRequest, AuthenticateRequest, PostAuthenticateRequest ..... For example when you first access a restricted web page, say Home.aspx, you can see that these two events occur, and because you are not logged on yet you will redirected to the Login page, and as a result of this the two events get fired again. And then if in the Login page there are a couple of links requesting for the resources at the server side and they are handled by the ASP.NET engine like the WebResource.axd, you'll see that these events again occurs. For more information on the events of the Application, you can see the HttpApplication[^]
|
|
|
|
|
i´m trying to programm a simple chat room with asp.net 1.1 and VB (with code behind).
I´ve searched for samples but there was no good one putting in my project, which already exists.
Someone have a sample with instructions to install?
It´s only for private use so i´m searching "freeware".
thangs fpr answering and sorry for bad english 
Chrissi
|
|
|
|
|
|
Hi,
I have created a DotNetNuke website and I want to host it on my Windows Server 2003. I have given a public IP address to my server and setup asp.net applications on the IIS (version 6).
I can access the DNN website locally from my machine but I cant access some pages from another machine using the IP address. I can access the html pages or images from another machine but I cant view the .aspx pages. I think the pages that are linked to the database cannot be viewed.
I would really appreciate if someone can help me with setting up a DNN website on my web hosting server.
Thanks.
Karan
|
|
|
|
|
I am extending the gridview control and override Render method. For some reason, i have to call 'HeaderRow.RenderControl(buffer)', 'FooterRow.RenderControl ()', and blah blah .. The problem is all the skin setting is not rendered by these methods ... Why ????
|
|
|
|
|
How can i convert word document to pdf in vb.net
Mansoor
|
|
|
|
|
im new in asp.net and c#, and i have a web project where in one page i made a form with textboxes e.t.c. to insert data in the datasource, and i use also dropdowh lists from which i can select data.But if the data i want is not included in the dropdown list i click on a button to open a new window where i have another form to insert data to the table from which the drop downlist takes it's contents.The problem is that after i insert sth and i close the window and return to the previous page i have to refresh that page to see in the dropdownlist what i had insert and i loose everything else i had writen in the textboxes e.t.c..
Is there anything i can do ?????
Thanks
galatia
|
|
|
|
|
You can use child pop up window to do the task and on closing of the child window you can refresh the parent page. Check the viewstate if you are loosing the data in the postbacks.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi,
How could I count the number of guests on my website like in the following website:
http://www.sadeveloper.net[^]
I dont think they have used Session_end and Session_start because this method doesn't give a precise result?
I am too late but i will never give up
|
|
|
|
|
|
Do you know how to build a message board web site?
How to start?If you have an example of a forum web site,you could send this example or message about this example.
If you send any message about forum,I will be very happy.
|
|
|
|
|
|
Hi, im simply trying to set autopostback=true on an asp dropdownlist.
this works until i place a button on the form, now the autopostback will not fire
and a javascript error gets thrown "object doesnt support property or method"
any ideas?
|
|
|
|
|
this works fine for me
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
<asp:ListItem>Item 1</asp:ListItem>
<asp:ListItem>Item 2</asp:ListItem>
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" Text="Button" />
</form>
</body>
</html>
regs,
g00fy
-- modified at 9:05 Sunday 13th August, 2006
|
|
|
|
|
thanks for the reply goofy, found out what it was.
I initially added the button through vs2005 which, set the id of the button to "submit", which interfered with the autopostback code 
|
|
|
|
|
plz help me to invoke the OnTextChanged event to the TextBox placed in the footer template of the grid.On changing the TextBox text property the corresponding data matching the to the text should be displayed it the adjacent rows ..
plz somebody help to goforward in my project
ashok kumar.y
plz help me to invoke the OnTextChanged event to the TextBox placed in the footer template of the grid.On changing the TextBox text property the corresponding data matching the to the text should be displayed it the adjacent rows ..
plz somebody help to goforward in my project
ashok kumar.y
plz help me to invoke the OnTextChanged event to the TextBox placed in the footer template of the grid.On changing the TextBox text property the corresponding data matching the to the text should be displayed it the adjacent rows ..
plz somebody help to goforward in my project
ashok kumar.y
|
|
|
|
|
You want to do it on server side or client side?
BTW by writing the question three times doesn't ensure that the question will be answered early.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have built a web application using Deklarit objects as the Data Abstraction Layer. It works fine on development server but when I upload to my shared host I get SecurityExceptions like the following:
[SecurityException: That assembly does not allow partially trusted callers.]
Deklarit.Data.DataStore.GetReadWriteConnection() +0
Deklarit.Data.DataStore.GetReadWriteConnection(IDbTransaction currentTransaction) +96
WebShopData.DownloadDataAdapter.Update(DataSet dataSet) +69
brokers.DownloadAdmin.AddDownload(String DownloadName, FileUpload Upload, String DownloadDescription) +246
admin_downloads_AddEditDownload.AddButton_Click(Object sender, EventArgs e) +294
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6953
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +154
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.admin_downloads_addeditdownload_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Which assembly is it talking about, DeklaritLibrary.dll, WebShopData.dll or the Enterprise Library dll's?
I have strong named my Deklarit generated assembly and added the AllowPartiallyTrustedCallers attribute to the assembly. The problem only occurs on write to the database, read connection is working fine.
For those not familiar, I am using Deklarit 4.0 and the generated assembly uses Micrososft Enterperise Library which I have also recompiled with the AllowPartiallyTrustedCallers attribute on the Microsoft.Practices.EnterpriseLibrary.Common.dll, Microsoft.Practices.EnterpriseLibrary.Configuration.dll & Microsoft.Practices.EnterpriseLibrary.Security.Cryptography.dll. The host is a shared host and they do not support full trust and I cannot override this setting in web.config.
I have trawled Google and almost everywhere else and I cannot find a simple explanation of how to overcome this problem.
Can anyone please help, it is driving me nuts and consuming alot of time to get nowhere?
Kind regards,
Maurice Moore
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
