I'm trying to update my database, I'm using access 2003, my problem is that for some reason I can update the first row but when I try to update any other rows after that I keep getting an error saying Column 'ProductID' is constrained to be unique. Value '7' is already present.
View 6 RepliesI am a complete beginner with Visual Basic, I am attempting to continue where the original creator left off. His project is finished but he didnt (and still doesnt) have time to fix a couple of bugs with his code....Basically, he has written a small VB application that closes SWF flash files if the CRC matches from a list... So when an SWF is loaded into explorer the SWF is hash checked and then closed if it matches from the "hashcheck.txt" file.
All is working apart from 2 small bugs:
1) %^&{}[]#`� - dont work.Ive found that If there is any of these charactors in the folder or filename structure the file doesnt get checked/closed.
2) Network paths do not work.. (maybe is part of above bug?)
N: est_folder estfile.swf <-- works perfectly
\pcshare est_folder estfile.swf <-- doesnt work
I have a problem with Oledb connection when I am trying to open an Excel spreadsheet:
[code]...
This piece of code works well on one computer, but on another the IMEX=1 doesn't seem to work, and the Jet seems to read the first few rows of the Excel spreadsheet that are numeric and decides that the whole spreadsheet is numeric, so it ignores some String values later in the sheet.
I have a VS2005 utility that I'm working on that has an Access 2003 backend. A couple of days ago, my boss asked that I change one field in two tables from TEXT to MEMO, to allow more information to be put in. In doing some final pre-deployment testing, I find when I hit my button to pull up the list of tickets, I get the error
"System.Data.ConstraintException was unhandled
Message="Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.""
The datagrid is based on a query I have in the database. The query runs fine, and when I go through the XSD and go into Query Builder, the QB is also returning data. I have made the various changes to the utlity as suggested by Microsoft, but no luck. When I put the two columns back to TEXT, the Grid works fine.
How the heck do I set it up so that the grid will recognise the new data format? The number of characters for the individual columns is set to 37,627 (I believe, it's whatever the default is). I only have 200 characters in my test data. I need to rebuild the whole dataset - this deployment has to be done by the end of the day tomorrow and I have a whole pile of other stuff left to do.
I've used this in a couple of places and it simply doesn't work. Despit the try event, VB.Net still crashes or throws up an error.
View 14 RepliesI am trying to change the background color of a tooltip
I am using tooltip.backgroundcolor = color.colr
No errors but thecolor doesn't change
I have an application that requires data be entered, and after entering, a button is clicked to process that data. Clicking the button works just as it should--the data is processed properly. In constructing a test module, I provide a set of data values, followed by:
btnWhatever.PerformClick()
Nothing happens. I have used this syntax for years, and it has always worked flawlessly. I have triple checked everything else and isolated the problem to the failure of the PerformClick(). The PerformClick() is in a test subroutine that does nothing but fill textboxes and labels with default data, then calls the PerformClick() on the button to begin processing. Again, the button works fine, the data is entered as it should be, but the PerformClick() does not fire the click event.
I am using an update panel and when I click a button it will update all the panels. updapanel1.update() is very simple, but my data is not updating unless I hit the button twice. My gridviews shows data for a selected user, and then all the grids reflect that users data. works fine all the update panels work for the gridviews. Now for somereason when i try to do a row count and update the panel with the summary, it does not work, i get either the previous users summary or if i hit update again for the same user i get the correct data.
[Code]...
I have a gridview that is set to a sql datasource, it is generating the columns automatically. If I add a column to the table it is referencing, it will draw that column and display it, but it does not update the insert/update commands to include the new column. Is there any way have it rebuild those commands automatically?
View 1 RepliesPublic Sub UpdateStaff(ByVal sr As StaffRecord)
Dim oldSr As StaffRecord
Dim q = From staff In db.StaffRecords Where staff.Employee_Number = sr.Employee_Number Select staff
oldSr = q.First
oldSr.Address_Line1 = sr.Address_Line1
[Code]...
The helper function I have written seems to do everything I want apart from update the db. Stepping through the code, the oldSr is updated by the new sr parameter but no update on submit changes.
[code]The query executes fine but the problem is that when this query executes, it doesn't update the percentage field. What might be the problem?
View 2 RepliesI have a button inside of a gridview's template field. Onclick i want to the button to open up a modal popup while force updating the updatepanel and formview inside the modal popup because the formview's datasource depends on a hidden field in which i am setting after click also.
[Code]...
Possible Duplicate: Datagridview doesnt work! I have written code to show records in a datagridview but it shows nothing. I have tried to debug & when it step into GetData function following codes
Catch ex As Exception
returnData = Nothing
If connection.State = ConnectionState.Open Then
connection.Close()
End If
become gray & it shows error sign. When I take my mouse pointer on it it shows message. It says "Cannot open database SUIMT requested by the login. The login failed. Login failed for user 'MY-PCJames'".
Imports System.Data.SqlClient
Public Class Form34
Private Const ConnectionString As String = "Server=.SQLEXPRESS;" & _
"Database=SUIMT;Trusted_Connection=True"
[code]....
So I have 2 data files, single dimension, that I'm trying to populate two rtb. If I comment one streamreader out the other will print. This also works in the vise versa situation. Does anybody see where I'm going wrong with this? They won't run together.
Dim Alpha As New System.IO.StreamReader("alpha.dat")
Dim Beta As New System.IO.StreamReader("beta.dat")
Dim strLine As String
[code].....
dim str as nullable(of string) is this syntax incorrect?
View 1 Repliesi'm working on a MDI application and need to view a ".PDF" files in a MDI child form, but when using the AxAcroPDF control it doesent work, note that it works fine when viewing the form separately from the MDI application.
View 14 Repliesthis is my code:
Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
For i = 0 To 1000
[code]....
Has anyone succeeded in creating a class library solution/project in VB.net VS2010 4.0 Net Framework for COM to run on WindowsXP Excel 2003. I created a dll which changed specific data in an excel worksheet. The dll worked just fine on the development computer but wont work on any other. I downloaded .NET 4 framework onto the target PCs and used RegAsm.exe to register both the .dll and .tlb files in the registry. That worked OK and the dll is visible as a reference in excel and can be ticked. The error message I get is RunTime Error -2147024894(80070002): Automation Error The System cannot find the file specified.
I also tried creating a Setup and Deploy project in the original development solution but this created just a vbproj setup file which the target PC cannot read (no VS installed), I hoped the project would create an EXE file I could use. Does anyone know any links that describe how to do this type of stuff as most links I have tried are either for Windows Forms projects are are way above my knowledge. Maybe someone out there has already succeeded with this sort of activity?
I have Visual Studio 2010 Express Edition. I'm using it to evaluate functionality before purchasing the real thing, but I'm having trouble. I want to build a DLL that can be used on PCs other than my development PC, that I can call from VBScript.
I follow the hundreds of examples out on the intranet and things still don't work.I have built a simple HelloWorld DLL with a function that returns "Hello World".I've been through all the stuff about making the assembly COM visible, and the threads about Register for COM Interop checkbox missing. One person suggested editing the .vbproj file and adding a tag to turn on Regiser for COM Interop (which was not needed because it was already there).
Anyway, if I build my project and run my VBScript:
Set testdll = CreateObject("HelloWorld.Class1")
wscript.echo testdll.HelloWorld()
Everything works great. But....if I copy the DLL to another PC and register it with RegAsm, the VBScript fails with a "File not found" error on the CreateObject line of the VBScript.
In fact, if I unregister the DLL on my development PC and then register it with RegAsm, the VBScript now fails on my development PC. RegAsm said everything was okay and if I look in the registery using RegEdit, things look good, but it still doesn't work. The only way to get it to work again is to rebuild the DLL (which in turn, registers the DLL).
I'd like to be able to build a DLL which I can be registered and used on other PCs (without requiring those PCs to have Visual Studio 2010 EE and without requiring them to have the source and build the DLL).
Dim
a As Date? = Nothing
Dim b As Date? = If(a Is Nothing, Nothing, GetValue(a))
I thought b would be Nothing, but it is not...is it a bug?
I am getting a datarow from my dataset and some columns can be NULL.So I am trying to check for this using the IsDBNull function, but it just won't work. I have tried almost every possible combination. Can someone please explain to me how to use this properly?ser is a datarow and GUID is a column with data type: unique indentifier (so a Sytem.Guid)
user.GUID.Equals(DBNull.Value) Then .GUID = System.Guid.NewGuid
I tried using above, IsDBNull(GUID), guid = dbnull.value, guid is dbnull.value etc etc I am just getting this error: The specified Cast is not valid.
[code].....
why this code doesn't work?
[Code]...
i made a picture box and the fowling event when my program runs:
[Code]...
So basically I made this code below to make my application (when the mouse leaves), go smoothly in an 70% opacity, with a fade.
Private Sub Timer3_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer3.Tick
Me.Opacity = Me.Opacity - 0.05
[code].....
The form is an About Us form so has nothing on it only a text box and a OK button.
[Code]...
Why won't the button close the form? I'm puzzled, I tried another button just in case with the same result. UPDATE: I set a break point on Me.Close() and it isn't reaching it when I click the button, I created a new button and the same thing happened.
I've problems to detect if there are new rows in a DataTable Email_Total that is yet not imported into ContactDetail.
Dim srcUnique = From row In src.Email_Total
Select row.ticket_id, row.interaction, row.modified_time
Dim destUnique = From row In dest.ContactDetail
[Code].....
Its my understanding that by adding the ScaffoldColumn(false) annotation to an property in a class, that property will not added to the view when doing Add View. However even though i have added scaffoldcolumn false to properties i dont want added to a Create form, they are still rendered inthe create view. Is ScaffoldColumn broken? On page 552 in Pro ASP.NET MVC 3 Framework by Freeman and Sanderson, it states "If we want to exclude a property from the generated HTML, we can use ScaffoldColumn attribute. When the scaffolding helpers see the ScaffoldColumn attribute, they skip over the property entirely; no hidden input elements will be generated and no details of this property will be included in the generated HTML.
" Also the MVC Music Store PDF on p 77 indicates that the attrtibute will do the same -"Allows hiding fields from editor forms".They add it to the AlbumId property and then when the app is run AlbumId field is not shown in the browser. Is this attr broken?If i change a html helper to DisplayFor it does not appear in the form regardless of whether scaffoldcolumn is present. For example i dont have scaffoldcolumn false on Property PostTitle but if i change @Html.EditorFor(Function(model) model.PostTitle) to displayfor then it does not render regardless of the scaffoldcolumn attr. Also my Create view is strongly typed to @ModelType RiderDesignMvcBlog.Core.Entities.Post?
I have an issue with my .NET application and it can only be reproduced sometimes and only on client's location, which makes it extremely difficult to resolve. In the application the forms authentication is used. There is a login page to which every anonymous user is redirected. After user enters username and password, it redirects to DefaultURL or some predefined page. The problem is that sometimes when user enters correct username and password, it doesn't login, instead it just refreshes the login page without any error messages. After several tries of inputing username and password, user is able to login to the system.
See my login page Submit_Click code below:
Dim userName As String = tbUsername.Text
Dim password As String = tbPassword.Text
Dim returnUrl As String = Request("returnUrl")
[code]....
I have creating timekeeping application, I was used drag and drop for my datagridview. During build I can add, edit and delete records. But when I published and run there was an error saying (see below).
I have consume for almost 2 days to fix this problem but no luck.
[Code]...
I've developed a small windows form application in Visual Studio 2005. I have tested the application on a completely fresh install of Vista 32-bit as well as Vista 64-bit and it works fine... But when I copy the application onto an XP machine the following problems occur:The application no longer has its icon, just the default .exe console box icon
Whenever I try to open the application, absolutely nothing happens