TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sara Code
NA
10
697
Newsletter windows application or windows service
Nov 4 2016 11:41 AM
Hello all,
I want to make a newsletter software that runs on all the PCs once there is a news or update it will popup a form containing the updates
what i've acheived till now is
two form one is the main form that invoke the popup form, the sequence of my code is :
1- main from load the popup form and then hide it
2- press button to start the program and it will hide the main
3- at event of button click while(1) and check every minute if the SQL table has news inside it or not
4- if there is a news it will show the popup form for 1 minute after that it hide it
5- the continue running and repeats
what I am asking for is what is the knowledge that I need in order to reliable software
and instead of while(1) how to trigger the software to popup the form when there is anything in the SQL table ? and finally is there any similar open source software that do what I need or something alike?
here is my code:
public partial class Form1 : Form
{
ClassMasterData cMaster = new ClassMasterData();
DataTable dtNewFeed;
Form_Popup news;
int always = 1;
public Form1()
{
InitializeComponent();
news = new Form_Popup();
news.Show();
news.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
TimeSpan interval = new TimeSpan(0, 1, 0);
this.Visible = false;
while (always == 1)
{
System.Threading.Thread.Sleep(1 * 60 * 1000);
dtNewFeed = cMaster.Select_DailyNews();
if (dtNewFeed.Rows.Count != 0)
{
news.Reformat(int.Parse(dtNewFeed.Rows[0]["nType"].ToString()), dtNewFeed.Rows[0]["strMessage"].ToString(), null);
news.Show();
news.Refresh();
//NativeMethods.BlockInput(interval);
System.Threading.Thread.Sleep(1 * 60 * 1000);
news.Hide();
news.Refresh();
}
}
}
Reply
Answers (
1
)
creating pivot table using NPOI C#
selecting data from datalist and display on modal