hi..
this is the code that im using to insert a data in my access database...

dim con as ledbconnection
dim str as string
dim com as oledbcommand
con=new oledb connection("path")
str="insert into material_name(material) values(@material)"
com=new oledbcommand(str,con)
com.parameters.add("@material",oledb.varchar,textb ox5.text) //this line is giving error

con.open()
com.executenonquery()
con.close


my database table is in ms-access and the material column of material_name table is of "text" type.
spellings are correct bt still it is giving the error that string can not be converted to integer



any help would be gr8..
plz help me out of this
thnks in advance

abhishek

abhishek0807:
Updates and/or inserts are achieved via the DataSet,the DataAdapter and the DataTable.

Hope this helps.



========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.