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

.NET (Core and Framework)

 
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 
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 
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
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 
GeneralRe: clue Pin
Bob Beaubien26-Feb-10 12:34
Bob Beaubien26-Feb-10 12:34 
GeneralRe: clue Pin
Bob Beaubien26-Feb-10 12:40
Bob Beaubien26-Feb-10 12:40 
GeneralRe: clue Pin
Luc Pattyn26-Feb-10 13:13
sitebuilderLuc Pattyn26-Feb-10 13:13 
QuestionCode problem or exceeded array limits? Pin
Hurricane300026-Feb-10 5:15
Hurricane300026-Feb-10 5:15 

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.