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.
I'm trying to do a LINQ Query against a typed datatable that will return me duplicated data.With out going into too much detail, here's the basic setup:
strCode1 - string type
intCode1 - int32 type
intAdjustor - int32
There are more fields but these are the ones that are important.I'm going to do my best to describe this, as it's kind of confusing.In theory intCode1 is a key for strCode1 (hence the names). So each time intCode1 is duplicated, the same strCode1 should appear. Example:
[code]...
Ultimately I'd like to get a List(Of T) - where T is my typed data row. In SQL, I would simply use a sub query, to get a distinct list of strCode1 and intCode1, then do a count, grouped by strCode1 where I get more than one row.I'm not sure how to translate that into LINQ, AND get the original types data rows returned in a list.
But i've a problem, everytime i hit the button "Save Settings" in my form/application it will re-save the settings to ini file, causing duplicate entries :(
Does anyone knows how can i avoid it to happen?
And, how can i retrieve a setting from the ini file to a textbox or messagebox or something?
(before anyone start saying me to use .xml, i was reading and i prefer the .ini files to what i'm doing)
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 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 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 ")
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.
if its possible to have a msgbox cleared without having the user do it manually? what would be my best option here?
View 8 RepliesI'm running a script which should display data from a .txt file
I declare variables:
division = Request.Form("division")
if division = "view_all" then
operation = "viewall"
[Code]....
however no matter what i do it ends up writing File does not exist, read aborted.
i have an array of double. May i know how to get all the data to be display into MsgBox? The code below has problem saying "1 dimensional array of Double cannot be converted to 1 dimensional array of string". I tried using CStr also cannot.
Dim numbersAsString() As Double = Array.ConvertAll(res.ToArray, New Converter(Of Double, Double)(Function(i) CDbl(i.ToString)))
MsgBox(String.Join(" ", numbersAsString))
I'm trying to develop a program which read from a text file data.Then display one data line per time with 2 sec delay in an lcd which is connected throught the internet.[code]....
View 4 RepliesI have a datagridview which have 5 columns. The name of the columns are T,C,F,S,H.
I have a text file which contain lines like this.
T240C3.175F012S27H2000
T239C0.95F034S55H1000
T236C1.2F029S48H2000
T234C1.6F029S48H2000
So i want to display this data in datagried view. I must display the number beside T to T column, the number beside C to C column and so on. It should only display number in the respective column. It should not display the T,C and so on.
I like to make a data grid that get data from a .csv and display on the table (note all the data is separated by ",") but I have no idea how to do this.
GRW,1001,LGAV,LGTS,"NEVRA Z507 OSMOS",SX-GRI,240,161,00:00," 00:00"," 1.05"," Flight Level:240"," 80"," P"," 0123456"," 1"
GRW,1002,LGTS,LGAV,"LEKPO UB1 ABLON",SX-GRI,250,161,00:00," 00:00"," 1.05"," Flight Level:250"," 80"," P"," 0123456"," 1"
GRW,1003,LGAV,LGRP,"VARIX UL995 ASIMI",SX-GRI,270,218,00:00," 00:00"," 1.2"," Flight Level:270"," 100"," P"," 0123456"," 1"
GRW,1004,LGRP,LGAV,"ASIMI UL995 VARIX",SX-GRI,280,218,00:00," 00:00"," 1.2"," Flight Level:280"," 100"," P"," 0123456"," 1"
GRW,1005,LGAV,LGKR,"PIKAD L53 KRK",SX-GRE,240,213,00:00," 00:00"," 1.15"," Flight Level:240"," 80"," P"," 0123456"," 1"
this makes sense given the context of the document but I heard that XML tag's should have Unique ID's, which is fair enough but I was under the impression that each child node does not know about other child nodes outside its parent? What is your thought on this?
HTML
<?xml version="1.0" encoding="utf-8"?>
<main>
<SourceType ID="XAML">
[Code]...
code that can display data in tabular form for a text file. vb 2005
View 3 Repliesnow my code is delete all the row with Itemcode. If i only want to delete one of my duplicated Itemcode row?textbox8 is connect to Itemcode column.
Dim del2 As String
If MsgBox("History Record Delete?", MsgBoxStyle.YesNo) = MsgBoxResult.Yes Thendel2 = "Delete from Receive Where Itemcode = @Itemcode"
[code].....
Now my code is delete all the rows Itemcode. If i only want to delete one of my duplicated Itemcode row?
textbox8 is connected to Itemcode column 0.[code]...