I am facing a strange situation. I am having a database inside my my Vb.net application and having various table in it. when I am saving data in my database, the data got saved in it but and every thing works very nicely but after some times means after 5 to 10 minutes the data gets deleted automatically from my database.
View 3 Replies
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 Repliesif i modify a dataset's datatable, does the data in the sql database will automatically get updated?
View 2 Repliesi am working on a Windows Forms application using VB.net. It basically is an application made in vb 6.0 being upgraded to vb.net. Now i have an idea but i am not sure if it exists.
Say i have a database (My_DB) and it has a table (item_details).
I wish to make dataentry into the elements of item_details table which currently has 6 fields. So i add 6 textboxes and 6 labels and make user enter them, one record at a time.
Say tomorrow i add or remove a field from the table item_details. I want such a mechanism where if the underlying table structure changes, the corresponding number of textboxes and labels must automatically change themselves. i.e. if i remove a column and now i have 5 columns, the form must also have 5 labels and 5 textboxes. Are there any controls to achieve this functionality. Am i talking MVC here?
I have a table adapter which is bind to a grid, and I have three button insert, update and delete. Insert and update are working fine, when I delete a record in grid it is been deleted but it is not been deleted in database. Once again if I run the application the deleted record is shown.
View 4 RepliesHow will I transfer deleted record into another table instead of deleting it permanently? I think it is what we call "history"..somehow..For example I have 2 tables. 1 is Original_Record the other is Deleted_Record. If I deleted one record in Original_Record, the deleted record will be transfered into Deleted_Record table.
View 6 RepliesI have the following code to delete a row in an Access Database Table. It executes with no errors, but the row is not deleted.
Code:
Dim adpMasterRecipe As OleDb.OleDbDataAdapter
Dim dsMasterRecipe As New System.Data.DataSet
Dim iIndex As Integer[code].....
VS 2010, VB.NET, WINFORMS. In my app i have a need to import foxpro database tables and exclude the deleted records. The problem is that FOXPRO tables keep deleted items inside the same table. I have tried using DELETED=NO in the connection string but vb throws "Format of the initialization string does not conform to the OLE DB specification."
My function is as follows:
Dim _DBConn1 As String = "provider=vfpoledb.1; Data Source = " & file1 & ";DELETED=NO"
Dim _DBConn2 As String = "provider=vfpoledb.1; Data Source = " & file2 & ";DELETED=NO"
Dim _DBConn3 As String = "provider=vfpoledb.1; Data Source = " & file3 & ";DELETED=NO"
Google results pointed me in the direction of DELETED=NO but its throwing that exception error now that I have added it..
i did this code to delete data from the database and update the dropdownlist of the combobox(i.e,remove the deleted data from the dropdownlist of the combobox):
Private Sub Delete_Btn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Delete_Btn.Click
Dialog1.ShowDialog()
[Code]....
I really am stuck. I can add records to a table ok . when i close and restart my code the new records are still there but deleteing does not work. I delete the records, they disappear. I close and restart the code agian but the deleted records return. this is my code.
[Code]...
I have a basic Table and I can add and save data, but when I try to delete, I het this error:
[Code]....
What I'm working on is a video rental project in visual basic 2008. I have a local database which contains info on DVDs, Members and a table for current rentals.The columns i have in the current rentals table are:
MemberID | DVDID | DaysOnRent | DateRented | DueDate | Overdue | TotalPrice
I have this data displayed in a datagridview, but the user adds it through a seperate form (called add a rental) with a 'details' view of the table on it. I've written code to automatically determine the TotalPrice and DueDate of the DVD in the add a rental form.
The Problem:I don't know how to get the database to automatically detect when a DVD is overdue (when todays date is greater than the DueDate).I want it to check it in the column "Overdue" (which is boolean)..so basically what I'm asking is how do i update the overdue column automatically depending on whats in the DueDate?
Using Visual Studio .NET 2008 or 2005, is there a way to automatically generate properties for each column in an SQL Server database table? I am assuming other code-generation software exists that will do this. I know with Visio I can connect to my database and it will generate diagrams by table, this would be similar to that.
View 6 Repliesi have here a code for my back up:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim dbload As String = Application.StartupPath + "\Enrollment System.accdb"
[code]......
Im wanting to pull some data from our Remedy Server every so often. Right now we're having to do it manually; Data > Import External Data or New Database Query. The connection is called AR System ODBC Connection Source. We have to log into the server and then it pulls the info into the sheet. Im needing even if have to setup a conection myself first to just have this conection run every couple or two and update the excel sheet. We're using excel 03, Remedy 7.
View 2 RepliesI am using a combobox in VB .net to show customer's name. They also can type new names if they wish. Can I somehow save these new names in my sql database dynamically?
What I mean is if the name is new and does not exist in my database, can it be automatically saved to the database?
My combobox is bound to my name table.
I was just wondering if this is possible. I have a site that admins use to add products to our database. The database is in SQL Server 2008 and I use Visual Studio 2010 using VB.net and was hoping that upon addition of a new product, it would automatically generate a folder assigned to that product's ID.I haven't found anything online that would suggest that this is a possibility, but it would make it a lot easier for me. As of right now, I have to remember to create a folder in the X: drive for each product that has been added. We are up to 645 products now,
View 2 RepliesI'm working with time and attendance application and i need to do something will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
[Code]...
I'm working with time and attendance application and i need to do some thing will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
textbox1 for inserting start of employee code
textbox2 for inserting end of employee code
textbox3 for inserting the date and time for enter
textbox4 for inserting the date and time for leave
I have two tables: HolidayRequests & HolidayEntitlementWithin the Holiday Requests I have 1 field:DaysWhen a staff member adds a holiday request it is stored as a number in the holiday requests table in days field (there are multiple requests with different days)
View 2 RepliesWhenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will not be[b] retrieved[/b] properly as the [b]previous form[/b] will [b]not be updated[/b]. I hope ur understanding ...
[Code]...
I have a piece of code connecting to my database retrieving data. I was just testing the form on another computer and everytime it loads this specific form it closes the form.You can see the lines I had to comment out in order for the form to NOT close on load. Is there something possibly that needs to be installed on this other computer? running XP pro 32 bit.
Dim conn As OleDbConnection
Dim comm As OleDbCommand
Dim dr As OleDbDataReader
Dim connectionString As String
[code]....
My project is about recipes. I want to automatically create table inside in mysql database when I hit the add button on my project through codes. First is when I input recipe name in the textbox1 then my input will be saved in the recipes table under recipe name column and also create a new table through codes on what i input in the textbox1
Example of my database in sql
texbox1 input will be save here
recipes - id, recipename
And then it will also automatically create a new table in mysql database, create newtable, with id, quantity ,unit, ingredients
Private Sub iadd()
Dim command As New MySqlCommand("insert into recipes (recipename) values ('" & TextBox1.Text & "')", connection)
Try
connection.Close()
connection.Open()
command.ExecuteNonQuery()
[Code] .....
I would like the client app being able to refresh the data every 30 minutes.
View 2 RepliesIs there any way to automatically update the data viewing on a datagridview when data is changed in the database by some other processes/Program?
View 4 Replieswhen i input data to a textbox1 and then i press enter using keyboard, then another description will appear in textbox2. For example, i have to key in a company's code: A001 into textbox1, after i press Enter using keyboard, the company's full name will appear in textbox2.
View 4 RepliesI've searched the forums but never seems to find an answer for this one.. I recently connected to MySQL database server "Automatically" in Visual Studio 2010. I want to know if there's a way to determine the connection state for "Automatically created" connections in Visual Studio 2010. I know how to do it for"programmatically created" connections but just want to know how on the auto-generated ones.
View 1 RepliesI would like someone to modify the following code to save data to generate the primary key for each record automatically. In the database,the ID column is the primary key and the Is Identity is set Yes.
Try
cmd = New SqlCommand("Insert into StudentDetails.programmes(ID,Programme,Form,AcademicYear,Class) values(@ID,@Programme,@Form,@AcademicYear,@Class)", cn)
cmd.Parameters.AddWithValue("@Programme", txtProgramme.Text)
cmd.Parameters.AddWithValue("@Form", txtForm.Text)
cmd.Parameters.AddWithValue("@AcademicYear", txtAcademicYear.Text)
cmd.Parameters.AddWithValue("@Class", txtClass.Text)
cmd.ExecuteNonQuery()
MessageBox.Show("Record successfully saved", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information)
The primary key of the table is generated automatically using the Is Identity and I want to update based on the primary key. There is certainly something wrong with the following code, so I'd like someone to modify it for me.
Try
Dim qry As String
qry = "Update StudentDetails.Programmes set Programme=@Programme,Form=@Form,AcademicYear=@AcademicYear,Class=@Class where ID=ID"
cmd = New SqlCommand(qry, cn)
[code]....
I've a SQL DataSource and a Datagrid in a Web Page. The data grid gets binded automatically when the page is loaded. How do I delay that until click event of a Button.
View 1 Replies
