我只有第一员工的详细信息. [英] only First Employee details i got it.

问题描述

当我运行我的程序时.我只有第一位员工的详细信息.我选择第二个雇员而不是第二个雇员.只有第一位员工的详细信息会被检索.

如何在我的Web表单中获取选定的员工详细信息.

when i am run my program. only first employee details is i got it. i am select second employee not retrive the second employee. only first employee details is retrive it.

how i am got selected employee details in my web form.

protected void Page_Load(object sender, EventArgs e)
    {
        string connection = System.Configuration.ConfigurationManager.ConnectionStrings["aaa2"].ConnectionString;
        SqlConnection con = new SqlConnection(connection);
        con.Open();
        SqlCommand cmd = new SqlCommand("Select td_em_id from pa_tds_int_entry", con);
        SqlDataReader dr = cmd.ExecuteReader();
        ddlId.DataSource = dr;
        ddlId.DataTextField = "td_em_id";
        ddlId.DataBind();
        
    }

推荐答案

引用此链接

http://msdn.microsoft.com/en-us/library/haa3afyz (v = vs.71).aspx [

Refer This Link

http://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.71).aspx[^]

Accept This Answer If It Has Helped You.

您好，

您可以根据自己的样品进行此操作

Hi,

You can do this based on your sample

string connection = System.Configuration.ConfigurationManager.ConnectionStrings["aaa2"].ConnectionString;
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("Select td_em_id from pa_tds_int_entry WHERE td_em_id = '" + ddlId.SelectedValue + "' ", con);
SqlDataReader dr = cmd.ExecuteReader();
ddlId.DataSource = dr;
ddlId.DataTextField = "td_em_id";
ddlId.DataBind();

希望这一点对您有所帮助.

I hope this one can help.

为DataReader对象使用while循环，
例如.

use while loop for DataReader object,
eg.

while(dr.Read())
{
foreach(int k in dr)
   {
          Console.WriteLine(dr[k]);
   }
}

您将得到输出...祝您好运..

you will get your output...good luck..

这篇关于我只有第一员工的详细信息.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！