C#

using System;
using System.Collections.Generic;
using System.Text;
using System.Management;
using System.IO.Ports;
using System.Threading;

namespace ConsoleApplication4
{
    class Program
    {
        //use the function
        [STAThread]
        static void Main()
        {
            int Numero;
            Numero = 37924300;
            string classname = "Win32_POTSModem"; // for modems
            //Win32_Service use this as class name it will list the services 
            //Win32_Processor for CPU info
            // and many more are there 
            string strMachine = "."; //your machine name 

            System.Management.ObjectQuery oQuery;
            System.Management.ManagementScope oScope;
            System.Management.ManagementObjectSearcher oSearcher;
            string strSQL;
            //int I = 0;
            try
            {
                strSQL = "Select * from " + classname;
                oQuery = new ObjectQuery(strSQL);
                oScope = new ManagementScope(@"\\" + strMachine + @"\root\cimv2");
                oSearcher = new ManagementObjectSearcher(oScope, oQuery);
                foreach (ManagementObject oService in oSearcher.Get())
                {
                    if (!oService.GetPropertyValue("DeviceID").ToString().Contains("Modem"))
                    {
                        Console.WriteLine(oService.GetPropertyValue("AttachedTo"));
                        Console.WriteLine(oService.GetPropertyValue("Name"));
                        Console.WriteLine(oService.GetPropertyValue("DeviceID"));
                        // Console.WriteLine(oService.ToString());


                        SerialPort modem1 = new SerialPort(oService.GetPropertyValue("AttachedTo").ToString(), 9600, Parity.None, 8, StopBits.One);


                        Console.Write("Try call on modem " + oService.GetPropertyValue("Name").ToString());
                        //Console.ReadKey();
                        // Begin communications 
                        while (modem1.IsOpen)
                        {
                            modem1.Close();
                            Thread.Sleep(1000);
                        }
                        modem1.Open();

                        modem1.NewLine = "\n";
                        Console.WriteLine(modem1.ToString());
                        Console.WriteLine(modem1.PortName);
                        Console.WriteLine(modem1.NewLine.ToString());
                        Console.WriteLine(modem1.IsOpen.ToString());
                        Console.WriteLine(modem1.ReadExisting());

                        modem1.Open();
                        modem1.ReadTimeout = 100000;
                        modem1.NewLine = "\r";
                        modem1.WriteLine("ATZ"); // reset the modem
                        Console.Write("reset the modem");
                        //Console.ReadKey();
                        modem1.ReadTo("OK\r\n"); // wait for "OK" from modem
                        Console.Write("wait for OK from modem");
                        // Console.ReadKey();
                        modem1.WriteLine("ATHDT " + Numero + "@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1@1"); // dial number with dialtone
                        Console.Write("Discando para o numero " + Numero);
                        //Console.ReadKey();
                        string response = modem1.ReadTo("\r").Trim(); // read until first newline
                        Console.Write("Read status modem " + response);
                        //Enter an application loop to keep this thread alive
                        //Application.Run();
                        int i = 0;

                         // I need wait 15 minutes in call
                        while (i < 900000)
                        {
                            // Attach a method to be called when there	  // is data waiting in the port's buffer
                            //modem1.DataReceived += new SerialDataReceivedEventHandler();
                            Console.WriteLine(modem1.ReadExisting());
                            i++;
                        }
                        modem1.Close();

                        Console.WriteLine();
                        Console.Write("Disconnect call " + modem1.PortName);
                        Console.ReadKey();


                    }
                }
                Console.WriteLine("Write call number");
                Console.ReadKey();
           }
            catch (Exception ex)
            {
               Console.WriteLine(ex.Message);
               Console.ReadKey();
            }







            //public void port_DataReceived(object sender, SerialDataReceivedEventArgs e, String modem)
            //{
            //    // Show all the incoming data in the 7port's buffer
            //    Console.WriteLine(modem1.ReadExisting());
            //}
        }
    }

}

private void PaintControl(Control sender, PaintEventArgs e, String Color1, String Color2, float Angle)
{
    Graphics g = sender.CreateGraphics();
    // and continue with the rest.....
}

kruegs35 wrote:

but I am getting is null.

private void CopyData(DataTable table, string tablename)
        {
            SqlDataAdapter da = new SqlDataAdapter("select * from " + tablename, cLocalConnect);
            SqlCommandBuilder cBuilder = new SqlCommandBuilder(da);
            DataSet ds = new DataSet();
            DataTable dt = new DataTable("table1");
            ds.Tables.Add(dt);
 
            da.Fill(ds, "table1");
 
            dt = table.Copy();
			
			cBuilder.GetUpdateCommand(); // myChange
 
            da.Update(ds);
        }

kruegs35 wrote:

that does not return any key column information