I love the magic that programming does, that's why am here.
Right here, I am using
..........Visual Studio (VB.net) 2012
..........SQL Server 2012
I am actually creating a program to do two main functions....
1). To Search for records from multiple MSsql tables and display the result in a report viewer or crystal report. (I don't want to use datagrid display on forms)
I have a screenshot of the User Interface, but I wish I could attach it here.
I want to search the student table when the user selects the first radioButton and to search the institution table, when the user selects the second radioButton and display the search results in any simple report (Crystal or ReportViewer). Kinda in a search engine pattern though.
I don't know how to even proceed.
2). To randomly assign data from one field or column in a table to another field or column from another table, in a report viewer or crystal report. This module will select an item from the list in the combo-box as its filter and collect information from Student table, school table (tables I am using for the application) and most importantly, randomly select a state from the state table, where the state ISNot students' state of origin.
ok... an algorithm of what I want should be like this.
select (student name, course, school, state_of_origin) from student_table then randomly select (any_state) from state_table where any_state ISnot equal to student_table.state_of_origin display result in crystal report or report viewer
I want to code the 'Generate' button to get random data from the state column in the state table, and assign or should I say append it to the expected result from the algorithm/query above.
I haven't written any code or either module, so please bear with me on the absence of codes in this problem, which I know will make greater sense to you. But with the explanation above, I feel you have an idea of what I intend to do.
Thanks so much in advance.