value 33 in the textbox and select 0.3 in combo box it should take 33,33.1,33.2,33.3 values of outside temperature and corresponding power values to display the graph.
what i have tried till now was
con = New SqlConnection(connec string")
cmd = New SqlCommand("select TOP 50 PERCENT * from Vijay ", con)
[code].....
i have created a table with 2 fields in vb.net as follows -
[Code]....
How do i put a hyperlink on the name cell, so when i click on a specific name it will goto next page with that name?
I have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?
View 1 RepliesI currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
I am using a string builder to set up an html table row by row so that it can be emailed. I currently gather my information from the database using a data reader and while dataReader.read, I use stringbuilder.Append to add each cell value to the table.The issue is that after about 200 rows, the html breaks and displays a cell value above the table in the email. I have tried changing the cell padding, but this was not successful.
View 2 Replies[code]If I wanted to get Part Name for multiple PartIDs from OrderDetails, how would I go about doing this? Would I use two DataTables? I'm confused as I cannot see an efficient way to do this. The only thing that I can think of is to create a DataTable with SQL:[code]and then maybe use a For loop to take each PartID, create another DataTable to find the PartName for that and then give this to a variable. There could be up to 10 PartIDs to search through and I don't want to have variables such as PartID1 PartID2 etc. [code]
View 2 RepliesMy vb.net browser will be the first application I'm actually pushing out to the public.Everything else so far was for me and friends or some type of class. My problem is I don't know what license to pick to release it under. It's going to be partially open source and partially not.Whats included that i didn't write or make
GeckoFx - web browser plugin like ie but based off firefox
App Life Update - http:www.kineticju...te/Default.aspx ( I have the free limited license)
Sqlite - used for bookmarks
Other than those to plugins/dll files everything else i wrote myself or followed tutorials on and modified to fit my applications need.
I'm using REGEX to scan the following two bits of javascript and get the stream url in the javascript codes below the regex.
REGEX:
Dim matchs As MatchCollection = New Regex("(window.SC.bufferTracks.push(){1}[^)^;]*();){1}").Matches(input)
Dim match As Match
For Each match In matchs[code].....
why it's working on one javascript, but not the other? (i've tested it on several, and it works on some and not on the others
I am making a HTML editor and thats the easy par ie saving as .html etc, but i want to also add in the thing thats in VB wherein it picks up the word your typing and make suggestions, i have made it so it can have a data base of a thousand words (1000) and you can add and it loads all fine. Now i need to add in the functionallity to read every Key, i tryed
Code:
If e.KeyCode = Keys.Space Then Scan = ""
But none of this works, is there a better way of getting the the key press and adding it to a string untill space is pressed in which the array is cleared.
Code:
Imports System.IO
Public Class Form1
[code]....
So say i had a Tag stored that was "HTML" then as soon as i pressed the < key it would start checking my keys then if i pressed H it would display all word is the drop down box with H at the start then if i followed it with T then M it would show HTML in the box and maby a couple of others that began with HTM, if i then hit enter it would add in the L> thus compleating it and printing "<HTML>"
So I've tried Process and starting a cmd.exe and send commands directly to that window. And then picking up the values written to the cmd.exe window.
The code looks like this:
Dim arrServers As ArrayList
Dim s(ListBoxServers.Items.Count) As String
ListBoxServers.Items.CopyTo(s, 0)
arrServers = New ArrayList(s)
Using P As New Process
[Code] .....
But is looks like it doesn't "press enter" or something. Meaning, I don't get any results from the command. I don't even get a "'command' is not recognized as an internal or external command, operable program or batch file." like you normally get if it doesn't understand the syntax.
I'm just wondering if its even possible and if there is a code out there that can do this:
[Code]...
We use some software at work called nicelabel, which prints out box end labels by dragging data from a database. We currently have two templates that we use, one for jpgs and one for bmps. For example this is the code that is ran on the picture on our box end label -
[Code]....
Now, if the relevant image in the folder is a .bmp, the process will fail and no image will be assigned to the box end label. Vice versa with if we run the .bmp version of that code and it's a .jpg. Is there any way we can modify that script to say .jpg OR .bmp, picking whichever it is? For example, look for this file with a .jpg at the end, if you cant find it look for this file with a .bmp instead?
The following code doesn't work;[code]....
View 17 RepliesWhen working with the code within a control's subprocedure if you type it brings up intellisense as you would expect: Code: sender. Within the intellisense there is no text property listed to select from however if you just type "text" after the "sender." it allows it. It also doesn't capatilize the T in text after you leave the line as you would expect to see when working with other properties. This is the first occurence that I've seen where an item was not included in intellisense but allowed it without errors. This is a big code saver and discovery for me as it cuts my other previous methods of extracting the control's text down to a single simple line.
View 2 RepliesIn our VB.net coding project, we have a module with the code shown below. In our frmMain.vb, we use every thing you see in the modeul.
However, when happily coding along, intellisense doesn't seem to see these or pick them up.
How can we change this so Visual Studio's Intellisense picks up our constants? For example, when typing:
If System.IO.File.Exists(SERVERS_CONFIGURATION_FILES) Then
I want to be able to type something and then the dot, such as Me.whatever and have it picked up. Below is our module:
Module ConstantsAndEnums
Public Const PROGRAM_NAME As String = "Server Monitor .NET"
Public Const TOOLTIP_BUBBLE_DISPLAY_TIME As Integer = 10000
[Code].....
trying to finish up some odds and ends of a game I am making.I have 9 picture boxes, and after the user picks one, i want the computer to randomly pick another, then the user and so on until all 9 boxes are full.This is what I have so far. It will let the user click a box with one character, then the user has to click another box and it fills it with the other character, but instead of the user having to click the second time, i want it to be automatically filled, unless it is already filled.
[Code]...
I have just opened VB10 for the first time and it converted my VB8 program beautifully, except that all of the screens are not showing any data !
My reference to the MS Access database file is as follows :-
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:MoneyMoney.mdb"
Do I need to change any of this syntax or is there some other reason why VB10 won't show anything ?
I'm trying to figure out how to make a number be randomly picked but only picked once when a button is clicked. I've got the simple random number code down already but I can't seem to figure out how to have it picked only once.This is basic random code that I'm using right now.
Randomize()
Dim value As Integer = CInt(Int((14 * Rnd()) + 1))
It picks out a number from 1 to 14 and returns it as an integer in "value", and I'm using to set that to open a specific form but I don't want that specific form to open more than once in a session. So if the number three was already picked out then it could never be returned ever again.
I'm using the following code to work out the next unique Order Number in an access database. ServerDB is a "System.Data.OleDb.OleDbConnection"
Dim command As New OleDb.OleDbCommand("", serverDB)
command.CommandText = "SELECT max (ORDERNO) FROM WORKORDR"
iOrder = command.ExecuteScalar()
NewOrderNo = (iOrder + 1)
If I subsequently create a WORKORDR (using a different DB connection), the code will not pick up the new "next order number."e.g.
iFoo = NewOrderNo
CreateNewWorkOrderWithNumber(iFoo)
iFoo2 = NewOrderNo
will return the same value to both iFoo and iFoo2. If I Close and then reopen serverDB, as part of the "NewOrderNo" function, then it works. iFoo and iFoo2 will be correct. Is there any way to force a "System.Data.OleDb.OleDbConnection" to refresh the database in this situation without closing and reopening the connection. e.g. Is there anything equivalent to serverdb.refresh or serverdb.FlushCache
How I create the order.I wondered if this could be caused by not updating my transactions after creating the order. I'm using an XSD for the order creation, and the code I use to create the record is ...
Sub CreateNewWorkOrderWithNumber(ByVal iNewOrder As Integer)
Dim OrderDS As New CNC
Dim OrderAdapter As New CNCTableAdapters.WORKORDRTableAdapter
[code]....
I am overriding the WndProc to capture the WM_VSCROLL of a textbox / RTB... However this does not seem to capture the scroll event if it happens from a scroll wheel of a mouse ... how can i pick this up?... i can't use the MouseWheel event because this occurs when the mouse is scroll wheel is actually turned and not after the content is actually scrolled.
View 7 Replieshow to go about picking the random weapons. When you generate a random class, the user must first enter their current rank (level). This is because you are unable to use certain guns until you reach a specified level. This keeps the program from giving out guns the user can't use. What I am doing is allowing the user to give certain parameters as to what type of gun they want to use (or don't want to use). For example, I have checkboxes for the user to pick if they want assault rifles, SMGs, LMGs, Snipers, Shotguns, RPG, etc.
I did this in another version of this program I made, but the only option was to pick whether or not you wanted RPGs included. So, it was easy enough to check if the weapon was an RPG and if it was simply generate another random weapon. I could do this, but with the number of options there are, I don't think this would be the best solution.
[Code]...
First one : i want add values to table and this is the code
[Code]...
i want add values to table and this is the code
Dim AdCounter As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ElectricityBillsViewer.mdf;Integrated Security=True;User Instance=True")
Dim AddCounter As SqlCommand = New SqlCommand(" INSERT INTO CounterInformations
[code].....
but it's not working it shows me this error Incorrect syntax near ')'.I'v made a log in program aslo it's show me an error which is Incorrect syntax near ','. and this is the code i'm using
Protected Sub Command1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim SignINStr As String = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ElectricityBillsViewer.mdf;Integrated Security=True;User Instance=True"
[code].....
I have been doing some listings from database, from the table "Clients", however, when it arrives to the field "Status", like it was expected, it displays to me numbers (1, 2, 3 or 4) these numbers have a relationship with another table, called "Status", which have: Single, Married, Divorced and Widower (according with those numbers).
So, I'm using a DataSet to list all the field, how can I retrieve the text in the table "Status" according with the IDClient instead of retrieving numbers?
I have a table called Table1 which already has a few other columns and 4 rows. I want to add three new columns to it. When the columns are added I want all the cells in the column to equal the variable I supply in the Add method. When I add the column named "BatchID" it works beautifully, but when I add "UserID" it gives an error "Cannot find column [iqz9]". Why? This is how Table1 should look like:
[code]...
How do i use Variables as the values to insert into the SQL table. I tryed:
Dim cnnConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=" & Application.StartupPath & "DatabaseRecords.mdf;Integrated Security=True;User Instance=True")
Dim ImportValuetoSQL As String = 1
Dim cmd As New SqlCommand
[code]....
I am having a problem storing the contents of a field to a STRING variable. It works when the field actually has data but when it's empty, i can't do anything with it. I would like to test to see if it's empty but I run into problems there as well.
VB Version is 2008 Express
DB is Acess 2003
OS is Vista 64-bit
[code].....
I need comparing value from the same table for my final project.
Example :
Table 1 :
SubjectCodeClasses
Sub Aclass 1
Sub Aclass 2
Sub Aclass 3
Sub Bclass 2
Sub Bclass 3
Sub Bclass 4
Sub Bclass 5
Sub Cclass 6
Sub Cclass 7
Sub Cclass 8
...
My task is, I need to compare the classes in the subject. Sub A with class 1, class 2, class 3 have to compare with Sub B and Sub C. if classes from Sub A exist in Sub B then the output is 0, if not the output is 1. then Sub A again will compare with Sub C and the rest. After Sub A compare its value with other subject. Sub B will start comparing with all the subject and so on.
Below is the concept.
Sub ASub BSub C
Sub A001
Sub B000
Sub C100
I really don't know to do the loop..
I'm trying to Collect Bids and Distribute the average from a Column I'm getting an InvalidCast Exception: Specified cast is not valid. on the TotalSum +=
Dim sql As String = "SELECT " & Column & " FROM " & Table & " ;"
Dim dt As DataTable = SQLiteDatabase.GetDataTable(sql)
Column = Column.Replace("[", "")
Column = Column.Replace("]", "")
For Each row As DataRow In dt.Rows
[Code]...
i want to restrict -ve values entering into access database table.im using vb.net as front end...
View 5 Replies