I am trying to pull the data by date in vb.net. It is not throwing the error nor giving any result. Whereas It shows the results in table adapter configuration wizard when I try through query builder. I am using date time picker in the form. But I have formatted the date in the database as date.
[code....]
I have a Date type, its part of a structure holding other times.
Structure WorldTimesType
Dim Date1 as Date
Dim Date2 as Date
[code]....
'Then in my sub, which is on a timer.tick event
WorldTimes.Date3.AddMinutes(5)
The problem is, it, simply doesnt work. No error, no warning, nothing. As far as the sub is concerned it works, but the Time remains unchanged, I've tried using the DateTime type, tried adding time span instead of specifil intervals, nothing works.
add user to access database but it's doesn't work the problem here
SavInto.ExecuteNonQuery()
say a user buys a 6 month subscription to my online app. Using c# or vb.net, How would I work out what the expiry date should be to be inserted into the database.
View 2 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 have a form that collects user parameters to print a report. There are two DateTimePickers to let the user select a date range for the report. The selection of a date range is optional so I set the From picker to a date before any data could be present. If the user wants to select a date range, the from field is set to a very old date so it takes a long time to get to any current dates. Whe I'd like to do is when the user drops down the picker, reset the date to today and let the user scroll from there.I tried the dropdown even in the picker, but the new date doesn't get set until the user has already selected a date. Any suggestions on how to get this type of UI behavior? Also any better suggestions to streamline the process?The main objective it to collect from and to dates from the user is they want to select them and collect wide ranging dates if the user doesn't enter any.
View 2 Repliespassing parameters to dataset FILLBY GETDATABY
View 14 RepliesI need to compare the date that is entered with today's date minus some number of work days.
I used dateinterval.day, but that is the actual day, not the work day. i don't see a "simple" way to get work days.
For example, my number is 3, so i want 3 work days (M-F) not 3 days.
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
I've almost finished a binary clock, but I have one problem. The user should choose between two different backgrounds, named binary.jpg and binary 1600.jpg
Dim Bild1 As New Bitmap(Application.StartupPath & "/Bilder/binary1600.jpg")
Picturebox1.Image=Bild1
I get "Parameter is not valid" on the first line.
I got this code in order to build an url for the link using a querystring from the current page. The problem is.... It doens't work.
[Code]....
Consider the following:
class Bind
{
public string x { get; set; }
[code].....