I'm trying to make a program for a school assessment in VB express 2010 using databases. The program essentially has a panel for uploading an image with a name string and an author string, which it then stores in a database. You can then search the database using the name or author string and find pictures that fit the criteria.
View 2 Replieshow to find data using search command in my form application like searching a name in my database?
View 1 Repliesi have a search function in my program in order to find records from an access database... all the other functions add/edit/delete are working just fine this is my code for search function: [code]
View 16 RepliesI am trying to do a search on a index/row number taken from a dataview i.e. I enter 379437 in the input box which I know has a index/row number of 6. Now when I replace the Rows(index) with a Rows(6) I get the results that I want. When I run the code below the index comes out as 75 which displays the first row from the dataset which is a completely different set of results.
[Code]...
I'm new here, but have been in and out for a while. Past threads have been helping me along thus far.
I'm currently developing an app which essentially needs a way for me to search in a text box or file for a specific string, and extract the line on which that string appears on. It will be unique, and the syntax is the same on each line. It has basically 2 ID numbers, and is laid out like this:
123456|123456
So, I'd need to search for the first part before the |, and then get the line so I can get the bit after the |, which is the important bit for me.
I have a string which consists of the raw HTML of a webpage. I would like to search for the first use of /imgres?imgurl= within the string and display the url of an image which follows exactly after it in a text box. Below is an example of part of the string: [URL]..In this case it would find /imgres?imgurl= then it would display [URL]...
View 2 Repliesim trying to find a small difference in 2 images and return the x, y of where the difference was found, i have no idea where to start.
View 3 RepliesIt is very easy to move your cursor to a specific coordinate but my question here is how do you move your cursor to an image? Now what this would involve doing is importing an image so the program understands it, then finding that image on your screen (maybe through RGB colors). How exactly do you do this? What is the procedure?
Say I want to import this image: Now I want the program to find that image on the screen (THE START BUTTON) and then move my cursor on it.
so cursor.position = new point(the image)
Finished with my overlay program. Now I want to give users the ability to show their own images. [URL] That is an example of the program. Currently on the right I just have a drop down box with that image tied to a form. I want to have a blank form that allows people to select from files on their own computer to be displayed. Edit: Just realized the print screen didn't work (well, obviously it worked) but it didn't capture my overlay. Will try to take another. Let me know if you have any questions,
View 1 RepliesIs there a way to tell the DISPLAY size of an image in a picture box? If the PictureBox.SizeMode=Zoom, the picture sometimes is not displayed as big as the picture box is, and is sometimes displayed smaller, or larger, than the actual image is. I just want to know what size it is actually displaying as.
View 3 RepliesI was trying to do a simiple, fine a string start position, or a string, and it always returns 0
Dim My_Search_String As String
Dim My_Text As String
My_Search_String = "fsl fwb fcb"
[code].....
I have a HTML code in my RichTextBox:
<b>
<i>
Text
</i></b>
I use this code to search a text between two tags, example <b>,</b>.
StartCode = InStr(1, MyString, "<b>")
EndCode = InStr(1, MyString, "</b>") - 3
RichTextBox1.Text = (Mid(MyString, StartCode, EndCode - StartCode))
Now i want use that:
StartCode = InStr(1, MyString, "<b> ???NewLine??? </i>")
EndCode = InStr(1, MyString, "</i></b>") - 3
RichTextBox1.Text = (Mid(MyString, StartCode, EndCode - StartCode))
Now instead of ?NewLine? what should I enter?
I have a HTML code in my RichTextBox:
[Code]...
Now instead of ???NewLine??? what should I enter?
how to find connection string of any database or any server like, access or sql or Oracle?ans:-to find connection string.first open the new notepad.don't write anything it it.just save any side like my document,or Desktop with any name and give it's extension. " UDL ".after there will be one PC type folder will be created. double click on that folder and go to first tab that is Provider.select your provider like Access, Sql etc. and go to Next tab that is connection. if access then it will tell you enter database name or you can locate your database .mdb file and if it is sql then it will ask you your server name, authentication and database name. select it and click on text connection it will give message connection is OK.then close the file and further open that file with notepad you will get your connection string.
View 2 RepliesI want to find the text in textbox in my database. I wrote the code below. It finds numbers well, but when I want to find strings it gives a runtime error: invalid column name for example aaa, but aaa exists in column1 in my table.What do you think about the problem?
cmd = New SqlCommand("select * from tbl where column1=" + TextBox1.Text)
cmd.CommandType = CommandType.Text
cmd.Connection = cnn
[code].....
i need to check a text in a lakh of files. as now am looping through files, is there any other fast approach to make it work easily.
View 6 RepliesI have created a hotel booking system programme. However, I am puzzled as to how when the booking button is clicked it can search a database and find the best suited room (RoomType) and make sure that it is available (Date of Departure < system.date).
This data is held in two tables (Access):
Booking:
BookingID (Primary Key)
CustomerID (Foreign Key, Table:Customer)
Date of Arrival (Date)
Date of Departure (Date)
RoomID (Foreign Key,Table:Room) Room:
RoomID (Primary Key)
RoomType (Text)
RoomPrice (Currency)
Floor (Number)
This has all got to be done within a single button click. Any ideas as to how I can place this into my vb code?
I have a rough query for picking a room that is best suited:
Code:
SELECT roomID
FROM Room INNER JOIN Booking ON Room.RoomID = Booking.RoomID
WHERE Room.[Room Type] LIKE '" & Room_TypeTextbox.Text & "'"
AND Booking.[Date of Departure] < Now()
I have been trying for a while to get it to select a single matching record as there is a high chance that this query will return multiple records but im unsure on how to deal with that.
The form it is on is frmMidwest.vb, the database is MarchMadnessDB, with the table being tblMidwest and the column being Username. I am trying to get it so when the user loads frmMidwest.vb it will then check the database to see if the user has entered their picks and if they have it will load their picks back into frmMidwest.vb if the database cannot find their user then it needs to add a record to the database and allow the user to enter their picks. I have already established this with
TblMidwestBindingSource.AddNew()
But if the user exists I do not want them to be able to enter another record. The primary key in the database is the username.
How can i search my database using a combobox were he will suggest list of names in the combobox list . It will search all fields in my database. My DB is created in access.ex. i type Kev then the combobox list will have Kevin then Kevlan on its list knowing that Kevin and Kevlan are in my database .
View 11 RepliesI have built a search criteria for a table in my database. I have 3 textboxes first says anstnr second says firstname and the third lastname.The problem is that i cannot search if first field "anstnr" is blank. If i only will search on firstname thats not working.
Private Sub FillByolikaToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FillByolikaToolStripButton.Click
Try
[code].....
I created a STRING SEARCH function in C/C++ - and I'm trying to use it in a multi-threaded situation in VB. I started this problem in a thread in the C/C++ section of the forum - here [URL] my last post shows me getting this error trying to call the function. Ran the code - got to that point - and in the immediate window I did
[Code]...
I'm creating a new (or more) tab(s) with a multi-line textbox (filled) at runtime and some text is added. Each time I change/select a (new) tab it needs to search for a string and if found...blablabla.How do I get the control to search in?
View 8 RepliesI am trying to search through records of my database in a VB form and I don't have any errors or warnings but it doesn't work.
Here is the code and a screenshot:
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim search As String
search = boxSearch.Text = txtSearch.Text & "'"
Dim foundRows() As DataRow
foundRows = taxDS.Tables("Orders").Select(search, boxSearch.Text)
End Sub
txtSearch.DataBindings.Add("text", taxBS, boxSearch.Text)
boxSearch.DataBindings.Add("text", taxBS, boxSearch.Text)
searching a database using multiple words from a textbox showing in gridview.
<asp:TextBox ID="TextBox1" runat="server" Width="382px" AutoPostBack="True"></asp:TextBox>
<asp:Button ID="Button1" runat="server" style="height: 26px" Text="Button" />
[Code]....
It works fine, i click button and the gridview shows all the right records. The problem is when i use more then 1 word in textbox. it shows nothing. The record in the database field may have several words, so i need to search using all words in textbox.
I am developing a application in which i need to get images from a search engine. there are many choices to do that google,yahoo, bing etc. I chose bing simply because microsoft provides tight integration with bing and it offers more functionality to developers. So after searching some more i learned how to use this service in my application. Created a key and added web service reference in my solution.[code]But i cant figure out how to do that, after a lot of searching i came up with this link here url...I am unable to use it. If i use it no results are returned.
View 4 RepliesIs there a way to find ALL of a specified string from a multiple-line text and express their line number as integers?
View 10 Repliesworking on a March Madness Program and need help searching the database. I have the database all linked and all the cells connect, but now I need to make it so when people login it will search the database for their username and password to verify the user. My database is in access is called MarchMadness, with the table being tblUser and the column's are "username" and "password"
View 2 RepliesHow do you store data in the access database and also to retrieve it? and also a search engine for the database?
View 1 Repliesi have created a database application in visual studio 2010 running with visual basic code, the application works great but i want to add a search feature on the dataset bar in the application next to the add and save how do i go about it,
View 1 RepliesI'm using VB.NET 2010, and Microsoft SQL Server 08 Express. I've never done a data bound project before so forgive me if I have no clue what I'm doing.
[Code]...