Hello everyone,

Alright, so I know there are a lot of threads on mysql and similar things like that but none of them are making any sense to me or are more advanced then I really need to just check if the record exists and save some cells as a variable. Now in PHP this is quite simple for me to do but even with all the pages on here and other places I've looked I haven't found anything that I can understand how to implement.

I'm using Visual Studio 2010 Professional - vb.net app with .net framework 3.5

MySQL Connector Net 5.1.7

--------------------------------

The following code is php form of what I need to do:

Code:
$incomingRNS = $rns; (RNS is passed into the function)
$result = mysql_query("SELECT * FROM software WHERE RootNS='$incomingRNS'");
while($row = mysql_fetch_array($result)) {
  $rootpath = $row['RootPath'];
  $specialtext = $row['SpecialText'];
}
I'm missing some code to verify (Like check that it only returned one record and to just error if it doesn't)

I included the PHP code because thats the only way I know how to do what I need. Can anyone help me? I seem to have a VERY VERY hard time grasping certain concepts in coding.

Thanks!

Dustin