C#

ExcelFile ef = ExcelFile.Load(HttpContext.Current.Server.MapPath("~/Resources/query.xlsx"));

I want to ping a list of IPs but it's not working.

I already use this function in console app and it was working.

<pre>string[] addresses = { "192.168.1.2", "192.168.1.3", "192.168.1.4" };
    void show()
    {
        List<Task<PingReply>> pingTasks = new List<Task<PingReply>>();
        foreach (var address in addresses)
        {
            pingTasks.Add(PingAsync(address));
        }

        Task.WaitAll(pingTasks.ToArray());
        int i = 0;
        listView1.Clear();
        listView1.Columns.Add("Device IP", 100);
        listView1.Columns.Add("ping", 60);
        foreach (var pingTask in pingTasks)
        {
            string[] A = { addresses[i], pingTask.Result.RoundtripTime.ToString() };
            ListViewItem item = new ListViewItem(A);
            listView1.Items.Add(item);
        }
    }

    Task<PingReply> PingAsync(string address)
    {
        var tcs = new TaskCompletionSource<PingReply>();
        Ping ping = new Ping();
        ping.PingCompleted += (obj, sender) =>
        {
            tcs.SetResult(sender.Reply);
        };
        ping.SendAsync(address, new object());
        return tcs.Task;
    }

I'm working on dataGrid Save content based on SQL Server data, C # smart devices and I have all the code I do not make mistake but not save data

 /////////////////inicio guardar 
               //cadena de conexion
string partDir = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
string partBD = System.IO.Path.Combine(partDir, "embarque.sdf");
string connectionstring = string.Format(@"DataSource={0}; Password ='root'", partBD);

try
{
	using (SqlCeConnection con = new SqlCeConnection(connectionstring))
	{
		string ConsultaSQL = "INSERT INTO ENVIO VALUES(@RAID, @NPARTE, @CANTIDAD, @VENTANA, @LIDER, @FECHA)";
        
		foreach (DataRow row in dt.Rows)
		{
            SqlCeCommand cmd = new SqlCeCommand(ConsultaSQL, con);
			
			cmd.Parameters.Clear();

			cmd.Parameters.AddWithValue("@RAID", Convert.ToString(row["Raid"].ToString()));
			cmd.Parameters.AddWithValue("@NPARTE", Convert.ToString(row["Nparte"].ToString()));
			cmd.Parameters.AddWithValue("@CANTIDAD", Convert.ToString(row["Cantidad"].ToString()));
			cmd.Parameters.AddWithValue("@VENTANA", Convert.ToString(row["Ventana"].ToString()));
			cmd.Parameters.AddWithValue("@LIDER", Convert.ToString(row["Lider"].ToString()));
			cmd.Parameters.AddWithValue("@FECHA", Convert.ToString(row["Fecha"].ToString()));
			
			con.Open();

			cmd.ExecuteNonQuery();
            
            con.Close();
	   }
      
	}	
   
	MessageBox.Show("Datos Agregados");
    
}
catch (Exception ex)
{
	MessageBox.Show(ex.Message);
}
              ///////////////fin guardado

<KnownElement>
Here is some text <c>This is important text</c> here is some more text <c>Yet more important text stuff</c> more text
</KnownElement>

public class KnownElement
   {
       [XmlAnyElement]
       public XmlElement[] DocumentNodes { get; set; }

       [XmlText]
       public string[] Text { get; set; }
    }

try
            {
                var newProcessInfo = new System.Diagnostics.ProcessStartInfo();
                newProcessInfo.FileName = @"C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe";
                newProcessInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
                newProcessInfo.Verb = "runas";
                newProcessInfo.Arguments = @"-executionpolicy unrestricted -Command "".\power\gwx\uninstallgwx.bat""";
                System.Diagnostics.Process.Start(newProcessInfo);
                MessageBox.Show("Windows 10 Updater uninstalled");

            }
            catch
            { }