No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
I want to select multiple records from sql table and insert it to a dataset when the selected index is changed from a combo box. for example if i select "1" from the combo box then, only values with "1" in the sql table's mentioned column should be inserted into …
|
|
|
What mean that error? can someone help me? [B] The connection was not closed. The connection's current state is open[/B] [CODE]Private Sub btnCari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCari.Click con.Open() sql = ("SELECT * FROM RekodAnggaran WHERE [NoIC]='" & txtNoIC.Text & "'") da = New OleDb.OleDbDataAdapter(sql, con) … 
|
|
|
Re:
Parameters
Hi I am a new bee, I am trying to insert data into a database white the use of parameters. When I run this code I get an error message: "No value given for one or more required parameters." Any help will be appreciated conn.Open() sql = "INSERT INTO Categories(Name) …
|