i am using MS-Access 2003, VB.NET 2008, I am able to select and delete recordes. But how can I move between records?
Imports System.Data.OleDb
Class Window1
Dim cn As OleDbConnection
[code]....
This is what I have done so far but how can I movenext,last,previous,first? The way we used to in vb6 with recordsource.
I have one form that display records and I use BindingNavigator to navigate trough the record. I want use also the wheel mouse to go up and down to the record, it's possible do this?
View 3 RepliesA VB.net program reads the queue and calls a stored proc in SQL Server that processes and then inserts the message into another SQL Server table and then deletes the record from the oracle table.
We use a DataReader to read the records from Oracle and then call the stored proc for each of the records. The program seems to be a little slow. The stored procedure itself isn't slow. The SP by itself when called in a loop can process about 2000 records in 20 seconds. But when called from the .Net program, the execution time is about 5 records per second.I have seen that most of the time consumed is in calling the stored procedure and waiting for it to return.[code]...
I created a dataset.xsd and it contains two table adapters and these table adapters use stored procedure for select.in my vb form, i get value in text box and then fill table using tableadapter and pass parameter to sp. Till this point everything is working fine. Now these tables have relations and i want to create relationship and show the data from child table on basis of master table. How i can do it?
Example
Me.MasterTableAdapter.Fill(Me.dataset1.spMaster, 1) --1 is parameter which is passed to sp
Me. ChildTableAdapter.Fill(Me.dataset1.spChild,1) --same parameter is passed to child table.
Now i have the records in spMaster and spChild. how i create the relationship so that when i move thru Master the child have corresponding records?
how do i copy and move the entier contents of a directory to another ussing VB.net then also delete the files from there original directory?
View 1 RepliesI have three listboxes in an array and on form_load the listboxes initially select the fifth item in each listbox:
Private Sub frmSample_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
For i As Integer = 1 To 3
I can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]
View 4 Replieshow to get records into oracle database delete from db & update the records i have successfully connected my vb 2008 win form with oracle 10g.
View 1 RepliesHow do I update records in a dataset with records in a transaction file?
View 3 RepliesI want to search the records from the textbox and display the records to the datagridview, if there are no records, just display empty on the datagridview.
this is not working:
Dim sqlsearch As String
sqlsearch = "SELECT * FROM setting WHERE mname LIKE '%" & TextBox.Text
[code].....
I have this piece of code wich works perfectly when inserting records into one table using records from another table. My question is that now i need to create another table by using records from 3 other tables (tables are related). Can i use aliases on the column names, like on Oracle SqlPlus? How will be the syntax of the 'INSERT INTO SQL statement?
Dim MyConn As ADODB.Connection
Dim MyRecSet As ADODB.Recordset
Dim tmpSQL As String
MyConn = New ADODB.Connection
[code]....
I am working on creating a program that records animal data (wombats) and stores it into a database, using vb.net. I am trying to add new records into a database but every time I click add, to execute that, there are duplicate records that gets added. How do i write the code so itonly adds it one time. I am using a data reader. Here is the
[Code]...
What does this error mean? I havent modified anything in the designer code, but its giving me an error? WithEvents variable 'Move' conflicts with event 'Move' in the base class 'Control' and should be declared 'Shadows'. The error relates to Friend WithEvents Move As System.Windows.Forms.DataGridViewCheckBoxColumn
View 1 RepliesIm working on my project. and i just asking if i can used this Property in vb. NET [URL] when i install adobe photoshop .. i see on the leff installer...something like a menu and the menu move step by step when the user move between Forms
Welcome
Serial Number
Adobe ID
Install
Finish
How i can create like this in VB .NET
I want to search the records from the textbox and display the records to the datagridview, if there are no records, just display empty on the datagridview.[code]
View 8 RepliesI have a dataset containing 2 tables,Customers and Contacts. Just showing the master-detail is not a problem. Problem occurs when I try to search the master table to bring in the detail table. Searching the master table shows only the master record, but not the related detail records. Adding a 'findby' query on the detail table only shows the records.url.. Normally when the master table is filled, the detail record shows in a form.
View 1 RepliesI have a database with 3 tables: Student, Unavailability and Duty.The fields for Student are entered in a form I have. One of the fields in Unavailability is filled by a form, the other fields are an autonumber and a foreign key to the Student table.ow I want records in the Duty table to be created and automatically filled in depending on what the values of the fields are in the Student table.For example, If the Boarder field in the Student table is 'yes' then I want the Duty Number field in the Duty table to be '1', '3' and '4'. If it is 'no' then I want the value to be '2' and '5'. I recognize it will have to create several different records to incorporate the different duty numbers for each StudentID. Obviously this will require an if statement, however this is my first time implementing a database with my limited experience with programming and Visual Basic, so I don't know how to refer to the specific fields in a table and set the value of other fields depending on the data in other fields.
View 6 RepliesI've got a form with a list box that allows the user to move items up and down depending on their order of display preference.I would like to reorder the XML file accordingly so when it is read in it matches their settings.Here is a sample of the XML. I've been able to search down to the hole node and delete it, so I've got a small start at this:[code]I'm just not sure how to go about inserting it in a new position.
View 1 RepliesI've written an app in VB2008 using a Windows Vista laptop. My problem is that when I run the app on my XP desktop, the fonts look a little blurry/ blocky. I've attached 2 screenshots (which don't really capture the issue too well unfortunately).The 'Vista' screenshot is the one I am happy with - it looks fine on screen. The 'XP' screenshot looks blocky. (If you look at the 'O' in 'OK' you can really see the difference.)
View 5 RepliesI am trying to move a folder[code]...
I get the message "Cannot create file when that file already exists"
I tried to make a simple game with a picture just moving to the goal. However, I can't move the picture at all.
Here's the code
Public Class Form1
Public Event Up As KeyEventHandler
Private Sub PictureBox1_KeyUp(ByVal sender As Object, ByVal e As
[Code]......
(Note: I first gonna make the picture box move b4 I make the rest of the code)
How does one go about moving a directory using VS2005? I have a treeview that is populated with the network's directory structure, but only on a much smaller scale. When the folder is selected in the treeview, the full path is displayed in a label.
This is the source folder. The destination folder will be hardcoded. The issue is that its only moving the files within the source folder and not the folder and its contents. I have tried using the Directory.Move but kept getting an odd error, "Cannot create a file when that file already exists." It doesn't exist in the destination folder...odd[code...]
I know that pressing ctrl- will take us to the last place. What about if we want to move forward? Also where in the vb.net documentation is this mentioned?
View 1 Repliesi want to move through the database searching for data.i know that with vb and access we used movenext movelast, BOF ,EOF that type of thing.now i am using sql and VS2010.
View 3 RepliesHow do I move a row in a DGV from one position to another? ie. I need to move the contents in row 10 to row 3, and have all the other rows move down
View 10 RepliesHow can I Move a frame into another using vb.net?e.g.I have these two files
Frame.vb
NewFrame.vb
within Frame.vb on the load code i want to move NewFrame in to Frame.also if i put a button in Frame.vb on that clicks button event i also want to move NewFrame.vb in to Frame.
I have drawn a rectangle using GDI+ but I need to move the rectangle with the arrow keys. I have the code to do it, but there is something wrong with the code: the rectangle won't move.
[code]...
Currently, in the first gridview, is a list of groups a member has access to. The second gridview is bound to a table that contains a list of every type of group and has an Add button which adds it to the first gridview and updates a table adding that group to a member.
This is what I am trying to do:
When the Add button (in the second gridview) for a row is clicked, it will be added to the first one (like it currently does), but I would also like it to disappear from the second gridview. So basically, a group should only be visible in either the first gridview or the second, not both. The problem I have is I don't want to modify the table because obviously the table contains all possible groups.
I'm making a space invaders game and have simply used pictureboxes for all the aliens and the tank etc. This is really slow during gameplay so i'm hoping gdi+ will be faster. I've been researching how to do this for hours on end with no success. All I want to do is create a gdi object in the form of a bitmap or jpeg and for it to move across the screen smoothly at reasnoble speed.
[Code]...
Like the title says, I have about 10-15 rows in a local dataset. I need to take any one row,and make it the "default" (on a button click), meaning to take that row and stick it right at the top so it comes up first.I've been up and down the web for a few days looking at ideas, but I can't get around this one. Do I create a new row at the top, then have it copy the info over, then delete the old row, or is there a cleaner way of doing it? Does anyone have a code snippet they'd like to share
View 4 Replies