使用ado.net在页面加载期间无法从d/b读取数据 [英] not able to read data from d/b during pageload using ado.net

问题描述

我需要从两个不同表的行中读取数据，并需要在页面加载期间在标签控件中显示它们.
我已经给出了SQL DATASOURCE，但是它没有发生.

有人可以建议我到底是什么问题.我是ADO.NET的新手

下面是代码:

Hi,

I need to read data from row of two different tables and need to display them in label control during page load.
I have given the SQL DATASOURCE, but it''s not happening.

Can someone please suggest me what exactly the problem is. I am new to ADO.NET

Below is the code:

public void Page_Load(object sender, EventArgs e)
{
                SqlConnection con = new SqlConnection("my connectionstring name");
               SqlCommand cmd = new SqlCommand("SELECT username,u_fname,u_lname,u_password,u_email_id FROM users_detail", con);
                SqlCommand cmd1 = new SqlCommand("SELECT u_sec_qst,u_sec_ans FROM u_security", con);

                try
                {
                    con.Open();
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        mem_username.Text = reader.Read().ToString();
                        mem_fname.Text = reader.Read().ToString();
                        mem_lname.Text = reader.Read().ToString();
                        mem_pass.Text = reader.Read().ToString();
                        mem_email_id.Text = reader.Read().ToString();
                       
                       reader.Close();
                    }
                }

                catch (SqlException ex)
                {
                    string Label2 = "Sorry!! an Error Occured : " + ex.Message;
                }
                finally
                {
                    con.Close();
                }

                try
                {
                    con.Open();
                    SqlDataReader reader1 = cmd1.ExecuteReader();

                    mem_sec_qst.Text = reader1.Read().ToString();
                    mem_sec_ans.Text = reader1.Read().ToString();

                    reader1.Close();
                }
                catch (SqlException ex1)
                {
                    string Label2 = "Sorry!! an Error Occured : " + ex1.Message;
                }
                finally
                {
                    con.Close();
                }
}

在此先感谢...

Thanks in advance...

推荐答案

HI，

public void Page_Load(object sender, EventArgs e)
    {



        SqlConnection con = new SqlConnection("my connectionstring name");

        SqlCommand cmd = new SqlCommand("SELECT username,u_fname,u_lname,u_password,u_email_id FROM users_detail", con);
        SqlCommand cmd1 = new SqlCommand("SELECT u_sec_qst,u_sec_ans FROM u_security", con);
        con.Open();

        try
        {

            
            SqlDataReader reader = cmd.ExecuteReader();


            while (reader.Read())
            {
                mem_username.Text = reader.Read().ToString();
                mem_fname.Text = reader.Read().ToString();
                mem_lname.Text = reader.Read().ToString();
                mem_pass.Text = reader.Read().ToString();
                mem_email_id.Text = reader.Read().ToString();


              //  reader.Close();
            }
            reader.Close();
        }

        catch (SqlException ex)
        {

            string Label2 = "Sorry!! an Error Occured : " + ex.Message;
        }

        finally
        {
            cmd.Dispose();
          con.Close();
        }


        try
        {
         con.Open();
            SqlDataReader reader1 = cmd1.ExecuteReader();

            mem_sec_qst.Text = reader1.Read().ToString();
            mem_sec_ans.Text = reader1.Read().ToString();

            reader1.Close();


        }

        catch (SqlException ex1)
        {

            string Label2 = "Sorry!! an Error Occured : " + ex1.Message;

        }

        finally
        {

            con.Close();
            cmd1.Dispose();

        }

    }

最好的问候
米特瓦里(M.Mitwalli)

Best Regards
M.Mitwalli

这篇关于使用ado.net在页面加载期间无法从d/b读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！