how do I query the dataset with more than 1 table, I mean, using the JOIN statement.
if I want to select data only from 1 table, it's easy, I can do it with the select method and give the parameters in the function. How do I query more than 1 table to get result from more than 1 table, making...
thanks I have just found those tutorials by Microsoft and il going through them.
There is only 1 thing which I can't understand, what they do is:
result(rowIndex)(columnName) = "value" or result(rowIndex).Delete()
why they do: result(rowIndex)(columnName) and not...
Not sure i have fully understood that.
When you wrote "DataTable.Select" the DataTable is the name of the DtaTable that I'm querying? Is it like: "Names.Select()"?
and what exactly the variable result holds? Could you provide me an example and show me how do I then use the variable result...
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...
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...
I have tried to use richtextbox but i couldn't get what I want bolded, because when I tried to read the richtextbox content and replace characters, I have received an error. The richtextbox is being made at run-time and I add it into a panel and after I add it into a panel, I tried to bold some...
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
I want to bold the AD in the word to be like that:
is it possible?
this is how I generate the label...
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...
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...