Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Learn how Concerto can help you.
create a table, add columns
myfile = "c:\..\..\some.csv"
while not eof(myfile)
l = ReadLine(myfile) ' get a line
v = l.split(",") ' split the line to columns
r = new tbl.datarow ' create a row to hold the line values
for i = 0 to 10 r(i)=v(i) ' put all values into the new row
tbl.add(r) ' add new row to the table
now you can bind this to your grid...
Open in new window
Dim fi As New FileInfo(OpenFileDialog1.FileName)
Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Text;Data Source=" & fi.DirectoryName
Dim objConn As New OleDbConnection(sConnectionString)
Dim objCmdSelect As New OleDbCommand("SELECT * FROM " & fi.Name, objConn)
Dim objAdapter1 As New OleDbDataAdapter
objAdapter1.SelectCommand = objCmdSelect
Dim objDataset1 As New DataSet
DataGrid1.DataSource = objDataset1.Tables(0).DefaultView
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.