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]....
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
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) =123456789 10 then I deleted name number 6 the IDD field will renumber it self from( 1-9)=123456789 instead of 1234578910 so in reports and queries the names will appear numberd from 1 to last number with out missing numbers in the middle of numbering I use in MS-Access code which does this perfactly
Public Sub RowOrder()
Dim db As DAO.Database
Set db = CurrentDb
[code]....
How to delete a record or field from a fixed-width file in visual basic code?
View 1 RepliesThere are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
the code for delete a record is just below,but
im
custIdentidade
As
[code].....
how to delete a record from a simple database I've been working on. The code is as follows:
[Code]....
I can;t seem to get this right. the application i'm creating lets the user select a record in a list view(lvList), and by clicking a remove/delete button, this will happen.
[code]...
why cannot delete the record? my code
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
[code]....
I've got a datagriedview and records and i want to delete one record from this and also from my database.My datagriedview is a control and it is filled with records with the method Fill. So I created a delete button like this: 'Me.ReceiptBindingSource.RemoveCurrent() but this deletes a record ONLY from the datagriedview. Then I tried this:
[Code]....
[Code]...
I using the MaxRows in deleting the record, so it just delete the top of the data list, while i want to delete the selected record.
I developing a VB.net application and I'm unable to delete the record from. But my code only deletes the record from the datagridview and it is not being deleted in the database.
I'm using SQL Server Express 2008 and the table name is Admin_Table. The fields are :
Field Name Data Type
-------------- --------------
admin_ID int
admin_Name varchar
[Code]...
I am connected to a mdb using OleDb. The Connection code is :
' GET CONNECTED TO DB
Try' Open a connection to the database.cn = New OleDb.OleDbConnection(strConnection)cn.Open()
' Load Data Adapteradapter = New OleDb.OleDbDataAdapter(strSelect, strConnection)
' Create Auto generated Insert, Update, Delete cmds for Tableautogen = New OleDb.OleDbCommandBuilder(adapter)
[Code] .....
Add & Update are working perfectly, but delete doesn't update in the db. While application is running it shows that data is deleted, but when I run again, I see the same data, so its not physically deleting from the db. Add & Update both are working perfectly even after re-running.Can anyone tell me where am I going wrong in delete part. The row is also proeprly selected. No exceptions, yet why not deleting physically.
I am new in programming and I am using VB2005 and I can user either SQL2005 or MS access database.Here my scenario:I have created a project where the user can add a new record, (Support Desk) there are times when a new record is added, it may need a backup (Pictures, Document)to be included in regards the problem.
I need to know if anyone has some sample code on how to attached any type pf file (jpeg, BMP, doc, txt, PDF, excel) and be able to save it to the database.
How to delete a record in the listview and will update to my database?[code]....
View 3 Repliesis my coding and i want delete the record from grid view and data base also .. but i can only delete from grid view
this my Module coding
Imports System.Data.OleDb
Module Module1
Public con As New OleDbConnection
[Code]....
I would like to test a remote connection to a local Sql 2005 Database first thru Hamachi using a small exe that would be set on the client machine to let me know if the connection was successful or not, in the close future the connection would change to be set thru a VPN but for now i would like to accomplish this by using Hamachi software.i want to code the client .NET exe file to connect to the server, Hamachi gives an IP address and hostname once installed on the "server" machine so i wonder how should i include both in the connection string of the client exe file.
View 1 RepliesI'm trying to delete a record from an access database using the command object in vb.net 2010 express but can't seem to get anywhere.If I run the code below, I get no errors but nothing happens. The connection opens fine but the db does not update.the table has only two columns.The variable strCrit is so that I can build the sql string with exclamation marks, When I debug.print the sqlupdate string it seems to read fine.the routine is called from a form with a button.
Dim sqlupdate As String
Dim strcrit As String
strcrit = """"[code].......
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?
not all in the listbox items are save in database....only the index 0 is saved in the database...i want all to be save in database.
[Code]...
I've been messing around trying to get an INSERT statement to work, and because of this, it has created lots of records in my database that I dont need or want.
The problem is, when I open up the table by right clicking on it in the database explorer and selecting "Show table data", I click on the record I want to delete and the following error comes up in a message box[code]...
delete a record in a database table in crystal report, after the report had been view from the new page and when the page is close.
the report is done in vs2008 c#.
I use This Code To Save Data in Table First I delete record Then Insert record
View 4 RepliesI have a javascript file that contains the function for calling the confirmation delete window, the code used is similar to the following:
function Delete()
{
confirm('Delete this user');
[code].....
I'd like to create code for my datagrid view to be able to delete a row by first clicking the record selector column then pressing delete. Seems like some standard stuff but really difficult to create in VB 2005.
View 10 RepliesBasically, I am making a booking system. On one of the forms, you can: Add, Edit and Delete a record by using the selected index. I can do the Add and Edit part fine but some problems are occuring when I try to delete it. What I'm trying to do when deleting is, copy all the records except the selected one and then copy it back into the original file again.
[Code]...
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page:
<asp:SqlDataSource ID="msgUnread" runat="server"
ConnectionString="<%$ ConnectionStrings:edinsec %>"
[code]....
As you can see I was playing with WithEvents but that didn't seem to help. In the above code all I was trying to get was some kind of reaction to the clicking of a checkbox - but nothing happens (no errors, either).
i have one textbox ,this textbox contains a number ,i want to delete a record by searching that number in two tables Table1 and Table2,the record may present in Table1 or Table2 ,so it should check both the Tables ,if it is found in table1 it should delete or else from table 2 it should delete.
View 3 Replies