درج اطلاعات بصورت پی دی پی در بانک اطلاعاتی SQL SERVER:
ابتدا اسکریپت زیر را در SQL SERVER اجرا کنید تا جدول زیر ساخته شود:
CREATE TABLE [dbo].[RepositoryWeight](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[BasculNumber] [tinyint] NULL,
[Data] [datetime] NULL,
[Weight] [decimal](10, 0) NULL,
CONSTRAINT [PK_RepositoryWeight] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
در ویژال استادیو یک پروژه کنسول اپلیکشن باز کرده و کد زیر را در آن درج می کنیم:
public static void Main()
{
System.Timers.Timer aTimer = new System.Timers.Timer();
aTimer.Elapsed+=new ElapsedEventHandler(OnTimedEvent);
aTimer.Interval=5000;
aTimer.Enabled=true;
}
// Specify what you want to happen when the Elapsed event is raised.
private static void OnTimedEvent(object source, ElapsedEventArgs e)
{
using (SqlConnection connection = new SqlConnection("Server =.; Database =TozinServiceDB; UID =sa; PWD =0000"))
{
SqlCommand cmd = new SqlCommand("INSERT INTO RepositoryWeight (BasculNumber, Weight) VALUES (@BasculNumber, @Weight)");
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@BasculNumber", 1);
cmd.Parameters.AddWithValue("@Weight",0);
connection.Open();
cmd.ExecuteNonQuery();
}
}:منبع
http://stackoverflow.com/questions/12535722/what-is-the-best-way-to-implement-a-timer?answertab=active#tab-top