Search results for query: *

Math.Round(614.5, 0, System.MidpointRounding.AwayFromZero) = 615 Please refer to this article: What You Should Know About Rounding in VB.NET

Try Int() or Math.Floor() functions.

This is driving me crazy I have a client who wishes to extend his online ordering system (asp.net) to include sending orders to a fax system with Ring Central. I know how to send data pairs with httpwebrequest and how to send a file with httpwebrequest. However, I am fairly new to asp.net...

Use a class object Personally I would create a Class Object for Login Keep it off of the database. Class default login = 0 That way if the user or computer kills unexpectedly. It would default back to 0 IMHO

This is the error I get "The data types varchar and text are incompatible with the add operator" But I figured it out, I left the wildcards out of the SQL and added it to the text from the search box Private Sub SearchToolStripButton_Click(ByVal sender As System.Object, ByVal e As...

What is the Proper Way to use wildcards in an SQL query Currently what I have is: SELECT ID, ProductID, Manufacturer, ProductMainCatagory, ProductSubCatagory, ProductSubSubCatagory, ProductName, PicturePath, ProductDesc, ProductRetailPrice, Deleted, DateModified...

[Solved] Date comparison problem Thanks Again jmcilhinney, I changed the code to: Dim SQL As String = "SELECT * FROM Products WHERE DateModified < @LastDateModified" Dim myCommand As New SqlCommand(SQL) With myCommand.Parameters...

Ok I have a hosted SQL server 2008 that I am using for an update server for a product catalog. The products table has a column DateModified (dateType) for each product (row) The application uses a local Access 2003 table that contains a table that stores the last date (also dateType) the...

Office Primary Interop Assemblies in .Net 4.0 Can I require the .NET 4.0 Framework at install time? Thanks Jim

[SOLVED] Displaying Access 2007 Attachment type picture in VB.net Project After many hours of searching different websites and piecing together code, and with jmcilhinney's (forum moderator) guidance I have finally come up with a function that returns a Image from an MS Access 2007...

I think I am almost there.. I added a reference to Microsoft.Office.Interop.Access.DAO Then I created a function: Public Function GetAttachment(ByVal ProductID As String) Dim dbEngine As Microsoft.Office.Interop.Access.Dao.DBEngine Dim db As...

Ok, I re-ran to confirm the other error message, you were correct, I did provide the wrong error it was a System.String. So I Cast the Variable as a String. Once I did this and ran the project I am getting the Files Name for the return value.

Now I get the error: "Unable to cast System.String to System.String()" To be honest, I have been searching all night, and it seems that no one has been able to come up with a solution to this. Maybe this is something we need to contact Microsoft about..

Ok, in ADO.NET it shows the column as a string value. When I open the access database, the attachment field has three sub-fields (.FileName, .FileType, .FileData) . The FileData sub-field actually contains the Binary Data. So I tried your recommendation above with the following code: Dim...

I have an access 2007 database that my client has provided me. The products table contains the Attachment type for the product image. I can read the product data no problem, but I have yet to figure out how to display the image for the product in my picturebox control in VB.Net Any...

True, you need your keywords and page descriptions, But you also need to make sure your images have alt descriptions, pages have titles, and addresses and phone number text is in the "hCard" formating. In addition you need to make sure your 301 redirects are in order.

SOLVED: It was the use of the .deploy application extension, and I disabled the "create installer program", built it and it worked fine

PS the connection String is as follows" Dim con As New OleDb.OleDbConnection con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\RegionalCatalog.accdb"

Ok, I am new to vb.net, I have a windows form application that needs an MS Access file packaged and built with it. It seems to be running fine when I debug. However, when I build the project and install, my application cannot find the database that should have installed with it. I have made...