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();
}