Ashokkakollu
said:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| can u give me an idea about those two objects? |
| dear sir,i need a help to insert a new row that has automated primary key note: the table i need to insert in is a combination between texts & integers thank you |
| Hi All I have one prblem . I am updating the datgrid changes to database. I am using the da.update(ds, "Table") to update to the database. Code is working but in between it doesnt update the data of a particular Row in the table. I am not able to understand why this code is not working for a particular row only. i am sending u my code. Pls Suggest soem way to me. Dim TagCommand As New OleDb.OleDbCommand Dim reader As OleDb.OleDbDataReader 'for testing Dim dsTagMap As New DataSet Dim daTagMap As OleDb.OleDbDataAdapter Dim connTag As OleDb.OleDbConnection 'Thsi is to laod the data to grid from table Private Sub Loaddata() Try daTagMap = New OleDb.OleDbDataAdapter("select * from TagMap", modConnection.gConn) daTagMap.Fill(dsTagMap, "TagMap") dgvTagMapping.DataSource = dsTagMap.Tables("TagMap" Catch ex As Exception MsgBox(ex.Message) End Try 'This is to update the data Private Sub updatechange() Try dgvTagMapping.Refresh() dgvTagMapping.Enabled = True Dim cb As New OleDb.OleDbCommandBuilder(daTagMap) Dim dsChanges As DataSet = dsTagMap.GetChanges() If dsTagMap.IsInitialized Then dsTagMap.EndInit() End If If dsTagMap.HasChanges Then daTagMap.Update(dsTagMap, "TagMap") End If dgvTagMapping.EndEdit() dsTagMap.AcceptChanges() Catch ex As Exception MsgBox(ex.Message) End Try End Sub |
| brilliant way to explain and summarize the complexities of the database handling, great tutorial ! |
| When i wanna creat an oledb adapter and when i give it a path of MDB (mdb is extension of microsoft access file) file there is a problem that when i press the TEST CONNECTION a massage box apears and written ''INVALID AUTHORIZATION SPECIFICATION'' and coonection habe been failed. what can i do? |
| Hey I have the same type of error working with the OleDBconnection in VB.NET pro 2005 under XP2. I have creating a new vb project as well as a new simple database with just one table and a couple of fields and it still will create a successful test. This is done after I create Oledbconnection object and then create the Connection String. When I connect using the other choice and Ole db 4 driver it works fine, but then the ds.tbl.addtblrow command lines throw a nullexception error. Anyone else other than us two have this problem? |
| < Prev | Next > |
|---|
|