반응형
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();
}
-----------------------------------------------------------------------------------------------------------------
간단한 큐브리드 예제이다.