<style> .CssStyle1 { FONT: 700 12pt verdana; COLOR: yellow } </style> string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source= c:\\Patients2000.mdb"; string sqlStr = "SELECT * FROM Patients"; System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(conStr); DataSet ds = new DataSet(); System.Data.OleDb.OleDbDataAdapter daCust = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn); daCust.Fill(ds); FpSpread1.DataSource = ds; FpSpread1.ActiveSheetView.AllowColumnMove = true; FpSpread1.ActiveSheetView.GroupBarVisible = true; FpSpread1.ActiveSheetView.AllowGroup = true; FpSpread1.DragColumnCssClass = "CssStyle1";
<style> .CssStyle1 { FONT: 700 12pt verdana; COLOR: yellow } </style> Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source= c:\Patients2000.mdb" Dim sqlStr As String = "SELECT * FROM Patients" Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(conStr) Dim ds As DataSet = New DataSet Dim daCust As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn) daCust.Fill(ds) FpSpread1.DataSource = ds FpSpread1.ActiveSheetView.AllowColumnMove = True FpSpread1.ActiveSheetView.GroupBarVisible = True FpSpread1.ActiveSheetView.AllowGroup = True FpSpread1.DragColumnCssClass = "CssStyle1"