Click here to Skip to main content
15,915,328 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: Bluetooth Addin for Visual Studio Team Suite Pin
Not Active28-Feb-10 1:49
mentorNot Active28-Feb-10 1:49 
QuestionRe: Bluetooth Addin for Visual Studio Team Suite Pin
mauricemcse28-Feb-10 4:13
mauricemcse28-Feb-10 4:13 
AnswerRe: Bluetooth Addin for Visual Studio Team Suite Pin
Dave Kreskowiak28-Feb-10 5:30
mveDave Kreskowiak28-Feb-10 5:30 
GeneralRe: Bluetooth Addin for Visual Studio Team Suite Pin
mauricemcse28-Feb-10 9:37
mauricemcse28-Feb-10 9:37 
GeneralRe: Bluetooth Addin for Visual Studio Team Suite Pin
Dave Kreskowiak28-Feb-10 15:51
mveDave Kreskowiak28-Feb-10 15:51 
QuestionCan't update if database fields is more than 8 Pin
akosidandan27-Feb-10 4:59
akosidandan27-Feb-10 4:59 
AnswerRe: Can't update if database fields is more than 8 Pin
Dr.Walt Fair, PE27-Feb-10 6:05
professionalDr.Walt Fair, PE27-Feb-10 6:05 
GeneralRe: Can't update if database fields is more than 8 Pin
akosidandan27-Feb-10 13:07
akosidandan27-Feb-10 13:07 
Hello,

Sir this my database
FIELD Name  |  Data Type
ID              number
lastName        text
firstName       text
middleName      text
contactNum      number
add             text
eAdd            text
status          text
position        text



This is my save code command
Try

           con.Open()
           Dim dt As New DataTable
           Dim ds As New DataSet
           ds = New DataSet("DataSet")
           ds.Tables.Add(dt)

           Dim da As OleDbDataAdapter
           da = New OleDbDataAdapter("Select * from empTable", con)
           da.Fill(dt)
           con.Close()

           Dim newrow As DataRow = dt.NewRow
           With newrow
               .Item("ID") = Val(txtEmpIDAdd.Text)
               .Item("lastName") = txtLastAdd.Text
               .Item("firstName") = txtFirstAdd.Text
               .Item("middleName") = txtMiddleAdd.Text
               .Item("contactNumber") = Val(txtContactAdd.Text)
               .Item("add") = txtAddressAdd.Text
               .Item("eAdd") = txtEmailAdd.Text
               .Item("status") = cmbStatusAdd.Text
               .Item("position") = txtPositionAdd.Text
           End With
           dt.Rows.Add(newrow)


           con.Open()
           da = New OleDbDataAdapter("Select * from empTable", con)
           Dim cb As New OleDbCommandBuilder
           cb = New OleDb.OleDbCommandBuilder(da)
           da.Update(dt)
           con.Close()


       Catch ex As Exception
           MsgBox(ex.ToString)
       End Try



This save code does not work if my database field is 9 above,
but when I delete some fields the code work.


Thanks for immediate response.




Thanks,

dfan23
GeneralRe: Can't update if database fields is more than 8 Pin
akosidandan27-Feb-10 17:51
akosidandan27-Feb-10 17:51 
GeneralRe: Can't update if database fields is more than 8 Pin
Dr.Walt Fair, PE27-Feb-10 18:52
professionalDr.Walt Fair, PE27-Feb-10 18:52 
AnswerRe: Can't update if database fields is more than 8 Pin
Abhinav S27-Feb-10 7:30
Abhinav S27-Feb-10 7:30 
GeneralRe: Can't update if database fields is more than 8 Pin
akosidandan27-Feb-10 13:10
akosidandan27-Feb-10 13:10 
GeneralRe: Can't update if database fields is more than 8 Pin
Luc Pattyn27-Feb-10 14:02
sitebuilderLuc Pattyn27-Feb-10 14:02 
GeneralRe: Can't update if database fields is more than 8 Pin
akosidandan27-Feb-10 17:11
akosidandan27-Feb-10 17:11 
GeneralRe: Can't update if database fields is more than 8 Pin
akosidandan27-Feb-10 20:01
akosidandan27-Feb-10 20:01 
Questionneed help with generics - multi key lookup Pin
Kalyan_A27-Feb-10 2:29
professionalKalyan_A27-Feb-10 2:29 
AnswerRe: need help with generics - multi key lookup Pin
Luc Pattyn27-Feb-10 2:36
sitebuilderLuc Pattyn27-Feb-10 2:36 
GeneralRe: need help with generics - multi key lookup Pin
Kalyan_A27-Feb-10 3:23
professionalKalyan_A27-Feb-10 3:23 
AnswerRe: need help with generics - multi key lookup Pin
Luc Pattyn27-Feb-10 4:04
sitebuilderLuc Pattyn27-Feb-10 4:04 
QuestionCreating Bitmap from MemoryStream Pin
xry200626-Feb-10 13:14
xry200626-Feb-10 13:14 
AnswerRe: Creating Bitmap from MemoryStream Pin
The Man from U.N.C.L.E.2-Mar-10 7:15
The Man from U.N.C.L.E.2-Mar-10 7:15 
GeneralRe: Creating Bitmap from MemoryStream Pin
xry20063-Mar-10 1:39
xry20063-Mar-10 1:39 
GeneralRe: Creating Bitmap from MemoryStream Pin
The Man from U.N.C.L.E.3-Mar-10 3:02
The Man from U.N.C.L.E.3-Mar-10 3:02 
QuestionTimer reset Pin
Bob Beaubien26-Feb-10 11:57
Bob Beaubien26-Feb-10 11:57 
Answerclue Pin
Luc Pattyn26-Feb-10 12:23
sitebuilderLuc Pattyn26-Feb-10 12:23 

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.