- 最後登錄
- 2024-1-1
- 在線時間
- 0 小時
- 註冊時間
- 2009-2-1
- 閱讀權限
- 20
- 精華
- 1
- UID
- 5767400
- 帖子
- 67
- 積分
- 193 點
- 潛水值
- 19689 米
| 分享使你變得更實在,可以使其他人感到快樂,分享是我們的動力。今天就來分享你的資訊、圖片或檔案吧。 本帖最後由 darkjack 於 2012-7-25 11:51 PM 編輯
妳好大大我們這組成員 用了妳給我的rar去改之後出現了一些小問題
他把原本設定生日(TextBox2)的改成設定學號
原本的格式好像是生日的格式
可是執行輸入區更新資料時 會一直出現 檢查學號格式是否正確
請問有那些地方要更改的嗎 有點搞不懂中
- #Region "Update 程式碼"
- Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
- conn.Open()
- Dim UpdateStr As String
- Dim a, b, c, d, f, g, h, i As String
- a = DGView1.CurrentRow.Cells("學號").Value.ToString
- b = DGView1.CurrentRow.Cells("姓名").Value.ToString
- c = DGView1.CurrentRow.Cells("地址").Value.ToString
- d = DGView1.CurrentRow.Cells("系所").Value.ToString
- f = DGView1.CurrentRow.Cells("電話").Value.ToString
- g = DGView1.CurrentRow.Cells("生日").Value.ToString
- h = DGView1.CurrentRow.Cells("性別").Value.ToString
- i = DGView1.CurrentRow.Cells("E-mail").Value.ToString
- 'Update 指令 必須要有 --> ` 符號
- UpdateStr = "update 學生資料表 set `學號` = '" + TextBox1.Text + "', `姓名` ='" + TextBox2.Text + "' , `地址` ='" + TextBox3.Text + "' , `系所` ='" + TextBox4.Text + "' , `電話`='" + TextBox5.Text + "' , `生日`='" + TextBox6.Text + "', `性別`='" + TextBox7.Text + "',`E-mail`='" + TextBox8.Text + "'where 學號 =@a and 姓名 =@b and 地址 =@c and 系所 =@d and 電話 =@f and 生日 =@g and 性別 =@h and E-mail =@i"
- MyDataAdapter.UpdateCommand = New OleDbCommand(UpdateStr, conn)
- Dim myParameters(7) As OleDbParameter
- myParameters(0) = New OleDbParameter("學號", a)
- myParameters(1) = New OleDbParameter("姓名", b)
- myParameters(2) = New OleDbParameter("地址", c)
- myParameters(3) = New OleDbParameter("系所", d)
- myParameters(4) = New OleDbParameter("電話", f)
- myParameters(5) = New OleDbParameter("生日", g)
- myParameters(6) = New OleDbParameter("性別", h)
- myParameters(7) = New OleDbParameter("E-mail", i)
- MyDataAdapter.UpdateCommand.Parameters.AddRange(myParameters)
- MyDataAdapter.UpdateCommand.ExecuteNonQuery()
- MessageBox.Show("更新成功!")
- conn.Close()
- End Sub
- #End Region
- #Region "不常用的程式碼 離開程式與切換From"
- Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
- Me.Dispose()
- End Sub
- #End Region
- #Region "重新讀取程式碼"
- Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
- '重新讀取
- conn.Open()
- Dim str1 = "select * from 學生資料表"
- MyDataAdapter = New OleDbDataAdapter(str1, conn)
- MyData = New DataSet
- MyDataAdapter.Fill(MyData, "學生資料表")
- DGView1.DataSource = MyData.Tables("學生資料表")
- conn.Close()
- End Sub
- #End Region
- Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
- '儲存 修改 更新
- Try
- conn.Open()
- ' ConnInput.Open()
- Dim InsStr = "Insert into 學生資料表" & _
- "(學號,姓名,地址,系所,電話,生日,性別,E-mail)" & _
- "values (?,?,?,?,?,?,?,?)"
- Dim MyParameter(7) As OleDbParameter
- MyDataAdapter.InsertCommand = New OleDbCommand(InsStr, conn)
- MyParameter(0) = New OleDbParameter("學號", TextBox1.Text)
- MyParameter(1) = New OleDbParameter("姓名", TextBox2.Text)
- MyParameter(2) = New OleDbParameter("地址", TextBox3.Text)
- MyParameter(3) = New OleDbParameter("系所", TextBox4.Text)
- MyParameter(4) = New OleDbParameter("電話", TextBox5.Text)
- MyParameter(5) = New OleDbParameter("生日", TextBox6.Text)
- MyParameter(6) = New OleDbParameter("性別", TextBox7.Text)
- MyParameter(7) = New OleDbParameter("E-mail", TextBox8.Text)
- MyDataAdapter.InsertCommand.Parameters.AddRange(MyParameter)
- MyDataAdapter.InsertCommand.ExecuteNonQuery()
- MsgBox("新增完成")
- Catch err As OleDbException
- ' MessageBox.Show(err.ToString)
- MsgBox("檢查學號格式是否正確" & vbCrLf & "範例:L00000000")
- Finally
- ' ConnInput.Close()
- conn.Close()
- End Try
- End Sub
複製代碼
... |
|