SQL query output not viewing on textbox

Question

My output on SQL query is not viewing on my textbox, when the form load it must be automatically inserted to my textbox. The only output on my textbox is System.Data.SqlClient.SqlCommand

I don't know whats wrong or missing on my codes. Please help me, sorry I'm just a newbie on c#

Any type of response is greatly appreciated. Thank you in advance.

private void EmailGen_Load(object sender, EventArgs e)
{
    connect.Open();
    string emailto = "select emailaddress from emails where password = ''";
    string emailfr = "select emailaddress from emails where password != null";
    SqlCommand emailt = new SqlCommand(emailto, connect);
    SqlCommand emailf = new SqlCommand(emailfr, connect);
    emailt.ExecuteNonQuery();

    txBEmailRec.Text = emailt.ToString();
    txBEmailFr.Text = emailf.ToString(); ;
    connect.Close();

    // TODO: This line of code loads data into the 'kwemDataSet.tblProducts' table. You can move, or remove it, as needed.
    this.tblProductsTableAdapter.Fill(this.kwemDataSet.tblProducts);
}

You should use `ExecuteScalar();` instead of `ExecuteNonQuery();` And also, you code seems to missing to execute `emailf` SqlCommand. — Balagurunathan Marimuthu, Jul 27 '17 at 10:23

score 1 · Accepted Answer · answered Jul 27 '17 at 10:24

1

You should use ExecuteScalar(); instead of ExecuteNonQuery(); And also, you code seems to missing to execute emailf SqlCommand.

You could see this reference as well.

private void EmailGen_Load(object sender, EventArgs e)
{
    connect.Open();
    string emailto = "select emailaddress from emails where password = ''";
    string emailfr = "select emailaddress from emails where password != null";
    SqlCommand emailt = new SqlCommand(emailto, connect);
    SqlCommand emailf = new SqlCommand(emailfr, connect);

    txBEmailRec.Text = emailt.ExecuteScalar().ToString();
    txBEmailFr.Text = emailf.ExecuteScalar().ToString();
    connect.Close();

    // TODO: This line of code loads data into the 'kwemDataSet.tblProducts' table. You can move, or remove it, as needed.
    this.tblProductsTableAdapter.Fill(this.kwemDataSet.tblProducts);
}

answered Jul 27 '17 at 10:24

Balagurunathan Marimuthu

2,927
4
31
44

Thank you so much **Balagurunathan Marimuthu** it works. Thank you very much for your help. – vicserna1997 Jul 27 '17 at 10:30
@vicserna1997 Glad it helped. please mark this answer as helpful and if you can up vote as well. :) – Balagurunathan Marimuthu Jul 27 '17 at 10:31
I will :) I also have another problem – vicserna1997 Jul 27 '17 at 10:32
@vicserna1997 Please post that as another question and Comment your new question over here. I will try to answer it. – Balagurunathan Marimuthu Jul 27 '17 at 10:33
Thank you but I have to wait 90 minutes for another question **Balagurunathan Marimuthu** – vicserna1997 Jul 27 '17 at 10:42
@vicserna1997 You are welcome and No problem. Paste your new question link here once you post it. So, that I can answer your question if I can. :) – Balagurunathan Marimuthu Jul 27 '17 at 10:43
Thank you very much for your help **Balagurunathan Marimuthu** – vicserna1997 Jul 27 '17 at 10:45
You can post your problem if it can able to describe it here. – Balagurunathan Marimuthu Jul 27 '17 at 10:46

SQL query output not viewing on textbox

1 Answers1