Using DataGrid with OleDB

[Hoang Dung]

I'm use an OleDbDataReader variable for get data from OLAP cube. I want show this data to DataGrid control, but I don't know a way. Can you help me? Thanks.

[dynamic]

here's an example of adding data from a database to a datagrid ( using an OleDbConnection ) VbCode:

---

Private Sub Button1\_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click   
     Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/bin.mdb"   
     Dim strCommand As String = "SELECT \* FROM binFrm"   
     OpenAccess(strConnection, strCommand)   
 End Sub   

 Public Function OpenAccess(ByVal strConn As String, ByVal strComm As String)   
     Dim DBCon As New OleDbConnection(strConn)   
     DBCon.Open()   
     Dim DBCommand As New OleDbCommand(strComm, DBCon)   
     Dim DBAdapt As OleDbDataAdapter   
     DBAdapt = New OleDbDataAdapter(DBCommand)   
     Dim DBset As New DataSet()   
     DBAdapt.Fill(DBset, "binFrm")   
     DataGrid1.DataSource = DBset.Tables("binFrm") '///add the tabel "binfrm" to the datagrid   
     DBCon.Close()   
     DBCommand.Dispose()   
     DBAdapt.Dispose()   
     DBset.Dispose()   
 End Function   

---

not sure if that's what your after , but hope it helps :) Vb:

---

Public Function TwinsOnWay(ByVal twins As String) As String
Se

[dynamic]

oops that the vb.net version lol , i'll try to bung a C# version together Vb:

---

Public Function TwinsOnWay(ByVal twins As String) As String
Select Case twins
Case "Gender"
Return "Two Girls"
End Select
End Function

---

[dynamic]

here ya go , this time in C# lol , hope it helps VbCode:

---

private void button1_Click(object sender, System.EventArgs e)
{
string strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "C:/bin.mdb";
string strCommand = "SELECT * FROM binFrm";
OpenAccess(strConnection, strCommand);
}

public void OpenAccess(string Connection, string Command)
{
OleDbConnection DBCon=new OleDbConnection(Connection);
DBCon.Open();
OleDbCommand DBCommand=new OleDbCommand(Command, DBCon);
OleDbDataAdapter DBAdapt=new OleDbDataAdapter(DBCommand);
DataSet DBset=new DataSet();
DBAdapt.Fill(DBset, "binFrm");
dataGrid1.DataSource=DBset.Tables["binFrm"];
DBCon.Close();
DBCommand.Dispose();
DBAdapt.Dispose();
DBset.Dispose();

}   

---

:) Vb:

---

Public Function TwinsOnWay(ByVal twins As String) As String
Select Case twins
Case "Gender"
Return "Two Girls"
End Select
End Function

---

[Khang Nguyen]

Hoang Dung, the following is not the best code on the globe but hope it gives you some ideas. // construct table for Tasks grid and define columns m_dtTasks = new DataTable("Tasks"); m_dtTasks.Columns.Add("Task Name", typeof(string)); m_dtTasks.Columns.Add("Frame Maker Location", typeof(string)); m_dtTasks.Columns.Add("Approved", typeof(string)); m_dtTasks.Columns.Add("Approval Cycle", typeof(string)); OleDbCommand cmd = new OleDbCommand(sSelectQuery, conn); // have yr query & connection ready OleDbDataReader reader = cmd.ExecuteReader(); // DataReader is now loaded with data while(reader.Read()) { nNumRowsAffected++; Console.WriteLine("TaskName = " + reader.GetString(0)); sTaskName = reader.GetString(0); // TaskName sFrameMakerLoc = reader.GetString(3); // FrameMakerLocation sApproved = (reader.GetBoolean(11) ? "Y" : "N"); // Status sApprovalCycle = reader.GetString(12); // Approval_Cycle // construct a new data row drTask = dtTasks.NewRow(); drTask["Task Name"] = sTaskName; drTask["Frame Maker Location"] = sFrameMakerLoc; drTask["Approved"] = sApproved; drTask["Approval Cycle"] = sApprovalCycle; // add new row to table dtTasks.Rows.Add(drTask); } dgdTask.DataSource = dtTasks; // attach data source to grid Hope it helps Khang Nguyen ;)