I use this code to rearrange idd column after deleting one row from tab 1 "select row_number() over(order by idd) as idd, id,name,dat from tab1"
now how to save changes to sql db after deleting sevral rows and rearranging idd column?
I have made an app which has id and name and class and tel fields using sql2005 database I made ID field as primery key so when i delete record from table it doesnt rearange it self for example I added record number
1
2
3
4
[code]....
I am fresher in vb.net but I have experience in vb 6.0. But I want to connect database in sql server through sql connection. In that case how to create connection with window or sqlserver authintication mode and how to add or update new record in data base in batch transaction. Please help me with sample code.
So that I can understand eassily.
I have a string like this:
1a2b3c4d5e6f7g8h
And I need to rearrange it as follow:
a1b2c3d4e5f6g7h8
Do you understand what I mean? For each two characters, the numerical character swapping place with the following letter, i.e. from 1a change it to a1.how to rearrange the numerical characters and letters in the string? My string always has the said pattern, i.e. one integer then followed by a letter then followed by a integer then followed by a letter and so on.
How do I rearrange the Settings variables in VB.Net 2010 to be near the ones they are related to? I edited the app.config file to rearrange them, but when VB loaded again they were still shown in the old order.
View 2 RepliesHow do I rearrange the Settings in VB.Net 2010 to be near the ones they are related to?I edited the app.config file to rearrange them, but when VB loaded again they were still shown in the old order.
View 4 RepliesHow do I allow users to drag/drop or rearrange tabs, like in mozilla and IE?I've managed to extend the tabcontrol properties a little but i cant get the dodragdrop method to work....
View 10 RepliesI have a tabcontrol on my form, but I created the tabpages in the wrong order. I tried dragging and dropping the tabpages but that didn't work. How do I rearrange my tabpages?
View 1 Repliesupdate statement, i am trying to update a row within a access 2007 database here is my code.
[Code]...
I am using vb.net with access database. I am using sql. How can i update database with the value 40'6"(Feet and inches values)
View 5 RepliesVb.net I tried to rearrange the DGV Rwos but I don't know how to complete it. as it show in the code ( my request in green line)
vb
Public Sub rearrange()
For Each row As DataGridViewRow In Form1.DataGridView1.Rows
If Not row.Cells(1).Value Is Nothing Then
[code]....
I have several windows open: VB, IE, Explorer... If I happen to close one accidentally, or on purpose, and reopen it, the buttons on the task bar are all messed up. I get used to them one way and I am constantly switching between the windows.Here is my question: Would I be able, in VB, to 'hook' the taskbar and be able to rearrange the buttons?I have no idea what to search for in Google. I happened upon a program once a while back, A REAL LIFE SAVER!. I could just click and drag the buttons using that one.
View 5 RepliesWhat is wrong with this code. It does not update the access database and no error.
Dim conn As New OleDbConnection
Dim sqlQRY As String = "SELECT * FROM StdMaster WHERE StuNo = " & txtStudentNo.Text & " ORDER BY StuNo"
[CODE]...
One of my friends has suggested that in my program i give users the ability to, when holding the Alt key,rearrange tabs in a TabControl when dragging the mouse. But im stumped as to how to do this.
View 1 RepliesI have a form with a large GroupBox on it. Inside there are a total of 22 buttons, arranged in two columns of 11. These buttons are basically shortcuts that can be defined by the user. I would like to allow the user to rearrange these buttons by some simple means. (Drag and Drop being ideal.) I have the following code, which allows me to drag the buttons around:
[Code]...
Iam using sql2005 database in vb.net2005
my table's name = tab1
I have 3 fields
1- ID = auto number =primery key
2- IDD = number
3- name = text
now if I add 10 names in the table from (1-10) =1,2,3,4,5,6,7,8,9 ,10
then if I delete name number 6 the IDD field will rearrange it self from( 1-9)=1,2,3,4,5,6,7,8,9 instead of 1,2,3,4,5,7,8,9,10
is there a way to update a database row with the update command by first defining all parameters and then all values just like you can in the insert command? "insert into table1 (parameter1,parameter2,....) values (value1, value2,....)"something like "set table1 (parameter1, parameter2) values (value1,value 2,...) where ...."?because I only know the syntax to define each parameters value "set table parameter1=value, parameter2=value2... where"
View 8 RepliesThis program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
I created a dataset and i am using OleDbDataAdapter to insert new values to access database. But when i close the program and after open it, values are not in the database. How can i solve this problem? Also, i have another problem. When i write codes that
[Code]...
i want to update my inventory table in database from another database name. Example: In VB, i had a form named Orderform. User need to select e product that they want and key in the quantity. all these information are able to store inside my database named ORDERTAB. but now the problem is i wanted to update another field in my database named INVENTORY by minus the quantity tat the user had key previously. i totally had no idea how it going to works.
View 3 RepliesI got a system which i want to insert, delete, update the data into my database and the data from database will be display using datagrid. The below is the coding for one of my button, delete.
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Try
btnSearchEmpNo.Enabled = False[code].....
Now I wanna set when user click on this button to delete a employee (for example) then the datagrid that i have in my application will not show the data of the deleted employee but in the background, the employee haven't been deleted from database.The employee only will be deleted from database when the user click on SAVE button.I know this application have to use RowState but how?
I figure why this happens, and is because of Windows 7 and its permissions. Now I'm trying to fix this. but the code for this is a bit complicated for me. I found on this website an example on how to set the permissions on files. ([URL])
[Code]...
i am just developing a library management system as one of my project. i using vb.net 2010 and the MS Access 2007 as back end. when i save some records into my database through my application it is correctly saved and i confirmed it through opening the relevant table in the database. but when i restart the application all the entered data were missing..
View 5 Repliesi have the connection to the database.i have a datatable that stores the info from the database.i just cant seem to get the database to update. the program is a website and when the user clicks submits his account is created. if all the data is verified and the screen name doesnt already exist,a new row in the datatable is created and the info is stored in the correct columns. this is where im stuck. whats the next step for getting the data from the datatable to the database. do i have to insert a row to the dataset and accept again, and then with the database?
View 2 RepliesI want to update data in Province table in eUnion.mdb using Form2.
View 1 RepliesIll start this by saying im still very new to VB, ive had some programming expereice here and there since high school, but never really did much with it till now.Ive got a small app that im working on for a side project, i want to add the details of a given days records from a simple POS system i have built up so far. At this point i have all of the information generated and i cant seem to get the app to commit it to the database. I have seen tons of posts on this, and i have followed a bunch of them to no avail. Im sure this problem is because i have the code written wrong, and i cant get it figured out. Here is the code that im using to try to save the data:
Dim hoursworked As TimeSpan = dtpEndTime.Value.Subtract(dtpStartTime.Value)
hours As Double = Math.Round(hoursworked.Hours + (hoursworked.Minutes / 60), 2)
[code].....
I'm currently working on my A2 computing project, and I am having slight difficulties updating and saving the data in my database when it is entered on a form in VB. I cannot find any reason why it wouldn't work, but if someone could suggest a better way to do it, it would be great as everything else works. It's in the btnsave at the bottom, and when you click the button on the form it come up with a very unuseful error, which is no help to anyone.
This is the code for the edit details form, where on loading, the customers details which are currently in the database are already there, and they can change things on it and save it to update their details if anything changes.
Public Class EditMyDetails
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
[Code].....
I 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]...
Here is my
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim NewRow As TimeClockDataSet.EmployeesRow
NewRow = TimeClockDataSet.Employees.NewRow
[CODE]...............
I have experimented with other classes but I cannot get the database to update.
I am writing a program to assist Paramedic students in learning the Drugs that they have to know in order to pass their classes. I have created an Access database to hold all the information on these drugs, but not every student that will use this program will need to learn all the drugs contained within this database.
Right now I have 43 drugs in the database and still growing.
What I want to do is to present to the student the drugs and have them say "Y" or "N" as to whether its on their required list to learn. That way they only work on the ones that they need to.