I'm trying to design a words game that's give you the first two letters from the word and you insert the rest to make a word (for now I'm just using "co" as example and I have just one table in the database for it). The word will be written in textbox to be compared to a database field. If the word exist in the field the word will be displayed in a label with blue color and the score will increased by one if not the word will be displayed in the label with red color. This should happen three times with three words and I have different label for each one.
the name of my database is database1 and it have one table "A" wich contain "Comp" and "word". I tried this game with array of word before and it was working. Now I'm trying to use database instead of arrays but its not working. [Code]
i connect database with vb.net and also i receive a single value from my receiver through serial port. now i want to match this single data with one field of database. i have attached my code.
Public Class Form1 Private Sub OPEN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
I have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
I am using Visual studio 2008 to build a web application. What I am trying to do is retrieve data from a database and populate text boxes based on the results.
I need to add (Append) additional text to the Comment field in my access database from a RichTextBox. I am having difficulty with the sql connection syntax.
I am trying to bind data from a text box on my form to a field in my database table. First of all I have created a DataSet, BindingSource and Table Adapter in the forms Design view, but I am having from there. Under the properties of each text box I have set the DataBindings (Text) to the field in the table under the forms instance and DataSet rather than the Projects Data Sources. I am very rusty at Visual Studio 2005 and that is all I have to work with.
There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
The OwnerID relates to the ID in the users table, how can I get the name of the user who's ID matches the OwnerID? I'm writing a website in ASP.net (VB).
Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
I have a textbox for searching a database. When the text changes it runs a functioncFilter() and loads the records. It is set up to search different columns of a database, and it unfortunately only the first record matching is pulled from the database. Example: when the database contains two people (Bob Smith & Bob Smitt) the user can type the name in the search field. However When the user types Bob Smit it only returns Bob Smith and not both names in the database. I want this to act as a filter, dynamically changing the last with each additional letter typed in the search box. Below is my source code,
Public Sub cFilter() Dim myConnectionstring As String = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & My.Settings.dbLocation & ";Persist Security Info=True;Jet OLEDB:Database Password=BCFAdmin")
In VB6 datacombobox there was a property that you could set that filtered the item list as you typed in the combo box (extended matching I think it was called) so that as the user typed more characters in the box the filtering progressively narrowed down the number of items in the list.The .net control does not seem to have this facility, or does it?Do we have to programatically do it now?
How to match one value to another value in same text file. For example I have a this value : 116.71 33.3 in my text file. I want to check whether another same value exist in a same text file or not.
I used this code to find my first value Do myLine = myReader.ReadLine() Loop Until myLine.Contains("*+*+* Top *+*+*") Do Until myReader.EndOfStream myLine = myReader.ReadLine() [Code] ..... Once I get the value I want to check another same value exist in the same text file or not.
In this exmample textData is a string of text and alpha is a single letter a through z or A through Z. I don't need the criteria to be case sensitive, but I do need only the first letter of textData to match alpha. I have tested the LIKE comparator and it does not return all records that begin with alpha.
The application must have basic functionality as to: Insert new customers into the database A search function will be needed to find a users criteria entered The more advanced features would include matching certain criteria with another for example if the data in field 1 is the same then it should match this and return the results. so for example if a person has a hobby of 'football' it will return all the people with the same hobby
I have to scan through documents. Excell, Word, txt, ect looking for company names that match a pre-difined list of companies.I then email the companies some specifics in regards to that doc.The problem I have been having recently is that the list of companies keeps growing and I am starting to miss some more than I used to.What I would like to build is a tiny app that has 2 Text boxes.1 on the left for input (where I would copy/paste) the document text I receive.and one on the right for the output where it will highlight any line that contains the name of any of the pre-defined companies.
I started toying with the idea and so far I have form with a SplitContainer. Within that SplitContainer each side has a TextBox... Below the Textbox on the left hand side splitcontainer I have a submit button with no actions currently assigned to it.
I am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information DVD Information Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb] SELECT [Member Information].[Member ID] FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
i created a form with a combobox that lists out Assignments ( assignment 1, assignment 2, etc...)......what i need to do is let the user choose an assignment, then the program should look for the matching text file in a folder, ex: user picks assignment 1, and the program will read from assignment1.txt and display the result in a listbox. I have everything except the coding to match what the user chooses and the text file to streamread.
I had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet?
i want to fill up the userID and password fields of the yahoo mail login page with the click of a button on the form but just cant get it right.[code]it just skips the yahooID field and fills out the password field. what is wrong or is there a better way of doing it?
I'm trying to make an appointment scheduler here. The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.
Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it [B]does[/B] save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program. I don't know if this is because I've tried so many data sets that it's getting them confused or what, but here is the code that I am using to try to save this:
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
I have a form with a button that says "Open CSV".I want to be able to click that button. Then browse for a .CSV file, and after I select the file, populate a combobox with all of the headers of the .CSV.I would then be mapping these headers to fields in my database, then import the .CSV data into my database.
i have a table name product , when i m inserting data into product i need to first check if Product Name already exist in database if yes i want to exit. basically i want to know how to get data from the database and how to access columns in asp.net .
