本文介绍了如何使用VB.NET和SQL服务器将数据从组合框保存到numric列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
i have tabel and search form with combobox when i click save button error hapened in this line
dt_bank.Rows(pos_bank).Item("bank_user_id") = Val(CmbBank_user_id.SelectedValue)
---------------------------------------------------------------------------------
this is code
Private Sub BtnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSave.Click
dt_bank.Rows.Add()
Dim pos_bank As Integer = Module2_bank.dt_bank.Rows.Count - 1
dt_bank.Rows(pos_bank).Item("bank_id") = Val(TxtBank_id.Text)
dt_bank.Rows(pos_bank).Item("bank_name") = TxtBank_name.Text
dt_bank.Rows(pos_bank).Item("bank_address") = TxtBank_address.Text
dt_bank.Rows(pos_bank).Item("bank_branch") = Cmbbank_branch.Text
dt_bank.Rows(pos_bank).Item("bank_account") = Txtbank_account.Text
dt_bank.Rows(pos_bank).Item("bank_swiftcode") = Txtbank_swiftcode.Text
dt_bank.Rows(pos_bank).Item("bank_phone") = TxtBank_phone.Text
dt_bank.Rows(pos_bank).Item("bank_fax") = TxtBank_fax.Text
dt_bank.Rows(pos_bank).Item("bank_email") = TxtBank_email.Text
dt_bank.Rows(pos_bank).Item("bank_webpage") = TxtBank_webpage.Text
dt_bank.Rows(pos_bank).Item("bank_note") = TxtBank_note.Text
dt_bank.Rows(pos_bank).Item("bank_user_id") = Val(CmbBank_user_id.SelectedValue)
dt_bank.Rows(pos_bank).Item("bank_date") = DtpBank_date.Value
MessageBox.Show("تمت الاضافه بنجاح", "اضافة بنك", MessageBoxButtons.OK, MessageBoxIcon.Information)
Module2_bank.save_bank()
Module2_bank.load_bank()
newbank()
End Sub
我尝试过:
What I have tried:
i use vb.net, sql server
i try this
Val(CmbBank_user_id.text) and
Val(CmbBank_user_id.Selectedindex) and
Val(CmbBank_user_id.Selecteditem) and
Val(CmbBank_user_id.Selectedtext) and
Val(CmbBank_user_id.SelectedValue)
推荐答案
If Not CmbBank_user_id.SelectedValue Is Nothing Then
dt_bank.Rows(pos_bank).Item("bank_user_id") = Val(CmbBank_user_id.SelectedValue)
End If
dt_bank.Rows(pos_bank).Item("bank_user_id") = Convert.toInt32(CmbBank_user_id.SelectedValue)
你也可以使用
You can also use
Dim intUserId as Integer
Integer.TryParse(CmbBank_user_id.SelectedValue, intUserId )
dt_bank.Rows(pos_bank).Item("bank_user_id") = intUsedId
这篇关于如何使用VB.NET和SQL服务器将数据从组合框保存到numric列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!