Ok, my script which is a follow on from a previous thread on writing to a text file needs another thing added to make this one form hopefully complete. (in fact its two things).Firstly, when the 'Save' button is pressed, I want it to check to see if the textbox1 text is already used (textbox1 is the plu field, but still titled as textbox1). So if the save button is pressed, I want it to check first if that number has already been used, and if so, display an error message and don't save, and don't clear the fields so that way the user can enter a different number in for that item.
Secondly, several fields are numeric only. I've tried a couple of examples and are either too complex or just don't want to work for me. How do I ensure that some fields are numeric only (well one is a percentage, two fields are numeric and 1 is a currency field).
How do I not return duplicate random numbers with Do Until loop?
Dim numbers(5) As Integer Dim subscript As Integer Dim searchSubscript As Integer Dim randomNum As Integer Dim randomGenerator As New Random Dim isFound As Boolean
Recently, I have a requirement to develop a vb.net application wherein the input excel sheet data which has an average of 5000 records should be checked for Internal duplicates (duplicates within the same sheet) and external duplicates (duplicates which exist outside this sheet). I have gone through lot of logics..some of which are ...
- Common and currently testing out..
- First insert the excel sheet data into DB..then query by following
select distinct id,mobilenumber from scrubmaster where calltablename=<calltablename given by the uploader>
Then loop for duplicates...
[code]....
The above logic works but it takes very long time..I have tried other logics from web but they "Query timeout"...
I'm Using Griaule Grfinger X 4.2 SDK for a project. I am able to enroll templates into database, also identify and verify fingerprints against registered ones in the database.But I have a further challenging issue. I want to be able to run through the database to check for duplicates so as to identify them in which I would put duplicates in a hotlisted database.
I have a list of objects, each with 2 relevant properties: "ID" and "Name". Lets call the list "lstOutcomes".I need to check the list for duplicates (meaning object1.ID = object2.ID, etc.) and set a flag (valid = false, or something) if there is at least one duplicate. Also, it would be nice to send a message to the user mentioning the "Name" of the object, when it fails.I am sure I will need to use the Group By operator to do this, but I am not used to doing that in LINQ, and the examples out there are just not helping me. This article seems to be close to what i need, but not quite and it's in C#.
Here is a starting stab at it... Dim duplist = _ (From o As objectType In lstOutcomes _
I'm reading and writing to an xml file and am looking for a way to identify and delete certain nodes. Below is an example depicting the data as rows with each row sequenced in "Sortorder". As you may note, "Sortorder=1" data is there twice.one row containing data... the other not. I'd like to keep the row containing data and delete the one that has blank data elements.
Currently I am saving data from my applications by saving a text file via a stream reader as a string. I have come to a problem. In my current application, I have an array of the following structure:
I'm trying to make a snippet that will remove duplicate lines from text files. However, I seem to be mixing my for loops up.. does anyone know a simple way that I could do this?
so here is my scenario. I have two input files... both are plain text files. File1 has customer name, customer address and invoice number. File2 has customer name, customer address, invoice number AND a keyline. File1 will only contain some of the records in File2, and it will change daily. I need to be able to compare File1 against File2 and output one file (preferably an Excel spreadsheet) with the info from File1 and the keyline from File2, that matches the duplicated info. I know the basics to get it to work, but I'm not sure what would be the easiest way of doing this... File2 can have up to 100,000 records per day. I'd only need to run it once a day though.
I thought this would be an easy one but I can't think of a good way to do it.User submits a webform. Based on submitted information I build three classes and assign their properties from received data:
UserInfo userInfo = new UserInfo(); UserAddress userAddress = new UserAddress(); UserEmployer userEmployer = new UserEmployer();
Based on submitted information some classes end up being populated with properties and some do not.
What's the best way to check whether userInfo class, for example, ended up with properties assigned ? I don't want to save a particular object to the database if it doesn't have any real properties assigned and all of them are set to either null or "".
I only want to save the objects that ended up with at least one real property assigned.ps. using NHibernate to save data to db
I have an insert statement which works fine but before the record is saved I want to validate the text boxes. So I just need to know how to check for empty text boxes before the save button is clicked on. I have seen a couple of examples like:
Dim ctr As TextBox If ctr.Text = vbNullString Then MsgBox("empty box")
I am creating a shell for a FORTRAN application which reads a tab delimited text file.Because I am using Excel to manipulate data, is it possible to use the Excel Automation features to "save as" a tab delimited text file?The only method available seems to be a unicode text format, which does not work. Or is there another format that mimics tab delimited so that the FORTRAN application will read such a file without difficulty?
I have an asp page with vb.net code that will query a database and present the user with the number of records that exist that need to be exported along with a button to export them. After you push the export button, it will prompt for a location and filename. But after that, it will not refresh the page with the new counts that now exist. Or in this case update the count to zero for the button they clicked. [Code] So how can I tell the page to refresh with the new counts. It almost seems like I need to tell the process to wait until after the user has finished finding the location and saving the file but I don't want to add a generic threading.thread.sleep in, I want it to only wait until they are done and then refresh the page.
Currently the reports are saved as a html file called report1.html, id like to make the user enter a name for the HTML file upon clicking submit.
A little stuck on how to make the filename for the HTML file save to a input entered by the user.
I currently have:
Try 'Open new HTML file to be written WriteHtml = New StreamWriter(Application.StartupPath & "ListHardware.html") If Not (WriteHtml Is Nothing) Then ' Is the File Open
Our program will start with the help of a FileSystemWatcher object. How can we check or the file is total copied, for example the file is 100 Mbyte it take a time it's ready for use. Idea:
Do While True Try N = testForUse(BigFile) If N = 1 Then Exit Do
i just found a new error problem on my app.. i have a save button that saves text1. as the file name and text2. as the content.. i recently tried to save this file name on my app: HKEY_LOCAL_MACHINESoftwareC07ft5Y as a file name, and due to the in the file name, it made my app error and close without being able to save my file.. my question is, how to bring a msgbox saying "invalid characters in file name" instead of causing it to error and shut down. (just found out that registry entry is for SafeDisc-enabled products, although, i'm not fully sure..)
I'm trying to find out if it is possible to something and really need your help.
What i want to be able to do is have a RichTextBox on my form that i can enter my description into, then when i have finished i want to be able to save it to a memory stream as a .html file.
I then want to be able to read the source of the HTML file to amend the format of the description and then display it in a webpage?
Public Class Form1 Dim ScreenData(3, 4) As TextBox Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click FileOpen(1, CurDir() &
I've been working with Editing a jpg through Hex. I have the code to open the hex of a file, but I just need to know how to write the file so it is able to be viewed as the same jpg. Editing aside, I just need to know how to write the file. Here's the code I have so far.
I am working on a note taking application. I have got a treeview and a richtextbox. On the treeview note captions are organized in a hierarchy. When a tree node is clicked related note details are displayed in the richtextbox. I use an xml file to save and load the treeview state (including nodes, expand collapse state, image index etc). I want to include all the note details in this xml file as well. But I dont know how to save richtextformat into an xml file.
I have this script that I'd like to in addition save as a xls file, also save as a .txt in the same directory, or even a different one. Can I get some guidance here?
Imports System.IO Module Module1 Private Property fs As Object Private Property BaseName As Object Private Property FullTargetPath As Object
in a winform how do i get one of those fancy windows "save file as" dialogues to appear so that the user can save a string as a file to a user-specified location on their hardrive?
I am exporting my values in my textboxes to an excel spreadsheet (user clicks "Export" button on form). After it is done, it asks me if i want to overwrite my current excel spreadsheet. Is there a way that I can open a save as dialog box so I can choose what name and where to save it?
Private Sub ResultsExcelbgw_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles ResultsExcelbgw.DoWork Dim Resultsdata As ResultsDataDef = DirectCast(e.Argument, ResultsDataDef)
i have multi columns that i want to save. i'm missing something here...just dont know what. I can get one column to save only. but i have columns like "name", "address", "phone number"
here is my Form1 code
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ListView1.Columns.Add("Name", 100, HorizontalAlignment.Left) ListView1.Columns.Add("Phone", 100, HorizontalAlignment.Center)
I'm rather new to vb and was wondering if someone could help me out with saving and opening files from a lan.trying to write a macro that will open and save a file from a lan drive that may have different drive letters depending on what each person wanted? I've been susessful in getting a file to open with my current mapped drive but i won't work if other people use it.
I want to do that when i load form that saved picture is there. I tryed to make code but its dont work , dont show errors too. Mabye its not possible to do that.
Private Sub ToolStripLabel1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripLabel1.Click Try Dim dataloader As New System.IO.StreamReader("c:data/Picture.bmp") PictureBox1.Text = dataloader.ReadToEnd
But I would like to save in then retrieve later.So far I've declared it as
Dim ActiveScoreTable As New NewGameDataSet.GameTableDataTable() Dim ActiveScoreTableDR As NewGameDataSet.GameTableRow = ActiveScoreTable.NewGameTableRow() 1) But how do I get to the save command?
