Get Database data using c#

[ghjk]

I'm new to c# and didn't write any c# code yet. I'm using postgres database. I want to connect to postgres and retriew some data to test my database connectivity. This is my code.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Npgsql;

namespace PostgreSQLTEst
{
    public partial class Form1 : Form
    {
       		
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                // PostgeSQL-style connection string
                string connstring = String.Format("Server=xxx;Port=xxx;User Id=xxx;Password=xxx;Database=xxx;");
              
                // Making connection with Npgsql provider
                NpgsqlConnection conn = new NpgsqlConnection(connstring);
                conn.Open();
               
                string sql = "SELECT * FROM simple_table";
               conn.Close();
            }
            catch (Exception msg)
            {
            
                MessageBox.Show(msg.ToString());
                //throw;
            }

        }
    }
}

[tlhintoq]

You have described no problem, error, exception or issue.
You have asked no question. What is it you need of the volunteers here?

Database How two parts 1 and 2

http://bytes.com/topic/net/insights/635615-how-use-database-your-program

http://bytes.com/topic/net/insights/817960-how-use-database-your-program-part-ii

[cloud255]

You create a connection, you open it, create the query you want to use and then close the connection. You are missing only one step:
You need to create a NpgsqlCommand and assign your query to the CommandText member, then call the command with the ExecuteReader method.