반응형
using System.Data.OleDb;

string connectionString = "Provider=CUBRIDProvider;location=127.0.0.1;Data Source=test_db;User ID=userid;Password=password;Cache Authentication=False;Encrypt Password=False;Mask Password=False;Persist Encrypted=False;Persist Security Info=True;Port=30000;Fetch Size=100";

OleDbConnection conn = null;
OleDbDataAdapter adp = null;

DataTable dt = null;

try
{
conn = new OleDbConnection(connectionString);
conn.Open();
adp = new OleDbDataAdapter(conn.CreateCommand());
adp.SelectCommand.CommandText = "select * from usr_info";
dt = new DataTable();
adp.Fill(dt);

DataGrid.DataSource = dt;
DataGrid.DataBind();
}
catch { }
finally
{
if (conn != null)
        conn.Close();
}
-----------------------------------------------------------------------------------------------------------------

간단한 큐브리드 예제이다. 

+ Recent posts