When new record is added, I want the vb to look at the last record in the database, look at its id, add 1 to it (+1) and generate a new number and display it in the IDTextBox.
View 5 RepliesI have a Combo box that list invoice numbers. When a user creates a new invoice I would like the Combo box to display that number and not the first number as it currently does
View 2 RepliesI have a multi line textbox (in a windows form in vb.net application) that displays values from an array. What I would like is to have the height of the textbox increase automatically so that all the rows are visible in the textbox without the need to scroll down. Also I would like to know how this will affect any controls directly below the textbox in question. ie if the textbox grows in size, will it push the items below it further down or will it overlap them?
View 4 RepliesI've got vb Express and want to increase the version of the build file automatically. I know it can auto change the publish-version, but i never publish files. I use the build option and get the application at: ...Visual Studio 2008ProjectsWindowsApplication1WindowsApplication1inRelease. So how can vb increase the revision or build number automatically?
View 2 RepliesI have a access database with these columns. USER_ID,COUNT,TIMES
Let say the current record is this:
USER_ID,COUNT,TIMES
STEVE20,24,1.5
Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my query?
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 RepliesI've got a groupbox on my form. I changed its font and fore color. The problem is that when I add a button or any other controls like a label, checkbox etc to the groupbox, the controls are automatically changing their fore color and font to that of the groupbox. How to prevent this?
View 5 RepliesI added a groupbox and changed its heading's font and fore color. The problem is that, when I add a button to this groupbox, it automatically changes its font and fore color to that of the groupbox!How to prevent this from happening?
View 2 RepliesI'm having a problem with a MySQL query for returning the "last visit" field in a table.Originally I had:select fname, lname, last_visit from patient where isactive = 1 and uid = 1Which worked perfectly in MySQL, but as soon as the query is executed by my ASP.NET app, it adds in the time field also to the date area. So 2011-12-12 becomes 12/12/2011 12:00:00 AMI tried this also, with no improvement:
View 2 RepliesMy system still show the "record has been added" and save/insert the data even if i chose the "no" button. I think I miss something on our codes. Should I add something?
Here's the scenario: If "Yes" (button) will be clicked, it'll save the data and clear the fields. If "no" (button), it'll clear the fields and shouldn't save anything.
Here are the codes:
Private Sub btnsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsave.Click
If newname.Text = "" Or newaddress.Text = "" Then
MsgBox("Please fill-up all the requirements.", vbExclamation, "*** System")
Else
[CODE].........................
I'm trying to code an 'increase' button to prompt a user to input a rate by which to increase select prices in an array.It should request the increased rate, then request a number from one to five, representing which price in the array to increase.Then, if 'increase' button is selected again and another number from one to five is chosen, then that element should be increased.It's working, but all the numbers in the array are changed. And, when I hit the increase button again, the array is repopulated below the first price increases instead of only replacing the designated price.
'declare 5 element array of prices
Dim prices() As Double = {12.2, 8.5, 12, 50, 2.4}
Dim rateIncrease As Decimal
Dim isConverted As Boolean
[code].....
I'm using the following code to add a new record to a table in the database. However, the DataGridviewthat's binded to the DataTable, isn't getting refreshed /updated.[code]...
View 8 RepliesI wana know how can i use a value from a sql table that i added from another form?It basically supposed to validate that whatever was the last recorded added in the other form(eg formA) , i must then use those same values from the sql , into another form(eg formB).If i type a value in the textbox( in formB), it basically must validate that, the value i typed in, is not the record that was enterd in the other form(formA) (the last record added in that form)
Here is my coding that i did:
Dim conmid As New SqlClient.SqlConnection("Data Source=CHETS-TOSHIBASQLEXPRESS;Initial Catalog=PlanetDiscLibrary;Integrated Security=True")
[code].....
I am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. The copy and paste below from VS is a little messy. When I execute this code below the record is not added and I do not get an error of any type. When I go into debug mode, all of the parameters are correct and everything looks good. If I open up Access I can manually add the record but using my program nothing happens. All datatypes are string in VS and text in Access.
First an instance of the Customer Class is created and this seems to be successful. But when I take that customer object and run the AddCustomer method of the customer class it is not successful in that the database does not reflect that the record was ever added. [Code]
This code is driving me nuts. I have no idea what I could be missing that is preventing a record from being added to the Database. Here is what I have
[Code]...
What is the best method to reference a new record added to SQL?
View 8 RepliesI am working on a project for a class, and am having trouble getting my program to automatically calculate the subtotal every time an item is added to the shopping cart list. I've tried sub procedures and functions, but I can't seem to get it to work.
[Code]...
I have written a code which adds some information to a database. No problem with that since the records get inside the database. My problem is that the record I added always shows up on my Search. I tried changing the variables so that none will have the same names between the two forms but it still shows.Example:
1. I added a record of a book which has an id of 1, name of Cisco, and total of 50. I added it thru the debug function.
2. I added a record of a book which has an id of 2, name of Link, and total of 30. This time, I added it directly on the database file itself.
2. I created a search button which will show records depending on the input of the user.If I type "1" for the ID, the first record will appear on the datagrid. If I type "2" for the ID, both records will appear. If I type "3" which I doesn't have any record with, the FIRST record will still appear. To summarize it, the record that I added through the program itself will always show up on the query results, no matter what I type into.
Dim command As New OleDb.OleDbCommand
Dim adapter2 As New OleDb.OleDbDataAdapter
Dim bkId, bkTtl As Integer
[code].....
my form isn't showing my newly added records in the database but when i close it and then open again it will show. I want to know how to add refresh button and it will automatically refresh itself..
View 4 RepliesI have run into this problem a number of times, and I am not sure what I might be doing wrong - or if this is just a bug, or not going to work.I have a collection that I setup on my own (eg, collection class). I then cycle a Log file that has text entires and I read those, and then parse the entry and attempt to add it to my collection.
But as each entry is added, ALL records just get duplicated - in other words, as I add entry 2, both entrys 1 AND 2 wind up with the same values - as I add 3, all 3 entries get the same value - and this continues no matter how many entries. For example,
if I added 100 entries, I would have 100 duplicates of the last record added.I have stepped through the debugger and watched this occur and just cannot figure out why this is not working as it should. Here is the code...
While
Not objReader.EndOfStream
' Read one full line
[code]....
No matter what I do, my lstSent collection just winds up with EVERY entry being the same as the last entry added.
End
IfFalse'
Add the elements into the collection if its a "Sent" itemElem = objReader.ReadLine
I am developing an ASP.Net VB Web Application
The application contains a GridView which displays the records of a user table from my created datable. The database is an Sql server database.
The code below inserts data into one table and through the built in function @@Identity to insert the most recently added record id (tt_id) from the trainingTbl table and inserting that record id into the userAssessmentTbl. Adding the identity to the second userAssessmentTbl table works fine.
[code...]
The issue I'm having seems to be centered on how I insert a uniqueidenifier from a GridView into a userAssessmentTbl database!
And how, I guess using a loop I can insert the UserId records from that Gridview (GridView1) into the userAssessmentTbl table along with the looped id from the @@Identity.
This part of the insert parameter seems to be incorrect:
[code...]
And the error I'm met with is: 'Conversion failed when converting from a character string to uniqueidentifier.'
I've also tried it like this:
[code...]
And im met with the error: 'Operand type clash: int is incompatible with uniqueidentifier'
The qusetion has slightly changed to how do I Insert a String into SQL DB Where DataType Is Uniqueidentifier?
I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do not get an error of any type. When I go into debug mode, all of the parameters are correct and everything looks good. If I open up Access I can manually add the record but using my program nothing happens. All datatypes are string in VS and text in Access.
First an instance of the Customer Class is created and this seems to be successful. But when I take that customer object and run the AddCustomer method of the customer class it is not successful in that the database does not reflect that the record was ever added. [Code]
I've read about @@Identity. I've also read that it's no longer supported. I get lost in the mountains of data searching provides.I'd like to get the "ID" field, which is an AutoNumber Primary Key field, when I insert a new record. There's got to be a simple way.
View 1 RepliesIs there a way to have a record automatically save like in Access? I would like to save the record before going to the next record or before exiting.
View 2 RepliesWhen I add, update or delete a record using DataGridView, which events should I use for applying these changes? I'm binding DataGridView's DataSource property programatically. I only connect it with a DataTable. I'm not using a BindingSource. Is this the reason why doesn't DGV apply record changes automatically?
View 1 RepliesI have been working on a project which is used by a company's sale team, to combine all the wanted input data in one place allowing the sales team to show customers, where switching to them could save them money.
Basically what i want is a program which can save single records, which can hold data added in other text boxes, or indeed take the data from the list view boxes which is the intended output. I want to be able to save that data, then be able to Open it up again at a later date, and even modify it.
enabled me to save the three ways to identify a single record, the index number, company name and the date it was added. However I now need a way to save the data entered in my other forms to these single records.
I would like to get message, or true result when DataSet get new record (new row). But, I always get message as "no". [code] Button3 should return "Yes" as new record has been added, but does not? [code]
View 2 RepliesI am using Visual Studio 2005 (Visual Basic) and MS Access 2003 I am trying to build an application in the lines of the book "Doing Objects in Visual Basic 2005" by Deborah Kurata. So, I have a Data Access Layer (DAL) Class Library that is separated from the business logic layer (business objects) Class Library. I try to add a new business object such as a "Customer" to the Access Database, where the "Customer" table has a PrimaryKey "CustomerID" which is an AutoNumber field. I am successful in writing the values to the database, but I can't figure out how to know the "CustomerID" of a newly added "Customer" so I can populate the business object with the respective values.
View 4 RepliesHi how's it going. In the middle of coding a banking application for a project. Part of it involves mortgage interest repayments. Was wondering if there was any way of logging the time a new record was created and added to the database and then adding interest to the balance owed periodically every 30 days..
View 3 RepliesStill working on that overlay. I am stumped on what I think is my last function. I have a + and a - button that needs to control a text box that has numbers in it. For instance: TextBox1 shows the number 2 in it. When I click the + button I want it to increase that number by 1. It sounds too simple when I say this out loud, but I think I am stumped with this basic function. I don't know where to begin.
View 8 Replies