本文介绍了如何使用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列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 07:40
查看更多