need to search mysql for something and return the value in the next colum

Question

Hi all, 

i have a very simple table in mysql, i can connect etc fine, and i think i have the query i need, but how do i get this working in c#?

what it will basically do is find a username based on the windows username.

sUserName = Environment.UserName;

"'select sms_un from smsusers where domain_un = ' + sUserName;";

sorry its quite hard to describe :) does this make sense?

Answer 1

I don't know. I have spent some time trying to figure out what to do; I have spent as much time as I should allow for this.

Have you looked at Compile and Link Considerations? If not then that is likely to help. If you have not added Advapi32.lib to the list of libraries for the project then do that.

Answer 2

    I have taken that code from microsoft website and link is as follows

http://msdn.microsoft.com/en-us/library/ms867026.aspx

  You will code from mention wording from site "Download the associated CertificateEnrollmentSamples.exe."

  And try to compile "PKCS10AltSubName.cpp" code.I thought crypt32lib was missing but i have found it in the SDK folder. So unable to know the real cause of issue.

Answer 3

The code is not attached. Instead of attaching the code, if you can tell us where you got the code from, then that will help.

Is the code C++? I assume it is. Those error messages are from the link editor which is executed after the C++ compiler. There is probably an #include or possibly an #import missing, but this is an area with a lot of confusing details. Your best chance of sovling the problem is to read what the web site says where you got the code from. There is likely something you are overlooking.