Open multiple url with a Time Interval on Button Click in Windows Application using C#

Hi adpkg,

Please check with the below code.

SQL

CREATE PROC OpenUrl
AS
BEGIN
	DECLARE @OpenUrl AS TABLE (ID INT IDENTITY,URL VARCHAR(1000))
	INSERT INTO @OpenUrl VALUES ('http://www.aspforums.net/')
	INSERT INTO @OpenUrl VALUES ('http://www.aspsnippets.com/')
	INSERT INTO @OpenUrl VALUES ('http://www.jqueryfaqs.com/')
	SELECT * FROM @OpenUrl
END

Code

public List<string> urls { get; set; }
private int counter;
public Form1()
{
    InitializeComponent();
}
private void btnStart_Click(object sender, EventArgs e)
{
    counter = 0;
    timer1.Tick += new EventHandler(timer1_Tick);
    timer1.Interval = 1 * 5 * 1000;
    timer1.Start();
}
private void timer1_Tick(object sender, EventArgs e)
{
    label1.Text = DateTime.Now.ToShortDateString().ToString();
    if (counter >= urls.Count)
    {
        timer1.Stop();
    }
    else
    {
        string currentUrl = urls[counter];
        mybrowser.Navigate(currentUrl);
        counter++;
        timer1.Interval = 1 * 5 * 1000;
    }
}
private void btnstop_Click(object sender, EventArgs e)
{
    timer1.Stop();
}
private List<string> GetUrls()
{
    string str = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    SqlConnection con = new SqlConnection(str);
    SqlCommand cmd = new SqlCommand("OpenUrl", con);
    con.Open();
    cmd.CommandType = CommandType.StoredProcedure;
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill(dt);
    List<string> urls = new List<string>();
    foreach (DataRow dr in dt.Rows)
    {
        urls.Add(dr["URL"].ToString());
    }
    return urls;
}
private void Form1_Load(object sender, EventArgs e)
{
    urls = GetUrls();
}

Hi adpkg,

If you want to continue the sliding of ulrs then instead of writting timer1.Stop() set the counter to zero(0) like below and remove the timer1.Stop().

if (counter >= urls.Count)
    {
        counter = 0;
        //timer1.Stop();
    }

I hope this will help you out.