Search results for query: *

Hello! Is it possible querying a dataset instead of the Database? When I create a query in the designer, I think that when I activate the query, I actually querying the Database and not the Dataset. In addition, lets say I want to find some record in the dataset from Table called "books" how...

Hello! I have scroll-able form which I would like to print. I have already tried using this code: Private Sub btnPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrint.Click Me.PrintForm.PrintAction = Printing.PrintAction.PrintToPreview...

Hello! I'm creating labels with text that I get from a query. I want to bold certain characters in the output. Let's say the user searches for "AD" and one of the result is "DAD" I want to bold the AD in the word to be like that: "DAD" is it possible? this is how I generate the label...

Hello! I have a Database with 5 tables. At the beggining, I used only 4 tables, and now I see that I need another table, I need 5. I have added the fifth table to the Database, but, how do I add it to the current DataSet that I have in my program? I don't want to re-create my whole program...

Hello! I got a program for movies rental. In the program, when you start typing something in the search box, I used a Panel to hold the SQL results of the movies name. Everything works perfect. There is one slightly problem. If I want to allow the user to scroll with the mouse wheel in the...

Hello! I have got a TableLayoutPanel and everything works greats. There is one problem, when I'm tying to scroll up and down the Panel, nothing happens, I have to actually drag up and down the scroll bar or press the little arrows in order to scroll. How do I activate the scrolling with the...

I'm trying to make a TableLayoutPanel with PictureBox + Label in each cell. I have got it all right but I just can't set the cells sizes to be the same! I'm trying to have 4 columns with endless number of rows, and I would like the cell to be in the Label width, unless the Label width is smaller...

Hello! I have a database table which contains movies information. The information stored contains the movie's name, description, photo, and an ID. I want to display on the form the photo of the movie in a picturebox and the name of the movie in a label. In order to display many movies, I have...

Hello! I want to have a database which contains photos of movies in it. My idea to do it was storing in the database the path of the photo in the database, and then use retrieve the path from the database and use it in a picturebox control. Is it what I need to do? or maybe there is another...

Hello! Let's say I got a dataset named TestDataSet and I want to use this DataSet in another 3 forms. When I drag a GridView on other form than the main, it automatically creates BindingSource, DataSet TableAdaper and etc. If I update the new DataSet that has been created by the wizard when I...

Hello! I tried to do a simple Select query, but for some reason, when im trying to populate a table with the query result, I get this error: The error line: Using BorrowID As DataTable = BooksTableAdapter1.GetData_BorrowID_By_Given_BookID(bookID) The full code: Dim bookID As String...

Hello! There are some queries that I can't make with the vb.net for some reason, but I can do them in access. The reason I can't do them it's because, I'm using 2 queries to eventually give me a single result. For instance, I got Costumers Table, Borrows Table and Book Table, and I wanna...

Hello! As a practise, I started to build a MINI library application. Finally, I have understood how to use queries and parameters. My problem is, When i attempt to add a row into a table, I get the following error: the code that i try to commit: borrowerID = cboCostumers.SelectedValue...

Hello! I'm tring to bind data into my listbox and combobox ,this is what i've done so far: lstBooks.DataSource = borrowDS.Tables("Books") lstBooks.DisplayMember = "BookName" lstBooks.ValueMember = "BookID" cboCostumers.DataSource = borrowDS.Tables("Costumers")...

Hello! I have read about the ADO.NET and learn some new things. In order to practice what i have learned, I want to create a library model with the following access tables: Table Name:Costumers Fields: CostumerID, CostumerName, CostumerLastName Table Name:Books Fields: BookID, BookName...

Hello! I have a question related to DataRelation and SQL Queries. Let's say that I'm using access database which already has relationships between the tables, and I'm using a query to result to fill a new table or something like that, why would I need the DataRelation? or maybe the DataRelation...

Hello! I'm using the OleDB class to represent my database. what i tried to do is to let the user select multiple rows in the DataGridView and then press "Delete" and it will delete all of the selected rows. It could be 1 row, or even 100 rows. I couldn't figure out how to do it :( Thanks in...

Hello! I have been looking for a good website/book that will provide me the information i need about databases in VB.NET. All I could find was using the built-in wizards, which isn't enough. I want a book/website that will teach me how to also work with the code and not only with the wizards...