I have a DGV I am working on, and I have many columns.dgv bind to two table my problem with update button dose not update and gives me wrong massege ""Dynamic SQL generation is not supported against multiple base tables"
Imports System.Data
Imports System.Data.OleDb
Public Class Form4
[code]....
my save button not work
Private Sub btn_save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_save.Click
[code].....
I got every other operation button to work besides sqrt, and percentage. I've done the same thing for addition, subtraction, etc. and it doesn't seem to work.
here's my globals
Public Class Form1
Private first As Double
Private second As Double
Private oper As String
[code]....
How does the last button work, heres my first, next, previous and last button codes"
next button:
[CODE]..................
previous button:
[CODE]..................
first button:
[CODE]..................
last button: *not working*
[CODE]..................
finding the error in this code below. this piece of code is supposed to update the password field with the new password but what the program does at the moment it justs goes straight to the else statement without updating in the database.
If bol = True Then
oledbcon.Open()
strSQL = "UPDATE Username SET " & _
[Code].....
I'm trying to update my database, I'm using access 2003, my problem is that for some reason I can update the first row but when I try to update any other rows after that I keep getting an error saying Column 'ProductID' is constrained to be unique. Value '7' is already present.
View 6 Repliesafter Update my licesnce key not work, need to create key again
im using winlisence
I have a form and controls on from I work with background worker on my form and I want when I work with background worker in (for next) changed a data table example (mydt.clear()) or change a datagrideview..how to update controls on a form when we work with background worker? [code]
View 4 RepliesI am working on a signout system I have a good start but am trying to solve a small problem.Signing out equipment I fill part of a form with student data from the dataset with Fillby, fill the other half with equipment data using Fillby1 I then save this combined data to my Access 2007 Database using a OleDb.OleDbConnection.
[Code]...
I have created a test application to display data in a datagrid, using the Dataset Wizard per the help. All fine - data is displayed.
I then added insert, delete and update queries by selecting Edit Dataset with Designer, selecting the table and adding a query for each action via the TableAdapter Configuration Wizard. In Advanced Options, all boxes are checked, and on the last screen of the wizard it says it has generated SELECT, INSERT, UPDATE, DELETE statements, table mappings, Fill, Get and update methods. The TableAdapter shows four entries: Fill, GetData(); DeleteQuery; InsertQuery; UpdateQuery. On the DataGridView Tasks page, Adding, Editing and Deleting are checked and the data preview shows data.
When I run the application, I can update, add and delete data, but this is not saved.
i cant seem to get this code to work, what am i doing wrong, when i press the enter button it doesnt do anything
Option Explicit On
Option Strict On
Option Infer Off
[code]....
I made a custom button to input keypresses:
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class KeyInputButton
Inherits System.Windows.Forms.Button
[code].....
I have a form in visual basic 2010 in design view. And when i debug the form. the button i have put on the form does nothing. i want the button that i added, to do what the add new item does on the toolbar at the top of the form the code i have now is
Public
Class
Form1
Private
[code]....
I have a form in VB.net. When the applications runs it populates the data on a datagrid from the database. Then I have an export to excel button which when clicked creates a spreadsheet and dumps all the data in it. Nice!!!Now, what I want to do is have another button to auto email the work to my Boss. The work should be presented to him in a spreadsheet form, therefore I reckon after the export will be ideal or any ideas will be handy
View 2 Repliesthis is the second time I have had the same problem come up so maybe some of you have had the same issue. I have a form that has only a text box a list box and a button. The list box is loaded with part numbers from a database, the text box is used to search for a part number and the button is to accept the selected part and close the form.
[Code]...
When i run the program and click the cost button, it only returns a value of £0.00 for insurance cost and total cost.
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCost.Click
Dim Cost As Double
[Code]......
Option Strict On
Public Class Form1
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
'The btnCalculate click event accepts and displays up to 20 hours from the user and
[code].....
I am using Visual studio 2008, and I cannot get the listbox to generate the lists, nor can I get the calculate button to do work. I click it, nothing happens. BTW this is coded the way the instructor directed in the audio cast that was published for the class.
cmbproduct actually selects successfully
but the btnadd.performclick fails (for some reason)
cmbProduct.SelectedItem = "Single Line | Provide"
[code].....
How can i work with Next and Previous button, in VB6 with the help of record set it was quite easy, but in dot net i little bit confused, how to do it?
View 1 RepliesI have this code in ButtonClick Handle event but nothing works :/ I was wondering why... I tried msg("") as well as the first line in the code to see if it works but nothing!
Dim myConn As SqlConnection
Dim cmd As SqlCommand
Dim sqlString As String
[code]....
Button.performclick not work when it visible = false?
View 4 Repliesi got 5 treeview with checkboxes when i click button update i need to uncheck all the checkbox i also got a button which can clear all the checkboxes which it uses javascript function to clear i was wondering whether execute update after tat execute clear button automatic? it tat any way to implement this function? here is my java script of clear button which word perfectly
[Code]...
Assume an application uses the Dim SalesArray(1 to 10) As Integer instruction to declare an array named SalesArray. The array contains 10 sales amounts. When the user clicks the DisplayAverage button on the form, he or she should calculate and display the average sales in currency format. The code for the DisplayAverage button doesn't work. Fix it.
[code]...
I'm doing a project in which I have 5 radio buttons. I want each of them to show me a different image when I click on them... My guess is that I have to usea Picture Box. How do I make them work together?
PS: When I click on another radio button I want the other one to disappear and show me the new one.
I wrote a program which is editing data from database. I used few tutorials (I`m beginer) and everything is working fine(I can make changes in datagrid). but when I`m trying to save changes made in dataset(e.g. save added record) I can not to that (there are no changes in my access database, but inly in datagrid)what is interesting when I delete record - changes are saved and record is deleted from db. where is my mistake? what is wrong? maybe some tips what can I improve in this small program?
[Code]...
My Com1.text has nothing in it but yet the button1 is still visible when it should be false and not showing. This worked fine in vb6 using command.caption.[code]
View 14 RepliesAssume an application uses the Dim SalesArray(1 to 10) As Integer instruction to declare anarray named SalesArray. The array contains 10 sales amounts. When the user clicks the DisplayAverage button on the form, he or she should calculate and display the average sales in currency format. The code for the DisplayAverage button doesn't work. Fix it.
Sub DisplayAverage_Click( )
Dim X As Integer, Total As Integer, Average As Single
If X = 0 to 10
[code].....
how do I fix my button to run?
View 4 RepliesBeginner question. How come I can do this:
Public Class Form1
Private StudentsInMyRoom As New ArrayList
Public name As String
[code].....
i an making a password program and with two codes
1. how can a make the password changeable
2. how can i make the close button not work?