I am working on a custom report in access and I do have a query which I want the outcome to appear in a text box control. Howver when I link this under the control source property, It returns an error.
View 1 Replieshow to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI would like to post the result of a query in a textbox. [Code] Suppose this is my table, then I would like to post the sum from aantal from in a textbox. For UserID 1 it would be 35, for UserID it would be 35, [Code] but how do I get the result in my textbox?
View 2 RepliesI have a question regarding LINQ 2 SQL and data integration with textbox:I have one textbox and button on my form, one stored procedure and LINQ 2 SQL class file in my project,I want that when I hit button, my store procedure run the SQL query and show me the result in textbox.I am using VB 2008 and Visual Basic for programing.
View 2 RepliesI have a query which is pulling values from a table in MS Access
SELECT
tblInstructor.InstructorID,
tblInstructor.Football AS InstructorRole,
[code].....
bound user control to create an array. in VB6 I have this code which is working fine:
For j = 1 To 10
Load iProject(iProject.UBound + 1)
Next
How to make this work in VB.NET 2010?
Here is a bit of code I found. It was said to remove a specific value in the array. However, it looks to me like it's setting a new ubound(end to array?), wont everything behind the new ubound be removed too?
Code:MyArray(ItemToBeDeleted) =MyArray(Ubound(MyArray))
RedimPreserve MyArray(Ubound(MyArray)-1)
Edit:Or is it just moving the value to the end and then just -1 from the end to remove it?
I have a LINQ2Entity problem, I want to get the value, string, from a database, so I select FProducts.Serial_number, and to end the query, I do .ToDictionary. The problem is, it tells me that it doesn't have sufficient parameters, to convert ToDictionary. So I need something like select FProducts.Serial_number, Nothing). ToDictionary. Also FProducts.Serial_number, 0).ToDictionary doesn't work.
Sub GetStatistics(ByVal ProductNumbers As List(Of String), ByRef Passed As Integer, ByRef FailedProducts As List(Of String))
Passed = 0
FailedProducts = Nothing
[Code]...
i am relatively new to VB and i am working on a Visual Basic Program to build a Student Record Book where all the information is stored to an Access 2007 database. If the user is an administrator they will be able to add a new student, update delete etc. I managed to implement INSERT/DELETE/UPDATE functions and also a search button and they all appear to be working fine.
View 4 RepliesI have a lot of control array textboxes called txt(1) to txt(320) on form2. I have a textbox1 on form1 with a click evet that says textbox1.text= form2.txt(1).text but it gives an error (txt is not a member of form2). I tried disabling option explicit, option strick and option infer. Still won't work. My code is to long for this place maybe a short version osf the code. Do I need to make a Public MyArray(15,15,15,15) as string, in the Module1 then copy txt(n).text to the array or is there a way to access txt(n).
Public Class Form2
DPrivate Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Loadim txtBox(340) As TextBox
[code]....
I am trying to find a way to use a month calendar control as an object data source, such that when end user selects a given date, or a date range (1 week max), it will supply the date range criteria for an access query, and the results will wind up displaying in a data grid view below the month calendar. I am having a really hard time..
how to write the date criteria into the access query for something like this
I am trying to bind an Access database to a MSChart control in VB Net 2008. I have a test database populated with four fields SAMPLE-DateTime, Values-Number, MAX-Number and MIN-Number. I'd like to only display the rows that fall within a specific date range but I'm running into a problem when i try to execute the following command:
[Code]...
im new here and writing a program that will write and save textfiles, but it is not like notepad. I am using checkboxes, combos, and good old text boxes. I would like tomake it so, for example:
if checkbox1.checked then
textbox1.text = textbox1.text & "movie name is "Hot Tub Time Machine" by idk"
[code].....
Is there any possibility that I can put this large chunk of code to a function so that I can call and verify the input without having to repeat the code for every textbox.keyPress event.
Here it is:
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
With e
If IsNumeric(.KeyChar) Or .KeyChar = "[" Or .KeyChar = "]" Or .KeyChar = ";" Or .KeyChar = ":" _
[Code] .....
Any hints on how to place these monthly sales numbers in an array so they show up in 3 separate text boxes (one for domestic sales, one for international sales and one for total sales. (i.e .User enters Month number in a month text box and the above information should show up in the3 individual text boxes).
'Basic Info:
'Month Domestic International
'1 100,000 150,000
'2 90,000 120,000
'3 75,000 210,000
'4 88,000 50,000
'5 125,000 220,000
'6 63,000 80,000
Public Class MainForm
Private totals(,) As String = {{"100,000", "150,000"},
{"90,000", "120,000"},
{"75,000", "210,000"},
{"88,000", "50,000"},
{"125,000", "220,000"},
{"63,000", "80,000"}}
Is it possible to set an *.ico (icon) file as an image for a button ? I tried it but I saw I can only select *.jpg , *.bmp , *.gif files etc , but no icons . I am sure it's me who's stupid enough not to be able to do that , not Microsoft for removing this possibility which was available in VB6 , therefore , please tell me there is a way to do that !
View 4 RepliesI'm trying to grab information entered in textboxes. I'm trying to grab a name, an age, and a movie title from three separate textboxes, and put them into a single label like this:
"Name" is "age," her favourite film is "movie title."
after clicking the "Show" button.
I know it's a click event for the show button, but I can't quite figure out how to make the concatenated message.
I have this program that outputs all the servers on a specific game. It outputs it to a text file. However, There is a lot of annoying spaces. This is kind of hard to explain, so I'll try to explain it. This is what The text file looks like.
Code:
173.81.220.139 2302
70.26.235.69 2302
24.26.119.209 2302
99.244.109.8 2302
190.234.169.198 27667
As you can see, they have these annoying spaces. What I want to do:
1. Get rid of the spaces, But keep the space between the IP and the Port.
2. After the spaces that are bad are gone, I want the program to output each single IP AND port To its own text Box. It doesn't matter is the textbox of the IP and Port are seperated, It can just be one textbox with the IP and port, with a space between them. Thats about it!! I have the GUI done, and the rest of the programming, all I need now is this.
Reformat without spaces > output each seperate line of text to a seperate textbox > TYTYTYTY
Is there a way for VB to send a command to the command prompt? Say, I wanted it to open a CMD box and send ipconfig into that box, what would that be?
I have a program where a user puts a string into a textbox, and then character one goes into Textbox1, char2 goes into TB2, char3 goes into TB3, etc. I have a For loop that gets all of my textboxes that are used for this, and I have my for loop that is supposed to go through my string character by character.
[Code]...
I have a program where a user puts a string into a textbox, and then character one goes into Textbox1, char2 goes into TB2, char3 goes into TB3, etc.I have a For loop that gets all of my textboxes that are used for this, and I have my for loop that is supposed to go through my string character by character.[code]
View 7 RepliesI have 3 webforms controls: 3 checkboxes and 1 textbox.
When I check checkbox1 and checkbox2, then in the textbox it should appear as 1,2.
How can this be done using ASP.NET webforms controls?
Reading A Line Of Text And Putting Into A TextBox?
View 1 RepliesI have the following code in my project:
rivate Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionString As String
[code].....
OK, SO i have this program that outputs all the servers on a specific game. It outputs it to a text file. HOWEVER, There is a lot of annoying spaces. This is kind of hard to explain, so ill try to explain it. This is what The text file looks like. [Code]
As you can see, they have these annoying spaces. What I want to do: 1. Get rid of the spaces, BUT KEEP A SPACE BETWEEN THE IP AND THE PORT. 2. After the spaces that are bad are gone, I want the program to output each single IP AND port To its own text Box. It doesn't matter is the textbox of the IP and Port are separated, It can just be one textbox with the IP and port, with a space between them. Thats about it. I have the GUI done, and the rest of the programming, all I need now is this. Reformat without spaces > output each separate line of text to a separate textbox > TYTYTYTY
PS, is there a way for VB to send a command to the command prompt? Say, I wanted it to open a CMD box and send ipconfig into that box, what would that be?
How would I get Text from a TextBox on my form and put it in a TextBox in the WebBrowser?
View 9 RepliesI want to bind the following query result to datatable:
Dim query = From c in db.Customers _
Where c.Status = "Active" _
Select c.CId, c.FirstName, c.LastName, c.Email
First time poster and new to ASP programming.I have a functional database to where i am trying to add new functionality.I'm trying to add the idea to check if a returned string is empty, if so get value from a backup table which holds historical information. Here is what i have got for the specific part:
[Code]...
I'm trying to run a query and display the result in a listbox. I can do it for a datagridview but not for a listbox .
Code:
Private Sub frmNieuweActie_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
strSql = "SELECT Acties.Actieid, Acties.Actie " & _
"FROM(Acties) " & _
[code]....
I get the correct amount of items in my listbox but it displays "System.Data.DataRowView" as item .
I am facing a problem displaying the result of my "select *" query on the form . Here is my code:
[code]...
But when I write this code and run my form I am not able to see any records present in my database tables being displayed on my form. I have inserted a DataGridView on my form . What changes should I do to my code ?
I'm trying to fill combobox with my SQL query result.[code]...
View 2 Replies