20,284 Topics
 | |
 | i am having real issues trying to build a sql string Dim SelectQry = "SELECT * FROM TblSupplierQuotes where TenderNo='" & Me.txtTenderRef.Text & "' AND KMBPartNo=" & " " & Me.lbKMBPartNo.Text & " " in SQL the TenderNo is varchar(50) = L003141T75-2012JANTEN KMBPartNO is text = 442 019 115 1 …  |
| | Hey guys I manged to get some code what works fine but it uses console application I have tried to convert it by hand and change things around to get it to work but with no avail! Im certain it should be simple but I may be wrong :( Code … |
| | I’m trying to produce this equation in VB.NET h = (sh * s + (dia / 2 (tan(ang))) + ((dia / 2 (tan(ang1))) / 3)) This is where I’d prefer to retrieve the data from. Sh = sheet height = 1 (can be variable)(data retrieved from textbox) S = sheets … |
| | Hi Everyone I have a listbox that calculates interest rates the code is as follows:- dim amount as double = val(textbox2.text) dim counter as integer for counter = 1 to 10 listbox1.items.add(counter & " % " & formatcurrency((amount*counter)/100)) next counter This works great but i would like to use a … |
 | hi, guys here is my question:- I've created an application for opening text files. there i got two forms.one contains the textbox where the contents of the file will be displayed. there is a button.clicking this will move me to another form which is displaying modally.in the second form i …  |
 | How to maintain Zeros in incremented values ex: ECJ-00001 any help willb appreciated this is how I am icrementing Dim Separ As String() = fullString.Split("-") Dim StrPart As String = String.Format(Separ(0), "ABC", System.String.Format("SIM")) Dim intPart As Integer = Convert.ToInt32(Separ(1)) Dim Novonumero As String = String.Empty Novonumero = String.Format("{0}-{1}", Separ(0), System.Threading.Interlocked.Increment(intPart), …  |
| | I'm new to complex maths and equations in vb, even the basic maths below does not work correctly. So can any one advise on the best data for for me to use e.g. below decimal for math calcs Help me put the below correct. Private Sub z() Dim ringheight As … |
 | Hi, I'm searching for an Audio/Sound monintoring sample code. What it does is it **meters** the sound coming out of the computer. Can you give me some examples on how to do it? Thank you!  |
 | [Click Here](http://img96.imageshack.us/img96/1272/sucksu.png) I Have create a folder using my VB Project.how do i access it through my code..this folder contain all the contacts images in my programe.i mean i know the folder path in my computer if i instal my programe in a another pc how do i get the …  |
 | hello ! i am using mssql server 2008 , i have a table with three fields , 1- ProdID 2-ProdName 3-ProdPic , now i want to show the all records of the table in the datagridview by using vb.net , how can i show my image field in datagridview , … |
 | Hi, I am in the process of trying to use VB 2005 to connect to a MySQL DB . I have the data connection working between the program (VB 2005) and my MySQL server but now I need to make my code connect to it. I have never done a … |
 | How can i check whether the text box is numeric or not? Because i want to do validation. but i tried many style still cannot work. |
 | hii all, i hope everyone is ok, can someone tell me why my crystal report dosesnt show any of my data. Best regards  |
| | hello all of you ! i am making a simple form which can create the text file from the database table , for this , i am using this code at the load event of my form so that it can create the files at the load time. IO.File.Create("C:\Customers.txt") IO.File.Create("C:\Towns.txt") … |
| | Hi all, I've got a little personal project on the go at the moment. Given a UK postcode, it will find the nearest railway stations and sort them by distance. I would like to be able to get walking directions from the postcode to the station from google maps. This … |
| | Hi there, I am new to this forum so please be patient with me :-) My problem is how to bring a nested XML structure into a single DataGridView. The XML looks like this: <Artist> <Name>John Doe</Name> <Age>36</Age> <Language>english</Language> <Artwork> <Picture>Picture 10</Picture> <Picture>Picture 20</Picture> <Picture>Picture 30</Picture> </Artwork> </Artist> <Artist> <Name>Mike … |
| | I have completed my project with front-end as vb.net 2008 and back-end as SQL server 2005. I have to backup and restore my project in the following extensions: 1. .bak 2. .xls 3. .mdb Please tell me how can i store the backup project in my own path. |
 | Hello people; I am implementing an application in vb.net about a library management system, when I add new record to the database and then close and reopen the application, the record is not there! I googled the issue and used the text book of this course but nothing beneficial. :( … |
| | Hello Gents I have a small problem and hope someone ca help me. I wrote a small code to generate auto-increment number and save it to the database. the problems is that whrn it reaches 10, it stops incrementing hereis the code Dim Separ As String() = fullString.Split("-") Dim StrPart … |
| | Hi everyone, In a nutshell...I have developed a site in ASP.Net and VB.Net which allows a user to create an order and submit it to a SQL Server backend database. When the order is placed...an xml file is also produced, showing the items that have been ordered...which is then loaded … |
| | hello ! this is my code , i am writing a text file form the datagrid, but this code is very slow , please check it out and give me some advice how i can make my code fast , If IO.File.Exists("C:\Customers.txt") = False Then IO.File.Create("C:\Customers.txt") End If Dim FILE_NAME … |
| | Hi Trying to login to google accounts this is the code that I created but I get this error: Your browsers cookie functionality is turned off. Please turn it on. I dont want to use there api too as this is a learning for me thought I had it nailed … |
 | Here's the error : "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - … |
| | I cannot connect to SQL server heres the code Dim conn As New SqlClient.SqlConnection conn.ConnectionString = "Data Source=|DataDirectory|\Books.sdf" conn.Open() '\\ Error Comes here Dim sqlcomm As SqlCommand = New SqlCommand(("SELECT MAX(ID) FROM Books"), conn) maxid = sqlcomm.ExecuteNonQuery() Error Prompts me as > A network-related or instance-specific error occurred while establishing … |
| | Hi, I have designed a windows form(to act as a messagebox) with Label and OK, Cancel buttons. I'm on form1 and call this messagebox form in the closing event. If I debug the showdialog of the messagebox form the custom text is displayed on the Label, however if the application … |
| | I have an mdi parent and 2 child forms. Both are opened. Now When I try to pass a value, it gives me nullexception value. Heres how I created MDI child forms: Dim _a As New a _a.MdiParent = Me _a.Show() Dim _b As New b _b.MdiParent = Me _b.Show() … |
 | Hello kindly help me to solve my problem to check item listview to avoid duplicate item in database. I have 1 listview, my plan the listview checking each item from database before insert to database. and item in listview obtained from opendialog excel this is my code : when items …  |
| | hi! im currently creating a payroll system for my project and part of it is a time calculator. but my problem sir is that i don't know how to deduct lates on there daily hour .. its goes this way sir, it has a textbox that has their schedule that … |
| | hi all can someone tell how i can multiply the items of combobox to onther one using vb.net , plz |
| | I've been trying to use different methods to insert buttons into a treeview control. But I couldn't figure it out. Someone told me it was not worth the hassle. Im new to vb and im trying yo figure out how to prepare a collapsible listview which shows links to different … |
The End.