database insertion problem

[aniskhan]

I have the DB "imdb" in access having one field "path" text.

here i ADD the path(got it through opendialog) into the DB.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim currFldr As String	
	'copy the fullpath
        If Me.OpenFileDialog1.ShowDialog = DialogResult.OK Then
            currFldr = New DirectoryInfo(Me.OpenFileDialog1.FileName).ToString
        End If

        Me.OleDbConnection1.Open()
        Me.DataSet11.Clear()

	'Addnew path
        Me.BindingContext(DataSet11, "imdb").AddNew()

	
        Dim newRow As DataRow = DataSet11.imdb.NewRow
	
	'copy new value in dataRow
        newRow("path") = currFldr
        Me.DataSet11.Tables("imdb").Rows.Add(newRow)

        Me.OleDbDataAdapter1.Update(DataSet11)

        Me.OleDbConnection1.Close()

End Sub

the problem..
path (from opendialog is alright) but when ADD in database it not the complete path (lost last characters)

i checked newRow("path") created ,but it has the complete path

Label1.Text = newRow("path")

anythg wrong in code..

 

[sevenhalo]

are you sure you made the DB's field big enough to hold it?

 

[aniskhan]

re:

i am using access

field "path" is text..

 

[sevenhalo]

It still has a "Field Size" attribute.

Did you allocate enough space?

 

[aniskhan]

re:

field size is set to 255

but...

shows only
D:\Microsoft Visual Studio .NET\del\WindowsApplica

 

[Chazper]

Hi i have the same problem. I'm currently trying to figure this out. I suspect that you need to do something with the sql commands used....
Anyone knows how to solve this problem? thanks

 

[vis781]

for starters it's not a good idea to use keywords as variables i.e

Dim newrow as datarow = ......

It can be quite confusing to read and not a good habit to get into.

Secondly it may be a case of certain characters in the string that could be causing the problem.

Thirdly you don't have to explicitly close an oledbconnection when using the a dataadapter. it does all that for you whether there was an error or not.