C#

INSERT INTO Table_C<br />
                         (Name)<br />
SELECT DISTINCT Name<br />
FROM            Table_A<br />
WHERE        (Name NOT IN<br />
                             (SELECT DISTINCT Name<br />
                               FROM  Table_B AS Table_B_1))

sarang_k wrote:

Can you suggest me any method instead of using "dllimport and external"
methods.

File.Move("TXTFile_rfcyxt55efrem1fj4sycjv5527-04-2011_17h-4641_0.txt", "Entite1.txt");

code here

protected override void OnLoad(EventArgs e)
{
    string nacionalidad = "select * from cs_nacionalidad";
    try
    {
        //open connection
        bdConex.OpenConnection();
        //create command and assign the query and connection from the constructor
        MySqlDataAdapter da = new MySqlDataAdapter(nacionalidad, bdConex.conn);
        //create dataset
        DataSet ds = new DataSet();
        // filling dataset
        da.Fill(ds, "cs_nacionalidad");
        //dataset values
        cboNacionalidad.DataSource = ds.Tables["cs_nacionalidad"];
        cboNacionalidad.DisplayMember = "nm_nacionalidad";
        cboNacionalidad.ValueMember = "cd_nacionalidad";
        //close connection
        bdConex.CloseConnection();
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

public class NationSelector : ComboBox
{
    protected override void OnLoad(EventArgs e)
    {
        string nacionalidad = "select * from cs_nacionalidad";
        try
        {
            //open connection
            bdConex.OpenConnection();
            //create command and assign the query and connection from the constructor
            MySqlDataAdapter da = new MySqlDataAdapter(nacionalidad, bdConex.conn);
            //create dataset
            DataSet ds = new DataSet();
            // filling dataset
            da.Fill(ds, "cs_nacionalidad");
            //dataset values
            cboNacionalidad.DataSource = ds.Tables["cs_nacionalidad"];
            cboNacionalidad.DisplayMember = "nm_nacionalidad";
            cboNacionalidad.ValueMember = "cd_nacionalidad";
            //close connection
            bdConex.CloseConnection();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }
    }
}