I have created a table in sql server called "report" and it has 3 columns "reportname","reportfile" and "reportflag". the report flag has only two values 1 and 0,if the value is 1 this means the textbox on the form will be enable. I have managed to dispaly the reportname in the listbox and by the way this table is on the other network and i have also managed to connect to the sql database over the network. I have categorized my problem for easy understanding on my part and for the solution.
1.Connect to the server and display the reportname on the report table in the listbox of my form.
2.Select the reportname on the listbox and get the reportfilename and checked if the reportflag is equal to 1 or not.
3. Assign the result to a variable.
The category 1 is already solved but the category 2 and 3 is still on the part of my analysis since i am not to familiar to vb.net, I have been searching for solutions over the internet, unfortunately i was not able to find any answers.
My question is how can i compare it and assign it to a variable given by the result of the compare string using sql since i am using sql. should i still used the dataadapter or datareader and how can i assign it to a variable
Please give me some advice or reference to study. thanks in advance.