fetching email address in a variable

Question

2.33/5 (3 votes)

See more:

I want to retrieve an email address from the database , strore it in a variable of string type and then send mail on that email address,the email address is successfully rerieved but ehen i write this variable in send mail method it shows error "use of unassigned local variable", the code is shown below.

con.Open();
        string addquery = "SELECT  [EMAIL] FROM [DATABASE NAME].[dbo].[TABLE NAME] where Column Name='" + txtRegEmp.Text + "'";
        //string query = "select EMAIL from USER where REGNO_EMPID = '" + txtRRegEmp.Text + "'";
        SqlCommand sqlcom = new SqlCommand(addquery, con);
        SqlDataReader myreader;
        String emailad;
        myreader = sqlcom.ExecuteReader();
        while (myreader.Read())
        {
            emailad = myreader[0].ToString();
           
        }
        myreader.Close();
        con.Close();
        //sending email button code 
       Response.Write(SendMail("abc@gmail.com", "emailad", "abc@gmail.com", "Good work done"));

it shows error of emailad

please guide me in this regard

Posted 11-May-11 11:30am

muntahach

Updated 11-May-11 13:07pm

raju melveetilpurayil

v2

Add a Solution

Comments

muntahach 11-May-11 18:24pm

it shows error when execute scalar is used
Cannot implicitly convert type 'string' to 'System.Data.SqlClient.SqlDataReader'

raju melveetilpurayil 11-May-11 19:08pm

[Edit] edited for more readability [/Edit]

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

raju melveetilpurayil · Answer 1 · 2011-05-11T13:37:00

If you want to select single value from Database you can use ExecuteScalar() Command
ExecuteScalar() from MSDN[^]

check the sample

SqlConnection con = new SqlConnection("yourConnectionString");
            string sqlcomd = string.Format("SELECT  email FROM  table WHERE  userid ='{0}'", "65");
            con.Open();
            SqlCommand cmd = new SqlCommand(sqlcomd, con);
            string emailId = string.Empty;
            try
            {
                emailId = Convert.ToString(cmd.ExecuteScalar());
            }
            finally
            {
                con.Close();
            }

Nick Reshetinsky · Answer 2 · 2011-05-11T11:55:00

Solution 1

don't ever try any SqlReader to extract just one value...
use this:

SqlCommand sqlcom = new SqlCommand(addquery, con);

 String emailad;
 emailad = (string)sqlcom.ExecuteScalar( );
SendMail(.., emailad, ..);

Check out your method SendMail espicially on your quotes around "emailad"
don't use quites

Posted 11-May-11 11:55am

Nick Reshetinsky

Updated 12-May-11 3:31am

v2