FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : AutoGenerateColumns Property |
'Declaration Public Property AutoGenerateColumns As Boolean
'Usage Dim instance As SheetView Dim value As Boolean instance.AutoGenerateColumns = value value = instance.AutoGenerateColumns
public bool AutoGenerateColumns {get; set;}
FarPoint.Web.Spread.SheetView sv; sv = FpSpread1.ActiveSheetView; string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source= d:\\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 da = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn); da.Fill(ds); sv.DataSource = ds; sv.AutoGenerateColumns = false; sv.Columns[0].DataField = "HospNo"; sv.Columns[1].DataField = "LName";
Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source= d:\Patients2000.mdb" Dim sqlStr As String = "SELECT * FROM Patients" Dim conn As New System.Data.OleDb.OleDbConnection(conStr) Dim ds As DataSet = New DataSet Dim da As New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn) da.Fill(ds) sv.DataSource = ds sv.AutoGenerateColumns = False sv.Columns(0).DataField = "HospNo" sv.Columns(1).DataField = "LName"
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6