40 Posted Topics
Re: Easy! [code] decMortgagePayment.ToString("C") & " Monthly Payment" = Me.lblMortgagePayment.Text [/code] Should be the other way around for a start [code] Me.lblMortgagePayment.Text = decMortgagePayment.ToString("C") & "Monthly Payment" [/code] Also is the Monthly Payment defined as something or do you want it to literally be a string? If it's defined as something, … | |
Re: What exactly are you trying to achieve ylsehl00? | |
Re: Do you have the .NET Framework 3.5 installed? Also " The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project. d:\windows\speech\vtext.dll d:\windows\system32\macromed\flash\flash10i.ocx d:\windows\system32msadodc.ocx d:\windows\system32mshflxgd.ocx>OK " As the message says, make sure you have all your dependencies add to … | |
Re: Here is where you're encountering the error [code] Dim selectadapt = New OleDbDataAdapter Dim dataAdapter As New OleDb.OleDbDataAdapter(selectadapt, connStr) ' Here is the problem [/code] You've defined selectadapt as a new data adapter. You're also defining dataAdapter as a new data adapter, the parameters which need to be given for … | |
Just a quick snippet for beginners | |
Re: Basically, the sub routine being used needs 2 parameters passed to it, in order to work correctly. The two parameters from your code are XMLFile and XLSFile, XLSFile is missing. My guess would be that [CODE]excel = New zymClass.myCustomClass.Excel(Server.MapPath(Request.ApplicationPath) & "\Export\ExportPivot.xlsx") [/CODE] The file in question probably doesn't exist, or … | |
Re: I'm assuming you've already looked at protecting against SQL injection attacks? - Jordan | |
Re: You could ideally make a program with an update function, check the server for the latest version every time it is run, simple check, if the version < version on the server, get the latest version from the server and restart the program. Hope that gives you some ideas. - … | |
Re: afaik android is in java :) - Jordan | |
Re: Have you tried re-programming the check so it will take a value other than zero? [code] If blah <> 0 then ' do something else ' do something end if [/code] | |
Re: I cant view the image because I'm at work so I can't get a full understanding of what you're trying to do, can you embed the image into your post? - Jordan | |
Re: [code] Dim Value1 as string [/code] ?? Not really sure what you're trying to do? - Jordan | |
Re: Well if it is writing to the log on every successful / unsuccessful action then an increase in memory usage can be expected. - Jordan | |
Re: well the album art is normally stored in the folder with the album, sometimes the files are hidden. - Jordan | |
Re: Do you have a Username and Password defined for the database connection? - Jordan | |
Re: Are you trying to get the ID of the last transaction? The Unique ID? - Jordan | |
Re: you can always use a dataset / datatable, fill it, use a select query to return all the records, count the rows returned, if it's over a certain number then btn.visible = true ? - Jordan | |
Re: you'll need to import the following to use a SQL connection in VB.net [code] Imports System.Data 'Imports required to use SQL Connection Imports System.Data.SqlClient 'Imports required to use SQL Connection [/code] and here's some sample code for inserting a record into a SQL database in VB.net [code] Dim DBConn As … | |
Re: If you want the label to change when you login then you can do it conditionally [code] If loginsuccess = true then lblkrypton22.text = "admin" end if [/code] Something like that? Not sure if i fully understand what you're trying to achieve. - Jordan | |
Re: It is possible, using a SQL Insert query to insert the data fetched from the controls of the form. - Jordan | |
Re: Might be of use to you [url]http://www.aspfree.com/c/a/.NET/Smart-Cards-in-.NET/[/url] - Jordan | |
Re: You would need to use an SQL Insert query to achieve this, for example; [code] INSERT INTO tblExample(Field1, Field2, Field3) VALUES (@Field1,@Field2,@Field3) [/code] This would need to be done programatically, i've never used Access so all my code snippets and samples are SQL Server 2005 orientated although i can post … | |
Re: Well, Google is possibly the biggest VB.net resource available, literally thousands of articles available through a Google search or even on these forums, use the search function to get you started and have a look through the code snippets section. - Jordan | |
Re: What are you using to display the data? In a GridView for example, it's simply a case of [code] GridView1.DataBind() [/code] Just refreshes the GridView and binds all current data to it, if you data bind just after an insert it will refresh and display the information you just inserted. … | |
Re: There's a LOT of combinations for each note though surely? For example a £5 note in UK Sterling can be made up of 5 x £1 2 x £2, 1 x £1 25 x 20p 50 x 10p 1 x £1, 8 x 50p 1 x £2, 2 x £1, … | |
Re: [url]http://enterbangla.blogspot.com/2009/02/asp-net-remote-and-web-service.html[/url] Enjoy :) - Jordan | |
Re: [url]http://www.developerfusion.com/samplechapter/91/stored-procedures/4/[/url] See if that is of any use to you :) - Jordan | |
Re: you could use a regular expression validator to ensure that the user doesnt enter any numbers in their name? Or do you want to check the name against a database? - Jordan | |
Re: Let me see if i understand what you're trying to do You have a text box which is used to search for data to display in the Data Grid View and when you find the information you want to to automatically scroll down the page to the information found? | |
Re: you'll need SQL queries to achieve these things: Here is the step-by-step procedure to INSERT a record into an SQL database: 1. Create your VB.NET project. 2. Include the following namespaces. [code] Imports System.Data 'Required for SQL Imports System.Data.SqlClient 'Required for SQL [/code] The System.Data namespace provides access to classes … | |
Re: Well the error message has pretty much told you everything you need to know, check your login information for the database and see that you have the correct permissions :) - Jordan | |
Re: you cant drag a class into a form, the whole idea of the Class is that you can have various functions relating to one class. Example [code] Public Class MyModules Public Shared Function getConnectionString() As String getConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("TestConnectionString").ToString() End Function [/code] So if i want to get the connection … | |
Re: I thought 2010 included Excel ODBC drivers? Visual C++ 2010 does anyway, I use VS 2008 in work so I can't really comment. | |
Re: I'm going to guess that you're not familiar with VB much? Here is some sample code to actually Ping/Download/Upload from a website [code] If My.Computer.Network.Ping("www.anywebsite.com", 1000) Then MsgBox("Server pinged successfully.") Else MsgBox("Ping request timed out.") End If My.Computer.Network.DownloadFile _ ("http://www.anywebsite.com/downloads/anyfile.txt", _ "C:\Documents\anyfile.txt") My.Computer.Network.UploadFile( _ "C:\Documents\anyfile.txt", _ "http://www.anywebsite.com/uploads/") [/code] Obviously you … | |
Re: If you could post a snippet of your code, that would be helpful :) Also, if you're using SQL Server 2005, try running a trace on the database to see what its actually trying to execute (if anything at all). It's very useful for correcting syntax problems etc. | |
Re: You might have a FieldName which is the same as one of the keywords. Try putting brackets around the FieldName and see if that fixes it :) | |
Re: Are you doing this through a web application or windows application? For a web application, you could try using a webbrowser control, add it to your form and then use the Navigate method to display it in the browser control... [code]myWebbrowser.navigate("d:\test.pdf")[/code] Or maybe i've misunderstood the original question lol - … | |
Re: Just some sample code for you, edit as you wish (I think this is right from what I understand from your post) [code] Protected Sub GridView1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.GridItemEventArgs) 'Is it a GridDataItem If (TypeOf (e.Item) Is GridDataItem) Then 'Get the instance of the right type … | |
Re: you could have set a breakpoint or used a try/catch and viewed the exception message, I have little experience with Access as for work we mainly use SQL Server 2005, you could have run a trace to see what is actually being executed on the database(If it can even be … | |
Re: Try this [url]http://support.microsoft.com/kb/914277[/url] see if that helps :) |
The End.