Database

For Each file12 In files<br />
<br />
                array12 = System.IO.Path.GetFileNameWithoutExtension(file12).Trim<br />
<br />
<br />
                Dim FileSize As UInt32<br />
                Dim rawData() As Byte<br />
                Dim fs As FileStream<br />
                fs = New FileStream(cale12 & "\" & array12 & ".buf", FileMode.Open, FileAccess.Read)<br />
                FileSize = fs.Length<br />
<br />
                rawData = New Byte(FileSize) {}<br />
                fs.Read(rawData, 0, FileSize)<br />
                fs.Close()<br />
<br />
                par.ParameterName = "?BinData"<br />
<br />
                cmd.CommandText = "update notiz set Bindata=" & par.ParameterName & " where Nr=" & Chr(39) & array12 & Chr(39)<br />
<br />
                par.Value = rawData<br />
<br />
                cmd.Parameters.Add(par)<br />
                cmd.ExecuteNonQuery()

dataGridView1.DataSource = bindingSource1;<br />
dataAdapter = new OleDbDataAdapter("SQL-query", connectionString);<br />
OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter);<br />
DataTable table = new DataTable();<br />
dataAdapter.Fill(table);<br />
bindingSource1.DataSource = table;