G
gigi
i want to update one of data.
i have use this method to save my data.
'Decleare the file stream as fs
Dim fs As FileStream = New FileStream(filename, _
FileMode.OpenOrCreate, FileAccess.Read)
Dim rawData() As Byte = New Byte(fs.Length) {}
fs.Read(rawData, 0, System.Convert.ToInt32
(fs.Length))
fs.Close()
OleDbDataAdapter1.Fill(DataSet1, "ImageTest")
Dim myRow As DataRow
'Make new row
myRow = DataSet1.Tables("ImageTest").NewRow()
'Insert new data to table imageFile
myRow("ImageNo") = txtImageNo.text
myRow("ImageFile") = rawData
DataSet1.Tables("ImageTest").Rows.Add(myRow)
OleDbDataAdapter1.Update(DataSet1, "ImageTest")
MsgBox("Image saved to database")
i have use this method to save my data.
'Decleare the file stream as fs
Dim fs As FileStream = New FileStream(filename, _
FileMode.OpenOrCreate, FileAccess.Read)
Dim rawData() As Byte = New Byte(fs.Length) {}
fs.Read(rawData, 0, System.Convert.ToInt32
(fs.Length))
fs.Close()
OleDbDataAdapter1.Fill(DataSet1, "ImageTest")
Dim myRow As DataRow
'Make new row
myRow = DataSet1.Tables("ImageTest").NewRow()
'Insert new data to table imageFile
myRow("ImageNo") = txtImageNo.text
myRow("ImageFile") = rawData
DataSet1.Tables("ImageTest").Rows.Add(myRow)
OleDbDataAdapter1.Update(DataSet1, "ImageTest")
MsgBox("Image saved to database")