Hi, Please don't be rude. Here every one try to help each other. So be polite while asking question or seeking for help. Thanks ! Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

Create a sql job[^]

Krishhhhhhhhhhhhhh wrote: I want send an automatic mail to those status is incomplete(In my database table one column has data like either "complete" or "incomplete"). When the status is "incomplete",then send a mail daily once to "so and so email id". There are multiple ways that you can solve this. May I suggest writing a console-application that makes a SqlConnection to verify the status? It would be quite trivial to send an email from C#, and you can launch the application using Windows' task-scheduler. Krishhhhhhhhhhhhhh wrote: Stop this bloody replies and do ur job perfectly. otherwise close ur forums We're not being paid to answer you, and these forums are not a "company" that exists to serve others. This is a meeting-space where all kinds of people can trade idea's. Consider it a public market :) I are Troll :suss:

Hi, If you want to send mail automatically without open website, you should create jobs and scheduler in sqlserver which will run everytime Farogh Haider Web developer

Thanks for the reply But i want to display ads exactly like below: Plz follow the link http://www.adspeed.com/Knowledges/15/Ad_Serving/Serving_Multiple_Ads_with_Single_Ad.html[^] Thank you

The Implementation is the same , for the Error that you are getting take Abhishek Sur advice and following the link Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Hi, Try Using this.... Protected Sub TvwPages_TreeNodeExpanded(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.TreeNodeEventArgs) Handles TvwPages.TreeNodeExpanded             If e.Node.Text = "Screens" And TvwPages.Nodes.Count > 1 Then                   TvwPages.Nodes(1).Collapse()             End If             If e.Node.Text = "Reports" And TvwPages.Nodes.Count > 1 Then                   TvwPages.Nodes(0).Collapse()             End If End Sub and..one thing...never say URGENT. It is completely irrelevent to others. Ramesh Sambari