I want to backup my database using Linq to SQL:
Dim sql As String = "BACKUP DATABASE SeaCowDatabase TO DISK = _
'" + sfd.FileName + "'"
db.ExecuteCommand(sql)
[code].....
i keep on getting SqlException was unhandled incorrect syntax near '+'.i cant seen to see whats wrong with my code.i hope someone can help me solve this code.[code]
View 2 RepliesMy application is in VS 2008 (vb.net Windows form)
I want tips for this:
What types of care I take for it?
What types of problems can be generally happen?
[code]....I have a dialog that comes up and asks for a reason for declining the business.I don't want the code to move on after not enabling the "me" until the reason has been entered and saved into the database. Also, at that point where it says "I WANT...." I want to copy the textbox fields into a new database and then delete this entry from the database, how can I do that. I am using VS 2008 and SQL.
View 2 RepliesI whant to entry data in a database (fild) by pressing a button. The problem is that the button is in form 1 and the database is in form 2.
In the Button1_Click i have the cod for Form 2 to show.
I'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB.[code]...
View 2 RepliesI am trying to update a few entries in a access database through VB.NET. With the code I used below could anyone help me out and show me where I made a mistake because it is creating new database entries instead of updating them.
[Code]...
I'm trying to delete an entry from my database, i have the code written to display the details in a listbox but now i need to write the code do the user can select the item they want to delete and then click the delete button to delete it? I just want to flag it as deleted not get rid of it completely from the database?
View 5 Repliesif i had a cancel button which showed a message box, how would i get the message box to show OK and Cancel and for each of them to do something?
and how would i get an OK (paired with the first cancel from above) to save an entry/ changes to a database?
I was able to successfully connect my database using connection string, i am having a hard time finding tutorials on how to add the items in a textbox. [code]...
View 1 RepliesIs there a faster/easier and more efficient way of checking if an entry exists in SQL then this:
Private Function CustomerCheck()
Dim connString As String = ("Data Source=.SQLEXPRESS;Initial Catalog=BFS;Integrated Security=True;Pooling=True;")
Dim cmdText As String = "(SELECT * FROM Customer WHERE Customer=" + CustomerTextBox.Text.ToString + ")"[code]......
I'm trying to add a name of a product to a Textbox...the name of the product is stored in a database. Now there is a Combobox with number in them....1 2 3 ect. Now if you select one of the numbers it must display that product name?
conn.Open
Textbox1.Clear()
myDataSet.Clear
[Code].....
I want to find an entry in an access database.I've employees database it have 4 columns (Name , Age , Nationality , E-mail address)I've in it 100 entries.And my questions are:1-I want to find all employees those names start with "Tim".2-I want to find an employee that his name is "Charles Sterling".3-I want to find all employees those their ages are "30 years old".*I want to show all results in a message box.
View 3 RepliesIm currently doing a project which is a system that adds booking records to it
it loads the database from a module
Set Db = OpenDatabase(App.Path & "cihansol.mdb")
Set RS_Staff = Db.OpenRecordset("EPHS_Staff")
Set RS_Customers = Db.OpenRecordset("EPHS_Customers")
[Code]...
I need a code that once u select a field and click delete it removes it from the database.
I write the following
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Dim con As OleDbConnection
Dim cmd As OleDbCommand
[Code]...
i am pulling together a cash register that will allow both bar code product entry and manual key entry.imagine if you have a tin of beans in front of you, in a small corner shop they would probably type "47" and then hit "Produce". Fairly straight forward as I have the button Produce to act upon my code and update my salestrans.mdb but,if you scan the bar code I want the same form to handle both 'real' actions, (i assume that keyboard emulation barcode scanner includes "ENTER" after providing 13 digits)....
Q. in perhaps a long winded way i want to know how to kick off an event based on the "ENTER" key being activiated by the barcode scanner)?i do not want to have to hit any buttons if i am scanning bar codes.
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
View 2 RepliesIam trying to link a database to a website. I want the website to allow a user to make a username (OrgID) and password (OrgPassword) and have them apear in my database table (Organizer). This is the code I have so far, but I cannot get it to update the information in the database.
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
if (txtUserName.Text != "" && OrgPassword.Text !="")
[code]....
When I insert a new record into my DB the same information gets two records not one. I am using A datatable and sqlcommand and sqlconnection and sqldataadapter and I'm using me.bindingcontext(datatable).position to move between records.
View 2 RepliesI have an assignment where I have to develop a Windows application using Visual Basic .NET. From the form that I have designed, it should save all records in a table in a MySQL database. How should I do this? Here's what I've got so far:
Imports System.Data
Imports System.Data.SqlClient
Public Class AddMember
[code]....
Display a Dialog Box that asks for some user input. Take that input and add a new entry to an access datatable. Refresh a List Box that displays the Keys from the datatable. Steps 1 and 2 work just fine. After the following method is executed (without closing the program) I can open the Access Database and the data has been stored to the datatable.[code]...
View 3 RepliesI am trying to make a program with a bar code reader for the first time. I am programming with VB 2005. I want to differentiate a bar code entry to keyboard entry. My questions:
1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
i connect database with vb.net and also i receive a single value from my receiver through serial port. now i want to match this single data with one field of database. i have attached my code.
Public Class Form1
Private Sub OPEN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I am inserting data from vb.net to oracle but I am unable to insert datetime except date into oracle. I want to insert date and also time of entry into database:
cmd.Parameters.Add(":STARTING_DATE", (OleDb.OleDbType.[Date].))
cmd.Parameters(":STARTING_DATE").Value = DateTime.Now()
cmd.Parameters(":STARTING_DATE").Value = txtStartDate.Text
I am trying to make a program with a bar code reader for the first time. I want to differentiate a bar code entry to keyboard entry. My questions: 1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
I am developing a program and stuck up with an issue. I am able to enter single value in MSAccess database however, when I create a programe to enter multiple entries I am getting an error. developing a code to enter multiple entries in MSAccess 2002 db with the help of VB based form?
I Following code I am using for single entry:
Private Sub Button1_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Enter
Dim query As String
[code]....
I am trying to create a form which will be fed by an underlying database to create multiple form fields for each entry in an underlying database table. This is for a program to monitor patients under anesthesia, and prior to surgery, the doctor will choose which monitors they will be using. Then, on the actual monitor screen which will pop up every X minutes, there will be a text box and a check box for each chosen monitor. I am relatively new to VB, so I have tried to illustrate what I am needing but using the logic that I know from my previous life in PHP.
I am using DevExpress's layout control to place the form fields, so that is the code in the middle of the first loop (on_load), and I know that part works, I just need to know how to name the fields and then recover those fields and commit the values to the database. (the text boxes are added to the database, the check boxes are used to determine if an entry is made for that monitor- i.e. at the end of surgery if a monitor is turned off). I know that my syntax for naming the fields is no where close to correct, and it probably would not work in PHP, but I remember doing something like this in a PHP application I built long ago. [Code]
I tried to create an insert sql query using a vb.net script and for some reason im getting an error message "sqlexception was unhandled"
Here is the screenshot
and here is my entire vb.net script
[code....]
I'm currently working on a legacy project in VB.NET 2.0.The project has a very funny DAL-layer which does not incorporate transactions :-|Anyway, it's my job to make some parts of the program transactional and I don'thave access to the DAL layer code.So I'm trying to put entire sections of code inside single TransactionScope.
View 1 RepliesI am connecting to a vendor-supplied Web Service running in our domain and am attempting to execute one of its methods. I am receiving the error below (Timeout Expired) and not sure how to fix it. The server is running SQL Server 2000 (soon to be upgraded!) and I have checked the timeout setting which is set to 0 (unlimited)
View 4 Replies