how can i avoid data duplicate in the database?i mean if i add in the fields that has been already save it will still save.i don't know how to query or filter not to add the same info.i have the code below but it still save if i input same as already in the database.[code]i want is to query first before it add the data to avoid same info.
View 6 Repliescreate a adding form and it will save to sql database .
View 4 Repliesi have a list of items in a listbox:-
A
B
C
and i have a button that adds these items by selecting them to a datagrid how can i avoid adding A or B or C twice to the datagrid?
How to avoid aiding the development of malicious code I see an uncomfortable number of questions asking for info that could easily be put to malicious use. You can probe the OP to discover their intent, and you get replies that come in one of two flavors.
I have come to realize that trying to discover their intent is a waste time. Not because of the reactions, but their intent is really irrelevant to the matter at hand. Security. Posting code of any nature in a public forum that can be abused for malicious purposes is outright reckless. I wish could provide the help they request, but I don't know most of those programming tricks anyway. I would discourage anyone from publicly posting code that could be perverted no matter what the person asking for it claims. Their claims take a back seat to common sense. Anyone can read the post, people. Don't post anything that could become part of someone's malicious software in public.
I have a dropdownlist with a list of options which is subject to change (e.g. 'active users'). Another data source may include historical data, but I wish to use the 'active users' dropdownlist against it. This means an ArgumentOutOfRangeException will be thrown so I want to catch that, and insert the required entry into the dropdownlist on the fly.
I've seen a few suggestions that point towards overriding the ondatabinding event within the dropdownlist, I've managed to do this insofar as I can create a static listitem for example "Value does not exist" and bypass the exception. However I wish rather than "Value does not exist" so show the actual value which we were attempting to find in the ddl.
ondatabinding is passed a standard EventArgs item which doesn't offer much to go on, I can see there is a DataListItemEventArgs class - is this in any way associated with a dropdownlist? I tried directcast on the EventArgs but that didn't work.
So is there any way - within ondatabinding - of finding out the value we're attempting to set on the dll, which causes the ArgumentOutOfRangeException?
I have forms with multiple pictureboxes, labels, etc. They are all numbered, for example, pb_QL01 to pb_QL99, or lb_Main01 to lb_Main29. In the old days, I could reference the properties of these in code using, for example, Me.Controls(a).Image where 'a' was the string of the name of the object (e.g. "pb_QL23"). So, I get it that you can't do this anymore in QB2008 (too bad). I need to set the properties in loops. [Code]
but it takes a long time to cycle through all of my controls, and there are some properties that will not work (like mycontrol.image), image not an option. So, is there an easy way to get this done? I don't want to add the controls in code, since they already exist on the form. If I have to use collections (which I'd prefer not to if there is an analogous way to the old way of passing the name of the control in code with a string, but if I need to, how do I get this to work.
I have VB.net code (2005) that updates an Excel (2003) file but on close I get a pop up from Excel when my code is trying to close it. How can I close and save changes and not get the pop up? ("Save Changes Made").
I tried this:
vb
xlWorkBook.SaveAs(Filename:=excelFileName2, FileFormat:=Excel.XlFileFormat.xlExcel3)
But it renamed the "Sheet1" tab and I got more pop ups from Excel.
I am creating a hotel room booking form. In my mainform I have several controls that i can use to select/fill eg room number, date, name of visitor, number of days booking etc.I also have table adapter that binds the data source I have a save button in my form and I need to create an event so that it saves the data that I have entered in the mainform to the underlying dataset- i have to use endEdit(), DataRowView methods/properties but can't manage to write the save button event.
View 7 RepliesHow can i avoid the duplicate values in the Access Database?? I am working in VB.NET, to create DataEntry Form. I have Combobox. When enter the value on Combobox and press OK button then the value should check on the database , if the value is not there then it should save on the db. else the Missage will give "It is Saved".
View 6 RepliesSo I have an application which uses MSSQL server as datasource. Is there anyways I can avoid using any database server and use a local file as datasource ?
View 4 RepliesI have a legacy data table in SQL Server 2005 that has a PK with no identity/autoincrement and no power to implement one. As a result, I am forced to create new records in ASP.NET manually via the ole "SELECT MAX(id) + 1 FROM table"-before-insert technique.Obviously this creates a race condition on the ID in the event of simultaneous inserts.
What's the best way to gracefully resolve the event of a race collision? I'm looking for VB.NET or C# code ideas along the lines of detecting a collision and then re-attempting the failed insert by getting yet another max(id) + 1. Can this be done?
I am using this code to to generate a crystal report from aa sql string that i construct using a supplied table name and some column names in txtSQL.This code contains functionality to export to ms word.However when the save dialog comes up and the user enters the intended filename.and saves the document.when the user attempts to open the document they have to use"open with" because the save dialog does not add an extension to the file so my question is how can i add an extension for tthe user programmatically.This is my first time using save dialog
Dim rpt As New MembersReport()
sfdSaveMe.ShowDialog()
Dim strExportFile As String = sfdSaveMe.FileName
[Code]......
how to add a save feature to the Binding Navigator tool strip as it isn't a feature by default. I'm using VB Express Edition 2008.
View 1 Repliescan anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesIve created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
1. First off, how do I make my path to my database relative? The path is currently absolute and is: Data Source=J:/College/AS_DSFinalDatabase1.accdb
2. Second of all, where do I save my database in the project? I want it to be included in like project folders...kind of like the App_Data folder in ASP.Net.
3. I'm recieving an error whenever I try to populate more than 1 DataGridView upon form load for some reason...I've tried 5 different ways of writing the code, and I get the same error...there's no error description, so does anyone know what the issue is? Here's the error:
i want save image in directory path and also save path in database...sqlserver 2005 and retrieve in in same folder and path?
View 1 RepliesI am looking for the simplest way to push a new row to a database by inserting one record and then retrieving the Primary Key generated by inserting that row.
I know there are several ways this can be done but I can't seem to get any of them to work yet.
I have made a form that has three labels and textboxs and two buttons. The labels arelblPersonID, lblFirstName and lblLastname. The textboxs are txbPersoonID, txbFirstName and txbLastName. The two buttons are btnSave and btnQuit with "End" in htis button. I have also made a database "MyFriends" with a table that has PersonId, FirstName and LastName.
I want to be able to type into my textboxs and have that information saved as a neww row.
Anyway, if I use a web service I need the web service(server) to connect to the databasen MS Visual studio when you add a web service project the data menu disappears and you can't add a data source to the project. There may be a workaround for this by hand coding this, but I am not sure how to do it. This is my first time working with a web service and ASP.NET so I am a real noob in this are
View 7 RepliesWhat I am trying to do it create a server application for all of the clients in my organization to connect to. I think the best way to do this is to use a web service.
Anyway, if I use a web service I need the web service(server) to connect to the database. In MS Visual studio when you add a web service project the data menu disappears and you can't add a data source to the project. There may be a workaround for this by hand coding this, but I am not sure how to do it. This is my first time working with a web service and ASP.NET so I am a real noob in this area.
I have a database linked to my VB.NET project using the data source wizard. I've created a log in form using a table in access that has the details required to log in.
The code is:
Imports System.Data
Public Class Form1
[code].....
I have been trying to get the database sample to work. I have been unable to figure it out. I posted my code below, but something isn't working right and I cant figure it out. Please review my code if you have a chance and let me know what I am doing wrong.
[code]...
here's the code:
Try
Dim com As New OleDbCommand
com.Connection = con
[code]......
I have a project I created for my VB class where you enter what type of ticket(combobox), how many tickets(textbox), what type of tickets(listbox) and will give you the total amount.I want to do a little more to the program and was wondering about adding the person's name, address, phone, city, state, zip and then having all the information put into a database. I wanted to also take the information entered from the program and use the printPreview control to view a report from Access(possible?).
I've only worked with viewing database information on the forms in VB but I've never entered data into the database. Is this possible?Can I have the information entered on the form be entered into a database that keeps track of all tickets purchased and customer information?I can see this working in my head but don't know if it's logistically possible.
how can i call data from database that newly updated(into row) to be inserted into a labels, here is the screenshot:
View 2 RepliesI need help with adding a record to a database.I have a database with multiple tables. How do I add a new record to one of the tables without using the BindingNavigator.Lets say the table's name is tblDetails and the fields are:NameSurnameCellAddressI have a number of text boxes on my form:txtNametxtSurnametxtCelltxtAddressI want to add the details from the text files to the table and a new record.
View 5 Repliesim having problems trying to work out the code i need to add to a value i already have in a cell in my database, for example if the cell contains the value 3, and input 10 to my textbox, then i want the cell to contain the value 13. at present what i input to the textbox only inputs that value rather than updating it. i would be appreciate any help as i'm a student and i'm new to using VB with databases!!
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
accCom.Connection = accConn
[Code]....
I've got a form here with a listbox full of words. I'd like to allow the user to insert new words and have it update the database it's getting the data from. Can I have it display a msgbox, the one that takes input from a user, and use that to update the database?
View 13 RepliesMy program has an access database with a table called "Contacts". This table stores many values. I have a seperate table that stores surveys. Each contact should have a column for every survey, indicating whether or not the survey has been completed. However, this means I need to add columns to the database while the program is running. I tried the following code, which runs WITHOUT errors, but does not seem to actually add the column.
contactsDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Contacts", frmAdmin.con)
contactsCommandBuilder = New OleDb.OleDbCommandBuilder(contactsDataAdapter)
dtContacts.Clear()
[Code].....