|
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition", "attachment;filename=Report.xls")
Response.Write(l_objStrBuilder.ToString)
Response.Flush()
Response.End()
try this way is help ful or not
|
|
|
|
|
Dear all,
I want to know how to send automatic email notification taking email address from database and send each one ema il according to there status for eg :- Choose email from database of status 1 and send them birthday message and for status 2 membership end message etc and each message template can also be picked by database.
As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005
If any one of you have code than Please Post it.
Thanks u all for your support
RAHUL TANDON
|
|
|
|
|
rahultandon1000 wrote: As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005
So, what is you problem ? You want to create a Windows services which will regularly check your database and send the notification mail to the user ?
If yes, then what is the point to post this question in ASP.NET Forum.
You have to create a simple web service, which will call Some SP of of SQL server and retrieve the data from database.
By the way you can do all the thing only using SQL server 2005 also
|
|
|
|
|
hello,
i want to pass parameters in a POST mode from a .NET page to other page.
i heared about : Server.Transfer("xxx.asp",true);
can i have guidelines on how to use it ?
tnx in advance ,
avi
|
|
|
|
|
Server.Transfer("xxx.asp?paramname=paramvalue",true);
and your xxx.aspx page_load event read parameter value like
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dim str as string=Request.QueryString("paramname")
End Sub
i thing is helpful
|
|
|
|
|
This is true and probably sufficient for many cases, but be aware you are changing from POST to GET and then have the limitations of the querystring, such as: maximum of 2083 characters in the URI(This is IE, not sure for FF/Opera/other), and of course there are potentially security risks if you are sending any sensitive data it will be shown and can be easily altered by the end user.
If you are trying a to re-post without relying on the querystring to a different page in your application there are probably workarounds (maybe by populating fields on an intermediate page, or manually building a response...then having one of them autopost to your ultimate target?) But I have never tried these before.
|
|
|
|
|
i need Administrator of my website to add forms at runtime. is it possible to add webforms at runtime. if yes then how.
|
|
|
|
|
S_Aijaz1 wrote: is it possible to add webforms at runtime. if yes then how.
Google Says
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
i have added page dynamicaly now i need to add controls to these pages dynamically with setting properties and default values
|
|
|
|
|
Hi friends,
When I retrieve some text from database, a Long line be created in my control and a horizontal scroll be created.
I want this long line be shown in multi line.
How I can solve this problem?
Thank You
Hoda
|
|
|
|
|
You could either:
1.) Store the text with new line-seperators
2.) or set your textbox as multiline and wordwrap
Regards
Sebastian
|
|
|
|
|
Thank you,
Please give me more information about line-seperators.
i used Wrap but my poroblem not solved.
Hoda
|
|
|
|
|
I have written a web service that reads from a message queue. This works fine under Cassini.
Now that I have deployed the service under IIS, I receive an error message when the service tries to access the queue:
The queue does not exist or you do not have sufficient permissions to perform the operation.
I have set the anonymous access user on the IIS virtual directory to be my own domain account, which is a member of the administrators group on the local machine. I have granted this same user full permissions on the queue, as well as NETWORK SERVICE and ASPNET.
I still get the same error message (The queue does exist and the spelling is correct).
I have also tried disabling anonymous access on the virtual directory and connecting to the service using my own login details - to no avail.
Any help with this problem will be greatly appreciated!
I have also tried various combinations of: Windows authentication, impersonation, local users, domain users, all of them having full permissions on the queue. I have added permissions for the user and ASPNET on the MSMQ store folders on C:\
|
|
|
|
|
BillyGoatGruff wrote: The queue does not exist or you do not have sufficient permissions to perform the operation.
I have set the anonymous access user on the IIS virtual directory to be my own domain account, which is a member of the administrators group on the local machine. I have granted this same user full permissions on the queue, as well as NETWORK SERVICE and ASPNET.
Do the following :
1. Create A Application Pool In IIS (Say MSMQWEBAppPool)
2. Change the Identity of Application Pool To Local System ( Default > NetworkService )
3. Write Click You Virtual Directory, Select the MSMQWEBAppPool Application Pool from Application Pool Dropdown list .
4. Click on Apply.
Then Test your application.
Its is because, by default your you web sites run under default application pool, which identity is "Network Service" and which has very minimum privilege on the server. Local System having the higher privilege on you system.
You may face the same problem, while loogin error on Event viewer
So, Try, and Let me know the result.
Hope this will help you
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Thanks Abhijit,
Your understanding of the problem is pretty close, in that the process trying to execute the code is running as a different under IIS than it does under Cassini.
I am using IIS 5.0 and so I cannot create a separate app pool, although I can alter bay various means the user that the code runs as.
The problem was that regardless of which user I ran it as - I always got the same error message - even when the user was a member of the local and domain administrator groups, and this user had full permissions on the queue. i.e. It is barely possible to assign more rights to a user.
It turns out, that using a FormatName for the queue, rather than a path name (myMachine\queueName) has solved the problem...
FormatName:DIRECT=OS:myMachine\myQueue
I am uncertain as to exactly why this is the case. Reading up has showed that when a path name is used, there is a necessity for an AD lookup, and although I think that the users that I have been testing with should have rights to do this, perhaps there is something missing.
However the immediate problem is solved and that's good enough for me.
Thanks very much for your response.
|
|
|
|
|
|
|
how we create a login page in which we enter a user name or password,so i want the coding for that in c#
|
|
|
|
|
pallavi shrivastava wrote: how we create a login page in which we enter a user name or password,so i want the coding for that in c#
You can use ASP.NET Login Control
Or you can write your custom code using two text box, one of them will take username and another will take the Password. On Click of login button validate the user id and password from Database( If you have stored user info there else any other place ).
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
look at your OS login Form and add a web form and design it just like that
|
|
|
|
|
pallavi shrivastava wrote: code to create login page
First of all welcome come to Code Project.
Before posting a questions , you should read the forum guide line that how to ask question.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Firstly Welcome to Code Project
Here you dont just post, you must First Google and then if you get stuck you can post. here is your Answer
http://www.dotnetfunda.com/forums/thread459-check-login-user.aspx[^]
Hope it Helps
Vuyiswa Maseko
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
pallavi shrivastava wrote: code to create login page
Price: £500
|
|
|
|
|
J4amieC wrote: Price: £500
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
what? Gather requirements, implement solution, test. I could do it in a day an a half for something so simple. Hence the rate.
|
|
|
|