Using the following line a new stopwatch object will be created:
System.Diagnostics.Stopwatch myStopWatch = newSystem.Diagnostics.Stopwatch();
myStopWatch.Start();
The "Stop" method will stop the stopwatch:
myStopWatch.Stop();
To display the value of the stopwatch then use the code shown below:
/// <summary>
/// To get the value of Hours../// </summary>
/// To get the value of Hours../// </summary>
myStopWatch.Elapsed.Hours.ToString();
/// <summary>
/// To get the value of Minutes../// </summary>
/// To get the value of Minutes../// </summary>
myStopWatch.Elapsed.Minutes.ToString();
/// <summary>
/// To get the value of Seconds..
/// To get the value of Seconds..
/// </summary>
myStopWatch.Elapsed.Seconds.ToString();
/// <summary>
/// To get the value of Milliseconds../// </summary>
MyStopWatch.Elapsed.Milliseconds.ToString();
Main Code :
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;
namespace MyBlog{
public partial class Form1 : Form {
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
System.Diagnostics.Stopwatch myStopWatch = newSystem.Diagnostics.Stopwatch();
public partial class Form1 : Form {
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
System.Diagnostics.Stopwatch myStopWatch = newSystem.Diagnostics.Stopwatch();
//Start StopWatch... myStopWatch.Start();
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myDatabase.mdf;Integrated Security=True;User Instance=True");
SqlDataReader dr;
try {
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT StudName FROM Student WHERE StudId=1", conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
//it will display Name of Student whose Id is "1"... mytxtName.Text = dr.GetValue(0).ToString();
}
//Stop StopWatch... myStopWatch.Stop();
SqlDataReader dr;
try {
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT StudName FROM Student WHERE StudId=1", conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
//it will display Name of Student whose Id is "1"... mytxtName.Text = dr.GetValue(0).ToString();
}
//Stop StopWatch... myStopWatch.Stop();
//Display time which taken to load resulted data in textbox in messagebox... MessageBox.Show("Time Taken : " + myStopWatch.Elapsed.Hours.ToString() + " : " + myStopWatch.Elapsed.Minutes.ToString() + " : " + myStopWatch.Elapsed.Seconds.ToString() + " : " + myStopWatch.Elapsed.Milliseconds.ToString());
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally {
conn.Close();
}
}
}
}
READ MORE>>
http://www.c-sharpcorner.com/UploadFile/9f4ff8/6898/
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally {
conn.Close();
}
}
}
}
READ MORE>>
http://www.c-sharpcorner.com/UploadFile/9f4ff8/6898/
0 comments:
Post a Comment