示例#1
0
        public void PegarFornecedor()
        {
            DataSet ds = new DataSet();

            try
            {
                this.conn = new NpgsqlConnection(this.connString);

                //Abra a conexão com o PgSQL
                this.conn.Open();

                string buscar = String.Format("Select id, cnpj, nome, nome_usuario, endereco, telefone, email, senha from usuario where id = {0}", AutenticacaoCliente.pegarId());

                using (NpgsqlCommand pgsqlcommand = new NpgsqlCommand(buscar, this.conn))
                {
                    //pgsqlcommand.Fill(dt);
                    NpgsqlDataReader dr = pgsqlcommand.ExecuteReader();

                    if (dr.HasRows)
                    {
                        if (dr.Read())
                        {
                            AutenticacaoCliente.Fornecedor(dr.GetInt32(0), dr.GetInt64(1).ToString(), dr.GetString(2), dr.GetString(3), dr.GetString(4), dr.GetString(5), dr.GetString(6), dr.GetString(7));
                        }
                    }
                    else
                    {
                        Console.WriteLine("Não funcionou!");
                    }
                }
            }
            catch (NpgsqlException ex)
            {
                throw ex;
                //return dt.ToString();
            }
            catch (Exception ex)
            {
                throw ex;
                //return dt.ToString();
            }
            finally
            {
                this.conn.Close();
            }
        }