Click here to Skip to main content
15,898,780 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Access like Report Pin
MohammadAmiry28-Oct-04 8:17
MohammadAmiry28-Oct-04 8:17 
GeneralCoding Pin
Member 116832427-Oct-04 6:09
Member 116832427-Oct-04 6:09 
GeneralRe: Coding Pin
MohammadAmiry27-Oct-04 6:42
MohammadAmiry27-Oct-04 6:42 
GeneralManipulating a String Pin
Brad Fackrell27-Oct-04 5:18
Brad Fackrell27-Oct-04 5:18 
GeneralRe: Manipulating a String Pin
cwayman27-Oct-04 5:46
cwayman27-Oct-04 5:46 
GeneralRe: Manipulating a String Pin
Brad Fackrell28-Oct-04 2:14
Brad Fackrell28-Oct-04 2:14 
GeneralNot sure where to start Pin
dahlst27-Oct-04 4:32
dahlst27-Oct-04 4:32 
GeneralSqlCEDataAdapter problem. How can I update ? Dataset has the changes. Pin
vasper27-Oct-04 3:25
professionalvasper27-Oct-04 3:25 
I have the following code, but I cannot seem to get the changes in the dataset to be commited to the database. All I get is a 0 rowcount:

Private editQry As String = "select idc,nomiko,Eponymo,Onoma,Tel from Persons where idc=1"
Private adoCEDataAdapter As SqlCeDataAdapter
Private CustEditDataSet As DataSet
Private cb As SqlCeCommandBuilder


Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub

Private Sub frmCustEdit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
adoCEDataAdapter = New SqlCeDataAdapter(editQry, frmConnect.adocon)
cb = New SqlCeCommandBuilder(adoCEDataAdapter)
CustEditDataSet = New DataSet
adoCEDataAdapter.Fill(CustEditDataSet)
txtSurname.DataBindings.Add(New Binding("Text", CustEditDataSet.Tables(0), "Eponymo"))
txtName.DataBindings.Add(New Binding("Text", CustEditDataSet.Tables(0), "Onoma"))
txtTel.DataBindings.Add(New Binding("Text", CustEditDataSet.Tables(0), "Tel"))
cbLegal.DataBindings.Add(New Binding("SelectedIndex", CustEditDataSet.Tables(0), "nomiko"))
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
MsgBox(adoCEDataAdapter.Update(CustEditDataSet).ToString())
Me.Close()
End Sub


I have tried to create the Update query with:
adoCEDataAdapter.UpdateCommand=cb.GetUpdateCommand
and it returns a query, but again nothing happens on the adoCEDataAdapter.Update(CustEditDataSet)

Help....

GeneralMouse Scroll button in Flexgrid not working Pin
parthi197727-Oct-04 2:51
parthi197727-Oct-04 2:51 
GeneralMouse Scroll button in Flexgrid not working Pin
parthi197727-Oct-04 2:51
parthi197727-Oct-04 2:51 
Generalautorun program when cd is inserted Pin
johnjsm27-Oct-04 2:22
johnjsm27-Oct-04 2:22 
GeneralRe: autorun program when cd is inserted Pin
Brad Fackrell27-Oct-04 5:31
Brad Fackrell27-Oct-04 5:31 
GeneralRe: autorun program when cd is inserted Pin
johnjsm27-Oct-04 23:00
johnjsm27-Oct-04 23:00 
GeneralRe: autorun program when cd is inserted Pin
Brad Fackrell28-Oct-04 2:19
Brad Fackrell28-Oct-04 2:19 
GeneralRe: autorun program when cd is inserted Pin
johnjsm28-Oct-04 2:45
johnjsm28-Oct-04 2:45 
GeneralRe: autorun program when cd is inserted Pin
Brad Fackrell28-Oct-04 2:47
Brad Fackrell28-Oct-04 2:47 
GeneralRe: autorun program when cd is inserted Pin
johnjsm28-Oct-04 3:38
johnjsm28-Oct-04 3:38 
GeneralRe: autorun program when cd is inserted Pin
Brad Fackrell28-Oct-04 3:42
Brad Fackrell28-Oct-04 3:42 
General[Message Deleted] Pin
imdx8027-Oct-04 2:20
imdx8027-Oct-04 2:20 
GeneralMigrating from vb6 to vb.net Pin
Anushu27-Oct-04 0:46
Anushu27-Oct-04 0:46 
GeneralSend float and other types as bytes on serial port Pin
aslm26-Oct-04 23:40
aslm26-Oct-04 23:40 
Generalextract substring using index (VB Script) Pin
xcavin26-Oct-04 23:14
xcavin26-Oct-04 23:14 
GeneralRe: extract substring using index (VB Script) Pin
Dave Kreskowiak27-Oct-04 3:15
mveDave Kreskowiak27-Oct-04 3:15 
GeneralRe: extract substring using index (VB Script) Pin
pigdart31-Oct-04 5:01
pigdart31-Oct-04 5:01 
GeneralUploading Problem Pin
cwayman26-Oct-04 22:10
cwayman26-Oct-04 22:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.