I have a project which had a listview on it which had a property set whereby the last item added was always visible, i find now the listview does not do what i need so i have changed it for a dgv. In essence what i'm doing is a log.
View 2 RepliesI have a DGV that is designer generated. I can create a row perfectly fine, and I can edit rows perfectly fine. However, if I try to edit a row that I have just added and saved, i get a concurrency error. As you can see in the code below, I perform some "injection" of information into the rows before they are pushed back to the database.
System.Data.DBConcurrencyException was unhandled
Message=Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
RowCount=1
[Code].....
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 using VB.NET in VS10. After I add items to a list box I'd like it to scroll down so that the most recent items are visible. I tried this with no luck:
StatusListBox.SelectedItem = StatusListBox.Items.Count - 1
How to make the box always display the most recently added items?
We have an application that was written in VB6 which I am trying to convert to use the latest VB (Visual Studio 2008), mostly because it's not possible to buy a licenced version of VB6 anymore (personally I'd have been happy to just keep using VB6, but without having a proper licenced version of it, we basically had to chance).The VB6 version I could simply tell it to compile the application and it produced the .exe file which I could then copy onto the server where it was running and replace the old version and then run it.
It seems like such simple things are not possible in VB 2008.I have got the application converted, and if I run it through the debugger it is working correctly, but now I need to get a compiled application to run on the server and can't seem to do it.I have tried using the publish application thing, and nothing I try succeeds in getting a working application.
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].....
I have a ListBox that is only about 4 lines high. After I add more than 4 Items, it attaches them to the bottom of the list outside of the viewable area with out scrolling. Is there any way to either add items to the top of the list or make the latest item visible? I want to keep all the items in the list in the order they were added whether it is oldest to newest or newest to oldest.
View 8 RepliesI emptied the recently-viewed projects from the registry but now the project which I'm working on does not appear there even though I've opened it many times. How do I get the project to appear in recently-viewed projects?
View 5 RepliesThe idea with this form is to add the futures which is calculated when the button is pushed but I need the list to update every time and show the values each time to which the previous value is added to the new calculation, e.g. of what it should look like in listbox:
Year 1: $1,290.93
Year 2: $2,724.32
Year 3: $4,350.76
etc....
I have been working on this a while and I am at a standstill, I was given a function to clear the form everytime it calculates but I don't know how to implement it, I am new to VB. Here is what I have so far:
Public Class frmFutureValue
Private Sub btnCalculate_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnCalculate.Click
[code]....
I would like to retrieve the ID number for that row that was just inserted into the database. after saving it I want to get the value of its ID and pass it to another table.
View 3 RepliesI am developing an application in VB.NET. in which I need to open the most recently accessed file (i.e. last accessed file in the previous session) when the application starts. One approach is to save the location of the most recently accessed file in a text file and read it when the application runs the next time.
View 2 RepliesDim Customer As New Customers
With Customer
.Name = txtName.Text
[Code]....
After saving I want to get its ID and pass it to another table. how or what is the proper way to do this.
I would like to retrieve the ID number for that row that was just inserted into the database.
Dim Enrollment As New Enrollments
With Enrollment
.Student_ID = CInt(lvwStudents.FocusedItem.Text)
[code].....
Below is some code that I'm using to create objects with Visual Basic:
For indexCounter As Integer = 1 To TotalParticipants Step 1
participantClock = New Label
participantClock.Size = New Size(100, 20)
participantClock.Name = "participantClock" & indexCounter
[code]....
I'm creating a label, a button, Timer, and Stopwatch. (Though I have sinking feeling I don't need BOTH a timer and stopwatch since I'm counting time.)What I would like to do, is create the label and set that label's text to be the value from the stopwatch. The button that will be created will stop THAT stopwatch.
The problem that I'm having is that I cannot call the stopwatch by name since it wasn't created yet and VB throws a hissy fit at me for it. (After all it wasn't really declared.)So the question becomes, how do you call the most recently dynamically created control and assign events using that control. If it's not possible to do, I do not mind dumping the form and starting over creating 30 stopwatches instead (but I'd like to avoid that, if possible).
How do you clear the Recently Opened Program Lists in the start menu?
I've been making a computer cleaner, and I've Googeling and I guess binging so much to find an answer but i couldn't, does any1 know how?
The most I could find was: [URL]
BTW I know how to clear it, but I need to know with VB code.
I have a program that adds controls on the fly to an auto-scroll panel. When the panel is scrolled (viewing the bottom of the panel for example) and a control is added, it looks like it is added assuming the top left corner of the panel is still at 0,0 when in fact it may be 0,500. To see what I am talking about, create an empty "Windows Forms Application" project and insert the below code into it.
Friend WithEvents Panel1 As System.Windows.Forms.Panel
Friend WithEvents btnAdd As System.Windows.Forms.Button
Dim ButtonCount As Integer
[code]......
i have multiple forms in a project and all have statusbar. there is no way to add textbox on status bar but in my previous thread i got the help to add the text box. i created a function in module so that i call that function from all the forms on load and add the textbox on status bar and also add the event on textchange. the function to be called on event change is in individual form (at present)[code]
View 11 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].........................
how to reference/add mshtml.dll to project as described on this url. It explains how to reference SHDocVw.dll but not mshtml.dll. I can't see it in the list and when I browse to the file on windowssystem32 an error pops saying I can't add it to the project.
View 2 RepliesPublic LabelX As Integer = 12
Public LabelY As Integer = 9
Private Sub AddLabel(ByVal LabelName As String)
[code]...
I've a question about vb.net application with ms access 2002 database.I use "Add data source" wizard to setup a connection to a access database.my application read text file into a temp data table at runtime.a button click to import data from temp table into one of access table.problem is data is not added at all.here is the code I use to do update
For Each dr In dt.Rows
DataSet1.tbl2.ImportRow(dr)
Next
DataSet1.AcceptChanges()
TableAdapterManager1.UpdateAll(DataSet1)
I am using a .net program. My program is used by few people and it at times downloads updates automatically.Recently I have added a COM control (ocx) in my .net program. Now when I run the program (with ocx in the folder) it gives an error. When I registered the ocx thru regsvr32, it worked fine. So now my program has to register the ocx. Is there any other way to do that rather than using regsvr32. The reason is the regsvr thing will work fine in Win Xp systems but in Vista/Windows 7, which has higher security, I dont know if regsvr will work ok or give an error or will run in elevated more.What should I do ? Should I stick with regsvr32 for all OS or is there an alternative.
View 10 RepliesI've been working on a project lately, where the user can click on an item in a listbox and then get a picture in the PictureBox1. My problem is that when I added a tab control so that I could have several pages with different listboxes and pictureboxes, it stopped working! When I click on an item in ListBox1, the picture doesn't show up in PictureBox1. Why did the tab control ruin everything?
View 3 RepliesI need to be able to add buttons in my application dynamically, and I have written this
Dim bttn As New System.Windows.Forms.Button()
bttn.Text = "This is a new button"
bttn.Left = 326
[code].....
What is the best method to reference a new record added to SQL?
View 8 RepliesI have the following code on a form named: frmRegister.The aim of this form is to add a new user to a database. However, currently the code exectures with no errors and the success MsgBox is displayed, but the user is not added to the database.I can't seem to pin point the error.[code]
View 1 RepliesI have two FlowLayoutPanels in a Form. The first read images from a DIR and expose them generating so many PictureBoxes are necessary. The user can drag an image and drop into the second Panel. All works fine. Now the problem is how can I know the name of the image contained in the PictureBox in the dropped Panel so that I can save it? I tried to recover in a ListBox the name of the images during the population of the first Panel but I don�t know witch may be the reference with the dropped PictureBox.
View 4 RepliesNot sure if I'm posting this in the right area, but here goes anyway. I've been working with sql databases for practice, but can't seem to get around one thing; after I add it as a data source, I can't go back and add tables.
I start off by going through the project, then add item, choose the service-based database, and go from there. I add the tables, then go in and add it as a data source.
After I've added it as a data source, I can go back into the .mdf form and add lines and edit properties, but it wont update in the data sources. So, I can't add it to the form.
How would I remove files that are already added into the listview?
View 12 RepliesI am creating a program which allows the user to add some buttons during runtime. Each button can be moved, sized and added to any tab on a tabcontrol. What I would really like to do is binary serialize a class that contains the properties of each button including which tab it's on.
View 4 Replies