Click here to Skip to main content
15,895,084 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Listbox height adjustment Pin
lazy_dude27-Oct-15 1:11
lazy_dude27-Oct-15 1:11 
QuestionVisual Basic Noob, in need of some direction Pin
Member 1207985922-Oct-15 10:15
Member 1207985922-Oct-15 10:15 
QuestionRe: Visual Basic Noob, in need of some direction Pin
phil.o22-Oct-15 12:02
professionalphil.o22-Oct-15 12:02 
AnswerRe: Visual Basic Noob, in need of some direction Pin
Member 1207985922-Oct-15 13:25
Member 1207985922-Oct-15 13:25 
GeneralRe: Visual Basic Noob, in need of some direction Pin
Wombaticus3-Nov-15 7:22
Wombaticus3-Nov-15 7:22 
QuestionMessage Closed Pin
15-Oct-15 10:35
Gie-wel15-Oct-15 10:35 
AnswerRe: it always say's "Not allowed to change the 'ConnectionString' property. The connection's current state is open." and " Number of query values and destination fields are not the same". please help me Pin
Chris Quinn15-Oct-15 21:13
Chris Quinn15-Oct-15 21:13 
Questionit always say's "Not allowed to change the 'ConnectionString' property. The connection's current state is open." and " Number of query values and destination fields are not the same" what should i do? i need answer as soon as possible please i'm new Pin
Gie-wel15-Oct-15 10:17
Gie-wel15-Oct-15 10:17 
Imports System.Data.OleDb
Public Class Inquiry_Form
    Dim provider As String
    Dim dataFile As String
    Dim connstring As String
    Dim myConnection As OleDbConnection = New OleDbConnection

    Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
        provider = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
        dataFile = "Database3.mdb"
        connstring = provider & dataFile
        myConnection.ConnectionString = connstring
        myConnection.Open()
        Dim str As String
        str = "INSERT INTO Inquiry_Form([Date],[RefNo],[NameP],[Address],[Age],[PhoneNo],[MobileNo],[EmailAd],[ReferralQuestion],[Type_of_Unit],[Date_of_Purchase],[Purpose_of_Purchase],[Monthly_Income],[RName],[RAddress],[RMobileNo],[R2Name],[R2Address],[RMobileNo],[R2Name],[R2Address],[R2MobileNo],[AgentsName]) Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
        Dim cmd As OleDbCommand = New OleDbCommand(str, myConnection)
        cmd.Parameters.Add(New OleDbParameter("Date", CType(TextBox1.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("RefNo", CType(TextBox2.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("NameP", CType(TextBox3.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("Address", CType(TextBox4.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("Age", CType(TextBox5.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("PhoneNo", CType(TextBox6.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("MobileNo", CType(TextBox8.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("EmailAd", CType(TextBox7.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("ReferralQuestion", CType(ComboBox1.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("Type_of_Unit", CType(ComboBox2.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("Date_of_Purchase", CType(ComboBox3.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("Purpose_of_Purchase", CType(ComboBox4.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("Monthly_Income", CType(ComboBox5.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("RName", CType(TextBox10.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("RAddress", CType(TextBox11.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("RMobileNo", CType(TextBox15.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("R2Name", CType(TextBox12.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("R2Address", CType(TextBox13.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("R2MobileNo", CType(TextBox14.Text, String)))
        cmd.Parameters.Add(New OleDbParameter("AgentsName", CType(TextBox16.Text, String)))

        Try
            cmd.ExecuteNonQuery()
            cmd.Dispose()
            myConnection.Close()
            TextBox1.Clear()
            TextBox2.Clear()
            TextBox3.Clear()
            TextBox4.Clear()
            TextBox5.Clear()
            TextBox6.Clear()
            TextBox8.Clear()
            TextBox7.Clear()
            TextBox10.Clear()
            TextBox11.Clear()
            TextBox15.Clear()
            TextBox12.Clear()
            TextBox13.Clear()
            TextBox14.Clear()
            TextBox16.Clear()

        Catch ex As Exception
            MsgBox(ex.Message)

        End Try

    End Sub

    Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Me.Close()
        Menu_Page.Show()
    End Sub

    Private Sub Button1_Click(sender As Object, e As EventArgs)
        Inquiry_FormBindingSource1.AddNew()
    End Sub

    Private Sub Inquiry_Form_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'Database3DataSet.Inquiry_Form' table. You can move, or remove it, as needed.
        Me.Inquiry_FormTableAdapter.Fill(Me.Database3DataSet.Inquiry_Form)

    End Sub


End Class

AnswerRe: it always say's "Not allowed to change the 'ConnectionString' property. The connection's current state is open." and " Number of query values and destination fields are not the same" what should i do? i need answer as soon as possible please i'm Pin
Wombaticus15-Oct-15 12:37
Wombaticus15-Oct-15 12:37 
AnswerRe: it always say's "Not allowed to change the 'ConnectionString' property. The connection's current state is open." and " Number of query values and destination fields are not the same" what should i do? i need answer as soon as possible please i'm Pin
Eddy Vluggen16-Oct-15 1:37
professionalEddy Vluggen16-Oct-15 1:37 
AnswerRe: it always say's "Not allowed to change the 'ConnectionString' property. The connection's current state is open." and " Number of query values and destination fields are not the same" what should i do? i need answer as soon as possible please i'm Pin
Richard Deeming16-Oct-15 3:03
mveRichard Deeming16-Oct-15 3:03 
AnswerRe: it always say's "Not allowed to change the 'ConnectionString' property. The connection's current state is open." and " Number of query values and destination fields are not the same" what should i do? i need answer as soon as possible please i'm Pin
عبد الرؤوف شوركي25-Oct-15 11:08
عبد الرؤوف شوركي25-Oct-15 11:08 
QuestionNIC Card Configuration for Multiple Servers in a list Pin
Member 1206068515-Oct-15 4:45
Member 1206068515-Oct-15 4:45 
AnswerRe: NIC Card Configuration for Multiple Servers in a list Pin
Dave Kreskowiak15-Oct-15 5:51
mveDave Kreskowiak15-Oct-15 5:51 
Questionhow to read STL file in vb.net Pin
Abimbola Sammy O'banj15-Oct-15 3:27
Abimbola Sammy O'banj15-Oct-15 3:27 
AnswerRe: how to read STL file in vb.net Pin
Dave Kreskowiak15-Oct-15 3:54
mveDave Kreskowiak15-Oct-15 3:54 
Questionvb.net desktop app on one computer share by several users Pin
dcof13-Oct-15 4:48
dcof13-Oct-15 4:48 
AnswerRe: vb.net desktop app on one computer share by several users Pin
ZurdoDev13-Oct-15 5:38
professionalZurdoDev13-Oct-15 5:38 
GeneralRe: vb.net desktop app on one computer share by several users Pin
dcof13-Oct-15 7:09
dcof13-Oct-15 7:09 
GeneralRe: vb.net desktop app on one computer share by several users Pin
ZurdoDev13-Oct-15 7:53
professionalZurdoDev13-Oct-15 7:53 
GeneralRe: vb.net desktop app on one computer share by several users Pin
dcof13-Oct-15 9:11
dcof13-Oct-15 9:11 
GeneralRe: vb.net desktop app on one computer share by several users Pin
ZurdoDev13-Oct-15 9:12
professionalZurdoDev13-Oct-15 9:12 
AnswerRe: vb.net desktop app on one computer share by several users Pin
Richard MacCutchan13-Oct-15 8:05
mveRichard MacCutchan13-Oct-15 8:05 
QuestionSql Value to buttons........ Pin
dha NAA12-Oct-15 20:36
dha NAA12-Oct-15 20:36 
AnswerRe: Sql Value to buttons........ Pin
Richard MacCutchan12-Oct-15 23:20
mveRichard MacCutchan12-Oct-15 23:20 

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.