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

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

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'

fetching email address in a variable

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

fetching email address in a variable

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us