Wednesday, October 28, 2009
Circket Inivetison Card
Nature? AGAR
Marta de Menezes. "Nature?" Live anynana Bicyclus butterfly with modified wing pattern,
2000.
Can I Return My Used Car Iv Nevada
How Can You Tell If An Escort Has Std
Tuesday, October 27, 2009
Free Tiffany Towers Streaming
His work has oriented field of human-machine relationship and the various options currently provides us with this relationship, focusing its research spectrum in the social context of technology in Latin America.
Since 2004 it has developed in the field of research and teaching relationship Arts - Science-Technology, specializing in the area of \u200b\u200bbio-art, teaching courses and coordinating science research body. Has worked with various print media culture, new technologies and science
.
is currently Curator of International Performance Samples and Documentation Center Coordinator at Ex Teresa Arte Actual.
Wednesday, October 14, 2009
Riccar Vacuum Versus Dyson Vacuum
Connect PostgreSQL with some application in Visual Studio (Visual C # Used in)
Connect PostgreSQL to any application in Visual Studio (used in Visual C #)
STEP 1.
PostgreSQL Download the official website, http://www.postgresql.org. I leave as
version MIRROR PostgreSQL-8.3.1-1:
http://www.mediafire.com/?z32jjwegk2w
STEP 2.
Once you have installed the graduate will need the NpgSQL2, you can download from: http://npgsql.projects.postgresql.org/
and extract the ZIP file find file: Npgsql.dll which is the library that we use.
STEP 3. We will use
PgAdmin III, which is generally available with PostgreSQL. The interface is very intuitive. If you have more questions visit the PostgreSQL documentation here: http://www.postgresql.org/docs/8.3/interactive/index.html
STEP 4. Creating
database.
example we have the following script: CREATE TABLE simple_table
(
id integer NOT NULL, - SERIAL if identity-like Functionality like
tekst character varying (50),
simple_table_pkey CONSTRAINT PRIMARY KEY (id)
)
WITH (OIDS = FALSE);
simple_table ALTER TABLE OWNER TO adrian - my user
- Polish and drop letters so i do not have to worry about codepage
simple_table INSERT INTO (id, text) VALUES (1, 'what the text');
INSERT INTO simple_table (id, text) VALUES (2, 'what other text');
simple_table INSERT INTO (id, text) VALUES (3, 'another text');
Usando el Postgre EN VISUAL C #.
En un aplicación nueva de windows, como referencia Npgsql.dll aggregates, como se muestra en la imagen:
PASO 5th Una cadena de
CONEXION couple POSTGREE se hare con la Palabra clave y el valor (keyword = value). Los principales son:
Server - specifies the server location
User Id - the database user
Port - default is 5432
Password - the password for the database user
Database - the database name
APLICACION SIMPLE:
using Npgsql;
namespace PostgreSQLTEst
{
public partial class Form1 : Form
{
private DataSet ds = new DataSet();
private DataTable dt = new DataTable();
public Form1()
{
InitializeComponent();
}
private void llOpenConnAndSelect_LinkClicked(object sender,
LinkLabelLinkClickedEventArgs e)
{
try
{
// PostgeSQL-style connection string
string connstring = String.Format("Server={0};Port={1};" +
"User Id={2};Password={3};Database={4};",
tbHost.Text, tbPort.Text, tbUser.Text,
tbPass.Text, tbDataBaseName.Text );
// Making connection with Npgsql provider
NpgsqlConnection conn = new NpgsqlConnection(connstring);
conn.Open();
// quite complex sql statement
string sql = "SELECT * FROM simple_table";
// data adapter making request from our connection
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);
// i always reset DataSet before i do
// something with it.... i don't know why :-)
ds.Reset();
// filling DataSet with result from NpgsqlDataAdapter
da.Fill(ds);
// since it C# DataSet can handle multiple tables, we will select first
dt = ds.Tables[0];
// connect grid to DataTable
dataGridView1.DataSource = dt;
// since we only showing the result we Do not Need Anymore
connection conn.Close ();
} catch (Exception msg) {
/ / Something Went Wrong, and you want to know why
MessageBox.Show (msg.ToString ());
throw;}
}}}
and as a result we have:
http://www.codeproject.com/KB/database/afppostgresqlintro/working_example.jpg
And that's all ...
Connect PostgreSQL to any application in Visual Studio (used in Visual C #)
STEP 1.
PostgreSQL Download the official website, http://www.postgresql.org. I leave as
version MIRROR PostgreSQL-8.3.1-1:
http://www.mediafire.com/?z32jjwegk2w
STEP 2.
Once you have installed the graduate will need the NpgSQL2, you can download from: http://npgsql.projects.postgresql.org/
and extract the ZIP file find file: Npgsql.dll which is the library that we use.
STEP 3. We will use
PgAdmin III, which is generally available with PostgreSQL. The interface is very intuitive. If you have more questions visit the PostgreSQL documentation here: http://www.postgresql.org/docs/8.3/interactive/index.html
STEP 4. Creating
database.
example we have the following script: CREATE TABLE simple_table
(
id integer NOT NULL, - SERIAL if identity-like Functionality like
tekst character varying (50),
simple_table_pkey CONSTRAINT PRIMARY KEY (id)
)
WITH (OIDS = FALSE);
simple_table ALTER TABLE OWNER TO adrian - my user
- Polish and drop letters so i do not have to worry about codepage
simple_table INSERT INTO (id, text) VALUES (1, 'what the text');
INSERT INTO simple_table (id, text) VALUES (2, 'what other text');
simple_table INSERT INTO (id, text) VALUES (3, 'another text');
Usando el Postgre EN VISUAL C #.
En un aplicación nueva de windows, como referencia Npgsql.dll aggregates, como se muestra en la imagen:
PASO 5th Una cadena de
CONEXION couple POSTGREE se hare con la Palabra clave y el valor (keyword = value). Los principales son:
Server - specifies the server location
User Id - the database user
Port - default is 5432
Password - the password for the database user
Database - the database name
APLICACION SIMPLE:
using Npgsql;
namespace PostgreSQLTEst
{
public partial class Form1 : Form
{
private DataSet ds = new DataSet();
private DataTable dt = new DataTable();
public Form1()
{
InitializeComponent();
}
private void llOpenConnAndSelect_LinkClicked(object sender,
LinkLabelLinkClickedEventArgs e)
{
try
{
// PostgeSQL-style connection string
string connstring = String.Format("Server={0};Port={1};" +
"User Id={2};Password={3};Database={4};",
tbHost.Text, tbPort.Text, tbUser.Text,
tbPass.Text, tbDataBaseName.Text );
// Making connection with Npgsql provider
NpgsqlConnection conn = new NpgsqlConnection(connstring);
conn.Open();
// quite complex sql statement
string sql = "SELECT * FROM simple_table";
// data adapter making request from our connection
NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);
// i always reset DataSet before i do
// something with it.... i don't know why :-)
ds.Reset();
// filling DataSet with result from NpgsqlDataAdapter
da.Fill(ds);
// since it C# DataSet can handle multiple tables, we will select first
dt = ds.Tables[0];
// connect grid to DataTable
dataGridView1.DataSource = dt;
// since we only showing the result we Do not Need Anymore
connection conn.Close ();
} catch (Exception msg) {
/ / Something Went Wrong, and you want to know why
MessageBox.Show (msg.ToString ());
throw;}
}}}
and as a result we have:
http://www.codeproject.com/KB/database/afppostgresqlintro/working_example.jpg
And that's all ...
Subscribe to:
Comments (Atom)