I need to ba able to display the results from sql into a MsgBox and have the option Yes/No.
My SQl is : SELECT account FROM Ta Where cost=0.
this will return about 10-15 rows, i need to see te accounts with o cost befor i continue.
I have pulled some records in DataGridView from database. Now I want that when I select some rows from DataGridView and click on command button, ID's of all selected rows should be displayed through message box. By using followng code I am able to display ID but problem is, "When I select multiple rows and click on Button, msgbox shows only the ID of later selected row, I'm using Visual Basic for Windows Form.
Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
For i = 1 To DataGridViewIU68E.SelectedRows.Count
[Code].....
I know how to display a message using the msgbox("text","title","msgbox type") but i dont know how to check the result
View 3 RepliesI have a button and i want it to check for a condition to display different msgbox.
Below is my code:
Dim a As String = "";
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
[Code].....
But i got the following error when i clicked on the button.
"Input string was not in a correct format. "
Below is the code snippet where i would like to display a msgbox if there are no matching records. I always get a NullReferenceException at iRows = ds.Tables
[Code]...
Is there any way to display the full array with delimiters and everything?The code below does not work but it show you a example of hat I want to do.
Code:
Dim apa As String
Dim ar() As String
apa = "1,2,3,4,5,6"
ar = Split(apa, ",")
MsgBox(ar)
I would like my code to search through a listbox looking for "QB". Once found display message then stop. Write now my code continues to search through the listbox after. How can i change the way that i am searching the listbox?[code]....
View 1 RepliesI have this For Next Loop with a Delay that runs but it stops running till I hit OK on the MsgBox. what is the best way to do a task x times with x delay but not wait for MsgBox. [code]...
View 9 RepliesI have the following save function shown below, when called some tables get updated. Before fields are updated specifically to TblOracleNos what I want to do is when the text in TxtOracleNo has been changed and the save function called a MsgBox pops saying "Oracle number has been changed".
Public Sub Save()
Dim conn As SqlConnection = GetDbConnection()
Dim query As String
Dim cmd As New SqlCommand
If TxtNumPats.Text >= "1" Then
[Code] .....
i don't know how to display NO RECORD FOUND in msgbox..
here is my codes
Private Sub btngo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btngo.Click
open_con()
[Code].....
I have an array I know is getting initial values. I need to be able to see it's results visually like a msgbox. That will be the official output.
Sub SaveDestFile()
Dim StaffCode As String
Dim MyRec As String
Dim Duration As String
Dim FlagMe As String
[Code] ....
I'm having trouble with this
[Code]...
This code works fine for colllecting the the data and displaying it in the ListBox1. But then I want to display all the entries that are in the ListBox1 to a TextBox or MsgBox but I'm having trouble.
i have a Dataset command (DELETE FROM TABLE Where Name =@name)On my winform i have a Delete button that it deletes the rows, next i want to display the number of rows deleted to a msgbox, what i get now is 0this is my code:
Me.NetworkErrorsTableAdapter.Del(par)
MsgBox(" " & Me.NetworkErrorsTableAdapter.Del(par).ToString & " records deleted ")
I'm stuck! i'm trying to read a txt file with the data as below:
LEE
JOSH
JOSH
[Code]....
the txt file is updating all the time. So, i like to read this file and then display in msgbox the name that is most duplicated. In this case the MsgBox will show JOSH.
So I want when you click Button1, it displays MsgBox ("Hello"), when you click again, it displays Msgbox("World"). Then it all starts Hello "world hello world" etc.
View 5 RepliesI'm basically reading a memory address of Notepad using a module I got from a example... Then I'm displaying the text value of the memory address in a MsgBox. Everything goes well, I'm able to retrieve the text value and everything, but this happens.Lets say the value of the memory address is "Notepad". When the MsgBox comes up, it comes up a lot of times, displaying it like this...
1st MsgBox displays "N"
2nd MsgBox displays "No"
3rd "Not"
4th "Note"
and so on...
Here's my code, Module first, then Form1 code.
Module1.vb
Module
Module1
Private
Declare
Function
[Code] .....
I have a datagridview and in the _CellValidating event I am checking a cell to make sure it is filled in. If it is not, I want to stop editing, display a msgbox, and highlight the particular cell. Here is my code :
If e.ColumnIndex = 2 Then
If e.FormattedValue = "" Then
If Me.dgvFish.IsCurrentCellDirty Then
MsgBox("Sample Number is a required field.")
[code]....
For some reason, I can't get the cell's backcolor to be filled in.
I'm using VB.net 2005, .net framework 2.0
I'm currently having a form that has a button starting a long process, with feedback into another windows textbox (call frmProcessLog).
I'm using a Background worker to laucnh the process, upgrade the status of the process and display feedback on the frmProcessLog textbox, and to know when the thread process ended up, (from the cancel button, from an error or normal termination).
the main thread process has some msgbox in it, asking questions to the operator (yes/no/cancel).
I've added the msgboxstyle.systemmodal to the msgbox call which works "ok" excpet if the operator decide to ignore the showing message box and click the cancel button on the frmProcessLog form, which is still clickable even though I supplied "systemModal" to the msgbox. this makes the msgbox hidden behind the frmProcesslog form and the process can still continue.
If I close my frmProcessLog form, I will see the previously msgbox behind it and If I end up click one of the button it will end up at an application error because the thread that called it is not existing anymore.
So I would like that the msgbox to be launched from the thread making it as if it was launched from my frmProcessLog window in a modal way.
[code]I have a listbox, 4 radio buttons,a textbox and a button. I want the user to type in a number into the textbox, click on 1 radio button(multiplication) and then click on the button to show the number entered into the textbox multiplied up to 3 times. [code]
View 1 RepliesI can get the results if I plug a number in for i, but I get them as a string for some reason.
Private Sub displayButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles displayButton.Click
'display Fibonacci results
Dim fib(10) As Integer
Dim i As Integer
Dim fibn As String
I am using a WCF to connect to my database. I have the code below, I am trying to select all the details from the database where the customernumber = what the user has entered on the form.However, I cannot return a dataset to the form as it sends in a string.
Imports System.ServiceModel
Imports System.Data
Imports System.Data.OleDb
[code].....
I'd like to add a generic search feature to my WinForm application (Visual Studio 2010). I want the users to type in a value (for instance john), and then display a list of any company, contact, or student records that contain the search value in the name[code]...
View 3 RepliesI am working on a simple program called "Who's Connected?" where it runs a command (netstat -aon) and then displays the results in a multi-lined textbox. However, when I press the button that will run the command, it tells me that it can't convert the string to an integer or something. And when I did manage to get it to convert to an integer, it really showed an integer in the textbox instead of the connections and IP addresses. What do I do? Here is the code I have: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Running command and displaying results in textbox1 TextBox1.Text = CStr(Shell("netstat -aon"))'Results end up being a triple or quadruple digit number End Sub
View 2 RepliesI am trying to display query results from SQL server in VB. I wrote following code, but not getting how to "Just display the results";
[Code]...
I'm trying to present results on an aspx web page where a store procedure parameter is defined by a dropdown list control on the page. I have followed this guide from Microsoft and have my resultset presented in a DataGrid view. But I cannot seem to adapt it to present the resultset in a chart.
As you can see from my VB code below, I thought it would simply be a case of adapting the GridView databind to a Chart. I have tried various other options, and have successfully generated my data in a chart using a hard-coded parameter in an SQL statement on the ASP page. But when it comes to using the control, I get an empty chart.
Below is what I have so far.
Imports System.Data.SqlClient
Public Class Report
Inherits System.Web.UI.Page
[Code].....
I have an assignment where Im supposed to make a compound calculator which displays interest earned each year (e.g. next 10 years) as well as the total amount for those years. Im having difficulties in writing the code for the calculation.I know the formula and how it works but Im not entirely sure how to use it in VB
View 6 RepliesI'm trying to creat a search form so far ive looked EVERY wher with no luck ive been doing this for a week now ands its really ratteling me that i cant do it.
So i want to populate a combo box with data from my database in access and ive been able to do this ill show the code below, but then i want to be able to click someones name for example "Christopher" and once i click "christopher" i want the textbox's on the form to be filled with the correct information eg address age phone number[code]...
I'm using visual studio 2010 and sql server 2005 to store my data. I'm creating a system that will allow me to find/search for records that are stored within the database. Thing is, i have 2 separate forms for this - one is the find/search page which allows you to enter in as many fields as you want (the more you enter, the more efficient the search is) and the second one is the find/search results page which will show the results from the search.
I'm not using a datagrid as i've already created these forms myself. I'm on a tight schedule because i've spent so much time already trying to get this to work. Do i need to create another dataset and tableadapter and bind the text boxes? how will i code the find/search button so the search will be carried out and the results will appear in the other form?
I'm trying to make a form where the user enters a customers account info and then saves it to a file. the user should then be able to search for a customer by their last name and when it is found it display the customers info[code]...
View 6 Replies1. How to produce querry results within the application by user input. ( I want to acheive a similar function to querry in MS Access.
2. How to produce results in a form application from a preassigned querry triggered by a button click event.