C#

public void Consulta()
       {
           //MessageBox.Show(grid_lic.CurrentRow.Cells[3].Value.ToString());
           con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=192.168.19.78; database=licenciamento; uid=estagio; password=1234; option = 3 ");
           con.Open();

           OdbcCommand Command = con.CreateCommand();
           Command.CommandText = "select lojas.Id, lojas.NIF, lojas.Loja, lojas.Bloquear, lojas.DataFim, lojas.lastupdate, lojas.Nome, " +
           " licenciamentoloja.EArtigo, licenciamentoloja.EFamilia, licenciamentoloja.EClientes, licenciamentoloja.EFornecedores, licenciamentoloja.Evendas," +
           "licenciamentoloja.ECompras, licenciamentoloja.EStocks, licenciamentoloja.ELiquidacao, licenciamentoloja.ECaixas, licenciamentoloja.EInfoStock," +
           "licenciamentoloja.ZSArtigos, licenciamentoloja.ZSClientes, licenciamentoloja.ZSStocks, licenciamentoloja.id from lojas inner join licenciamentoloja on lojas.NIF = licenciamentoloja.NIF and lojas.Loja = licenciamentoloja.loja";

           Command.CommandType = CommandType.Text;
           Command.Connection = con;

           OdbcDataAdapter adapter = new OdbcDataAdapter(Command);
          

           DataSet ds = new DataSet();
           adapter.Fill(ds,"temp");
           grid_lic.DataSource = ds;
           grid_lic.DataMember = ds.Tables[0].TableName;

gautamkhatri428 wrote:

This application needs to fetch data from some other PC

gautamkhatri428 wrote:

it is possible in WCF to send data from server to client and vice versa .. simultaneously ?

gautamkhatri428 wrote:

socket programming requires ssl certificate

var folder = await StorageFolder.GetFolderFromPathAsync(Windows.ApplicationModel.Package.Current.InstalledLocation.Path + @"\");
StorageFile file = await folder.GetFileAsync(url);

// defining the ListBox Items in code   
private List<string> listItemData = new List<string>
{
    "one","two","three","two","five","six","seven","two","nine","ten"
};

// setting the DataSource property of the ListBox to use the List<string>
private void Form1_Load(object sender, EventArgs e)
{
    listBox1.DataSource = listItemData;
}

// creating a method to do substitution
private void ReplaceInListBox(string toFind, string toReplace, bool replaceOneItemOnly)
{
    int ndx;
    string itm;

    for (int i = 0; i < listItemData.Count; i++)
    {
        itm = listItemData[i];

        if (itm == toFind)
        {
            ndx = listItemData.IndexOf(itm);
            listItemData.RemoveAt(ndx);
            listItemData.Insert(ndx, toReplace);

            if (replaceOneItemOnly) break;
        }
    }

    // necessary to reset the DataSource
    // in order to refresh it
    listBox1.DataSource = null;
    listBox1.DataSource = listItemData;
    listBox1.Invalidate();
}

// test like this:
private void SomeButton_Click(object sender, EventArgs e)
{
    ReplaceInListBox("two", "twenty", false);
}