I have C# web application that I want it to send out an email on a certain date, such as if equipment isn't returned on the day it was due. Data is in MS SQL database.
I've got all the email code already done, and I'm just curious how do I trigger this email, say after the COB on that particular day?
i have made application...that can have numbers of Event on Specified Date, So i want to code tat when time for event is arrived so tat automatically the participant get information about the event..so i want to send email to all participant before a day.
View 3 RepliesI need to create a form that would work like this Choose Provider :( user would select gmail, yahoo, hotmail, ext) Enter Name: ( user enters there name) Message : ( user enters message) and then the "submit"button.
View 2 RepliesHow It Possible Unpublished Record On Base Specific Time Like 22-03-2011 11:01 Pm All Record Are Unpublished It Is Possible From Sql Server Side.
View 2 RepliesI am building service failure notification system which notifies customers and management whenever there is a delay in the service. How can I use SQL SERVER trigger to send an email to a group of people when I add an alert in the alert database table using c#.
View 3 RepliesI'm using ASP.Net with VB (Visual Web Developer 2010) and SQL(Management Studio Express 2008) to create a website that keeps track of employee subscriptions.A date is entered into my database whenever an employee makes a subscription.I need to find a way to send an automatic email to each employee when the current date exceeds the subscription date by one year.
I am unable to use an SQL job as I only have SQL MS express.From other posts I have read it seems the best way to do this is to create a webservice to send emails but I am unsure of how to get the email address for each employee from the database to the web service?Do you guys think a web service is the best way to do this?
I need to send an email in asp.net but I need sender appears like "MySiteName" without info@[URL] need to send an email in asp.net but I need sender appears like "MySiteName" without info@[URL]
View 4 Repliesis it possible to convert string to date for the following line 2/8/2010 8:00PM (EST)
View 4 RepliesI m using ASP.NET and access as back end. I want to fatch a record between two specific date for that i
private void btnsearch_Click(object sender, EventArgs e)
{
cn.Open();
string str = "select Date1,Item,Rs,Payment from Books where Date1 BETWEEN '" + dateTimePicker1.Text + "' AND '" + dateTimePicker2.Text + "'";
cm = new System.Data.OleDb.OleDbCommand(str, cn);
System.Data.OleDb.OleDbDataReader r1;
r1 = cm.ExecuteReader();
while (r1.Read())
{
dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells[0].Value = r1[0].ToString();
dataGridView1.Rows[i].Cells[1].Value = r1[1].ToString();
dataGridView1.Rows[i].Cells[2].Value = r1[2].ToString();
dataGridView1.Rows[i].Cells[3].Value = r1[3].ToString();
i++;
}
cn.Close();
}
but it gives error Data type mismatch in criteria expression. table name is "book" fields are date1,item,rs,payment
I have a page in MVC where i want to take the email adddress as the input which can be of format like:"Jone Davi" <jone@gmail.com>, "Ben Miller" <ben@gmail.com>, "Jane Ton" <jane@gmail.com>,
Then from this I want to parse the valid emailaddress.But on click of the submit button getting error message" A potentially dangerous Request.Form value was detected from the client" Thus is there any way to take the input of email address in above format and bypass the security error for that specific page.
i have an requirment where an user can enter multiple email address.
The validation should ensure that he should enter address in the format "something@abc.com".
my existing validation ensures that some text is entered before "@" symbol and "abc.com" is the domain.
@"w+([-+.']w+)*@abc.com$";
I would need my regex to check for the delimiter ";" between two mail id's .
valid: a@abc.com |
a@abc.com;b@abc.com|
invalid: a@abc.comm | a@abc.com,b@abc.com | @abc.com |
a@abc.comb@abc.com|
I've tried many links but ther were of no use and i'd be grateful if someone could help me modify the current one to suit my requirments
I have website in the internet with many data in it. user search in data and filter it.
user save that filtering criteria. i want send email notification automatically to that user when new data inserted in site that match with saved filtering criteria.
i use asp.net and sql server 2008. i dont have dedicated server.
I am working on a .NET web application and I'm trying to use ajax CalendarExtender for the users to specify a specific date. For some reason, when I click the icon to display the calendar, the background seems to be transparent, shown below:
What could be the reason for this?
I've tried googling it but it seems nobody has worked it out yet.
I've also tried setting up it's z-index property to as high value as 5000000 but still doesn't work.
I have been struggling with this for a long time. I have a form in which there is a textbox using an ajax calender extender. Now, the problem is that, I want to take the Date value which is string format and format it to a specific date format before inserting it into the database. The following is the core problem:Dim MDate as string=txtMeetingDate.Textdim d as new Datetime ' I want to convert the d to a datetime using the Mdate/// The problem is that I don't know what's the date format in the TextBox because users can use any time format they want, it is based on their windows settings!!!
So, I am struggling to change my String (MDate) into a DateTime in the same format the user have and then convert it into my format:"dd/MM/yyyy" and after I have the date in the correct format, I want to change it back to string and save it in the database.I am doing this so that I have the same dateformat saved in my database.
how can I retrieve information when the user clicked on a specific link without opening a new web page? The information is stored in the database which is through web service. For example, when the user click on a specific link, e.g the date 28 February 2010, the datagrid will display the information on 28 February 2010.
View 3 RepliesIs there a way to put a button on a specific date in a calendar object? Specific dates in my website might have a lot of data that needs to be shown and I want to place a button on that date to open up a new webpage or make a panel visible with the information. Below is the calendar object and the dayrendering routine to place the current information in the calendar object.
[Code]....
Dim linkStr As String
e.Cell.BackColor = Drawing.Color.Red
linkStr = "<span style=""font-size:11pt; font-Weight:bold; color:white""><br />Error Loading Date: " & e.Day.Date & _
"<br /><br />Check Date and Re-Submit!"
e.Cell.Controls.Add(New LiteralControl(linkStr))
end sub
How to Automatically send birthday emails daily at specific time using in global.asax in asp.net without using windows services.
Firstly check and fetch all records of Students who have a Birthday today ....
Is it possible?
View 12 RepliesI have Data Entry Webform. Entries are saved in database with submission date.I am able to display report of specific date entries with their SUM in report footer.Now i want to display only Specific Date/Dates SUM only in report, not entries.I think it may be done by grouping. But i dont know how to do this.I am using vs2010 and crystal reports.
View 1 RepliesIn my registration form, there is field to enter email-id of member, i want to restrict user, so that he would not able to enter gmail, yahoo, radiff.... emailids is this possible.., Only company email id eg: priyanka@juncturetech.net must be allowed?
View 1 RepliesI'm writing a program that records time-in and time-out and I have a problem when trying to retrieve data for a specific date.In the table, the "timein" and "timeout" fields have format of "smalldatetime". To record the timein, I insert the system time (by using System.DateTime.Now) into the "timein" field.I want two types of searches.
1) Search records between a date range
2) Search records for a specific date
For example, First, I want to search if there are any records between 11/2/2010 and 12/1/2010. I will ask user to input "11/2/2010" as start date and "12/1/2010" as end date. I will use Convert.DateTime() methods to convert these two input before put them
into SQL query like:
"SELECT * FROM timesheet WHERE timein BETWEEN Convert.DateTime(startdate) AND Convert.DateTime(enddate)"
The output results do not include the date 11/2/2010 and 12/1/2010. I get only the dates in between. I know that is the limitation of BETWEEN. I wonder if someone has a way to work around this limitation.
Secondly, I want to prompt users to enter a specific date like (11/2/2010) and search the table for rows match that criteria. I can't get this to work. I have tried "SELECT * from timesheet WHERE timein LIKE '%searchdate%'", "......timein = 'searchdate'" but none works.
(I'm using VS 2010 C# and SQL 2008 for this project)
i have a data driven web application, in my database i have this datetime column,
and in my web application i have this gridview, but the only data that i need to display are the records with todays date until the past 6 days from today, so its like 7 days all in all.
i have done sending gridview data as excel to mail, it is working fine
then i had 5 columns in gridview but i want to send 4 column instead of 5 column.
protected void Button1_Click(object sender, EventArgs e)
{
fn_AttachGrid(); // here calling function to send mail gridview data as excel format
}
[Code]....
I have UpdatePanel with GridView and i want register posback triger for index changing and asyncpostback for pagging and sorting.
When registering AsyncPostback (with event) and Postback in one control i have ASP event.
How go around this problem? , dynami register triggers mayby is a solution but i can`t unregister triger.
How can i send an email certain days from now in C# (Win Forms). Say today is January 1 2010. Now i fix an appointment with doctor on January 10 2010. But i wish that a reminder email (regarding appointment) needs to be sent 3 days before (i.e. January 7 2010). I am having an email code with me.
My requirements: Visual Studio 2005, C# (vb would also do), WinForms (Windows based applications)
Let me know if anything from me is needed.