How to add the SQL Server data to each interval

Question

I have this code:

SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=SYNCLAPN136;Initial Catalog=Testdata;Integrated Security=True;Connect Timeout=30";
con.Open();

string command = "INSERT INTO [Table_1] (xName, yName) VALUES(@x, @y)";

SqlCommand cmd = new SqlCommand(command, con);
cmd.Parameters.Add("@x", date);
cmd.Parameters.Add("@y", val);

cmd.ExecuteNonQuery();
con.Close();

return date;

Those date and values are generated randomly..

I need to add the data to each 30 sec... how to achieve this?

Answer 1

If you are trying to just run this code every 30 seconds you can use a Timer object , this code must solve for you :

private static System.Timers.Timer t;
    static void Main(string[] args)
    {

        t = new System.Timers.Timer(new TimeSpan(0,0,0,30).TotalMilliseconds);
        t.Start();

    }


    public static void ExecuteSql()
    {
        using (SqlConnection con = new SqlConnection())
        {
            con.ConnectionString = "Data Source=SYNCLAPN136;Initial Catalog=Testdata;Integrated Security=True;Connect Timeout=30";
            con.Open();

            string command = "INSERT INTO [Table_1] (xName,yName) VALUES(@x,@y)";
            SqlCommand cmd = new SqlCommand(command, con);
            cmd.Parameters.Add("@x", date);
            cmd.Parameters.Add("@y", val);
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }

If the contents of the variables esteam in windows controls, this will be a problem , there will need access to otherwise these values.

Answer 2

If you are using ajax then use setInterval

setInterval(function(){ $.ajax({ type: "POST", url: "../../web/WebForm1.aspx/LiveData", data: JSON.stringify({ "date": dateVal, "val": rn }), contentType: "application/json; charset=utf-8", dataType: 'json', success: function (data) { console.log('success', data); }, error: function (jqXHR, textStatus, errorThrown) { alert('Exeption:' + errorThrown); } }); }, 30000);

Refer the post here Jquery/Ajax call with timer