I have an app. MDI Parent and several forms,connected to SQL server 2005 via ODBC, and form1 is my app. main form.What I try to do is,
1-when insert data into the database if data already exist then it don't do anything and popup message let you data already in the database.
2- How to prevent end user modify textboxt1 on from1 if there is value in textbox1?
how can i insert data to database using datagridview in vb.net? i want to use the datagird as input filed. i dont want to bind the gridview.
View 5 RepliesI have exported data from a SQL Server table into a XML file and the output looks like this:
Filename = 11190.xml
Table name = LRTest
<NewDataSet>
[Code].....
Now I want to save the above XML file into my SQL Server 2005 table
With the same columns using vb.net windows forms, in every exported xml file there are 100 to 200 records. .
How would i go about stopping a form from being moved. I have the form border style set as FixedSingle and would like to keep it this way because it looks good in vista :)
View 10 RepliesHow could I prevent a Windows Form from automatically docking when the form gets dragged to the left or right side of the screen in Windows 7? This is a neat feature in W7, however, for my form it does not make sense (a data input form). Sometimes I drag the form to the right to read some information on a website and input them, yet, under W7 this form docks onto the right half of the screen when I do so.
View 5 Repliesi already develop system using VB.net with Microsoft Access 2003 as my database. when i running in Windows XP it's working great but when running in Windows 7, i can't insert into it..
View 2 RepliesI would like to insert Radiobutton text value to my SQL database. I'm using Radiobutton for gender selection. I tried the code femaleRB.checked but it return a true value on my database. I want the text "Female" shown on my DB.
View 9 Repliesi am using vb.net(2008) and MS access as my database.[CODE]...
now i want to insert into these tables. how can i do that? i know how to insert into a single table for example listed below, so how can i modify that so that i can insert into multiple tables[CODE]...
Inserting remote image onto windows form in vb.net?
View 1 RepliesI have a Windows application form. Directly on the form I have a lable ("Customer Names"), a ComboBox (pulling actually names from a database) , and a Buton to add a customer to the database if i choose. Additionally I have ControlTab(3 tabs) that has "fields" and its own Buttons to insert data into a different table. The first 2 tabs have textBoxes, which are completely functional, but the 3rd tab has a "DataGridView"
[Code]....
I want to insert a Windows Media Player object in my Form, but I have not the control on my Toolbox.
I have done the steps:
Right-click
the Toolbox -> Choose item -> COM Components -> add Windows Media Player component
(which references to C:WindowsSystem32wmp.dll)
But there is not the control on my Toolbox.
In my project references I see "MediaPlayer" into "Imported namespaces" and it is checked. In the references window it is also present "Windows Media Player". Where is the error?
Is there an easier way to prevent a duplicate insert after refresh? The way I do it now is to select everything with the all fields except ID as parameters; if a record exists i don't insert. Is there a way to possible detect refresh?
View 8 RepliesI have a form with a series of text boxes to accept user input and a button that should basically run an INSERT statement to a SQL database.I'm baffled at why I cannot figure out how to code this. All of the samples posted on the web are for VB 2005/.NET and the syntax is definitely different in 2008 because attempting to copy+paste to just test some of their source is just littered with errors.
View 8 RepliesI have a project in which i have a form in which there is add button to add pages. In form load the last entered page populates all the fields. Now thing is if user edits the values in controls it has to update the db with those fields and if the page doesn't exist in db it has to insert.
Here is my code
Private Sub inserting()
Dim cn As New OleDb.OleDbConnection
'Dim selectquery As String
cn.ConnectionString = ""
Dim cmd As New OleDb.OleDbCommand
[Code] .....
I initialized a global variable x and set its value to 0 in page load and in add button click to 1. Depending on x value it either inserts or updates the db in form closing and add button click. Now whats happening is If the user clicks on add button the page increments but if user doen;t enter any values and tries to close the empty form, value of x =1 and it tries to insert but as there are blank fields cmd.executenonquery throws an error.
"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."
What should I do so that it doesn't give an error. I am using access db.I even checked in db Except for primary key(pageno) all other fields have "allow zero length" as YES & "required" to NO.
Inside my application, I need to insert data from two sources: table and form textbox. So I tried to use the code below, but the message box is displaying an error. (I am using vb.net)
Error:
While inserting record on table ..Syntax error (missing operator) in query
Code:
Dim con As New OleDbConnection
Dim cmd As New OleDbCommand
Try
con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:UsersDellXPSDesktopmDB.accdb"
[Code] .....
I have been struggling with getting FormViews to work the way Microsoft expects me to for about a day and have figure a bunch of great stuff out.
I can catch e.Exception and e.ReturnValue in the ObjectDataSource.Inserting Event Handler and I can even cheat and check other properties of the Object in the ObjectDataSource.ObjectDisposing by checking the e.ObjectInstance ... and I even learned that FormView's Inserting Handler Runs AFTER the ObjectDisposing Handler so If there is a problem found I still have time to react to it and st the e.KeepInInsertMode to true on the FormView.
My problem is, it seems that the values entered by the user into the Insert form are cleared regardless.
So, How do I Prevent a FormView from clearing after it's Insert Method has fired?
(Using ASP.NET + VB)
I don't think posting my code here will really do much good and i would have to modify it to trim out confidential business logic stuff... so I'll skip it for now.
edit:
I have found a temporary and admittedly terribly cludgy solution (in case no one ever finds a REAL solution to the problem).
I have a page variable defined as:
Dim eInsertArgs As FormViewInsertedEventArgs
And then I do the following in my ItemInserted handler
If boolInsertErrorOccurred = False Then
e.KeepInInsertMode = True
eInsertArgs = e
[Code].....
The effect of this is that I am setting the values BACK to the submitted values AFTER ASP.NET binds the FormView to the default (blank) Template.
I wish to prevent windows from going to sleep while my program is running.
I did allot of searching and found in MSDN the "SetThreadExecutionState" but could not find a way to make it work.
example code for preventing the sleep?
I am using windows 7 and vb 2008.
I have the need to either prevent, or restrict, the termination of a VB.Net application. I have no problem with Admin killing the application, but not a user. I've been unable to come up with a solution for this. Is there maybe even a way to set local policy to prevent termination by non-admin?
View 2 RepliesI imported an image with a conflicting name as an image file in resources. Then the project crashed. I can't open the resources. It only shows a message as "There is already another resource with the name 'Cr'."The compile errors show that "'Resources' is not a member of 'My'".
View 3 RepliesI am making a webbrowser,how to prevent my browser from opening new IE windows. Because what happens is, there are some links that will open new windows and therefore IE comes in place because it is set as default windows browser which I really don't want because my browser looks really bad if it opens links in another webbrowser.I want it to be just a basic browser, it has only one window, and it should navigate within that window. This is because the browser is integrated in a bigger application only for some website applications that are related to this main application.I am using VB.net 2008 Express Edition?
View 9 RepliesI have a combobox which is reading a directory and display the files in the path, I want to select a value in the combobox and display this in a textbox but it crashes whenever I try to do this.
[code]...
New to Visual Studio 8 running on Vista with Office 2007.Attempting to create first simple form with data grid using Nwind.mdb Customers table. Data source is created and using Preview data actually shows the data contained in the table.After dragging the DataGridView onto the new Form1 no data appears in the grid when the form is run.
View 4 RepliesThis is a question that has been bugging me for a while and I am no longer working in this so sorry for the lack of code. The situation is this I had a web service that in the client and the server page it had compression and it had encryption. It didn't work all the time because there was accents and that crashed the encryption but when you set it to UTF8 it got fixed. Still there was a set of data that was very BIG and it exceeded the limit of normal string 33 thousand or something characters.
This step happened in the packing and unpacking steps of web services. What was being returned is a Dataset(that in webservices it converts to an XML). I know StringBuilder can be helpful but I assume that when you change it toString() it will trim the string to the max limit.
i want to save the form name in data base and load form using that saved name. How would we achieve this task?
View 5 RepliesI am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim SearchPatient As String = txtNPatientID.Text
[Code].....
I'm making program that will copy one file and over-write another to purge data.I have a windows form interface where the files can be selected and want a console application to run this process so it can be put into the PC's startup folder to run on each startup.
The problem is I need to send the file location data to the console app when I choose a save button on the form. Both are part of the same project and referenced but I can't seem to reference any variable from the win form to console app.Also will I see the Console app as a seperate icon in the program files so I can put it on the PC startup?
For example, is this an acceptable way of checking that fields are not empty before submitting data to a datatable/database? Right now, Im simply checking with an If statement, and I'm starting to think that this is not the correct way to do it.
I'm also trying to learn more about unit testing, so if you have any tips or tricks, please feel free to share.
[Code]...
I am working on an OpenGL Visual Basic 2010 Express project using Tao.dlls.My computer has crashed a few times while I was last working on my code.Since then There has been some side effects such as intelisense and autocomplete not working when I load the project, even after checking the options and settings for them.When I start a new project on the other hand the features work again.Also when this OpenGL code is run:
Code:
glutMotionFunc(AddressOf MouseMotionGUI)
I get:
BadImageFormatException unhandeld
An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
This code was working fine before my computer crashed and probably corrupted some files.
I got a legacy solution targeting .net framework 2.0. When I open the properties - Compile tab of the VB projects in VS2008 or 2010, the VS always crashes. Other C# legacy projects are working.I am using windows 7 64 bit. (It's working in the xp mode.)
Activity Monitor Log
infos 50
warnings 0
errors 0
# Type Description GUID Hr Source Time
1 Visual Studio Version: 9.0.30729.1 Microsoft Visual Studio 2010/12/22 12:44:57.002
2 Running in User Groups: Administrators Users Microsoft Visual Studio 2010/12/22 12:44:57.004
3 ProductID: 92357-152-0000034-60049 Microsoft Visual Studio 2010/12/22 12:44:57.004
4 Available Drive Space: C: drive has 139105247232 bytes; D: drive has 284777865216 bytes Microsoft Visual Studio 2010/12/22 12:44:57.005
5 Internet Explorer Version: 8.0.7600.16700 Microsoft Visual Studio 2010/12/22 12:44:57.006
6 Microsoft Data Access Version: 6.1.7600.16385 Microsoft Visual Studio 2010/12/22 12:44:57.007
7 .NET Framework Version: 4.0.31106.0 Microsoft Visual Studio 2010/12/22 12:44:57.008
8 MSXML Version: 6.30.7600.16385 Microsoft Visual Studio 2010/12/22 12:44:57.009
9 Loading UI library[code]......
I use windows Vista.I had been working intensly on a new program all day today and pretty much all day yesterday. I was almost finished.Then my computer crashed. I rebooted.When I came back into Visual Basic 2010 express, I expected that somewhere I would see my files. Besides... I HAD BEEN SAVING THE FILES ALL DAY LONG USING CONTROL+S on my keyboard. The little * symbol at the top of each file would go away. I assumed that meant it was actually saving my work as I went along. I did not, however, actually go to file->SAVE at any point along the way.
After coming back into VB2010 express, no autorecover dialog appeared. I looked for my project in the list, and it wasn't there. I looked at "recent files" and "recent projects" and found nothing. Finally I searched my whole hard drive for my project, and found only one EMPTY directory located at:
C:UsersDellLaptopDocumentsVisual Studio 2010Backup Files, which matched the name of my project I had spent the last two days working on.