Datalist不会拖延结果 [英] Datalist not dislaying results

问题描述

Hai all，



我尝试使用以下代码在数据列表中显示结果。当用户登录时，我试图根据他的id拉取数据，但细节无法显示我的代码是



string connn = ConfigurationManager.ConnectionStrings [conn ] .ConnectionString;

SqlConnection con = new SqlConnection（connn）;

con.Open（）;

string str =select details ，地址来自tb_userdata内部联接tb_userlogin tb_userdata.uidfromtb1 = tb_userlogin.id;

SqlCommand cmd = new SqlCommand（str，con）;

SqlDataAdapter da = new SqlDataAdapter（ cmd）;

DataSet ds = new DataSet（）;

da.Fill（ds）;



任何人都可以告诉我这段代码有什么问题



谢谢和问候

Hai all,

i tried below code for displaying results in data list. when user login, i tried to pull the data according to his id,but the details can't displaying my code is

string connn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection con = new SqlConnection(connn);
con.Open();
string str = "select details,address from tb_userdata inner join tb_userlogin on tb_userdata.uidfromtb1=tb_userlogin.id";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

can any one tell me what is the problem with this code

Thanks and Regards

推荐答案

您的查询需要一个 WHERE 子句为你的userid过滤数据。



运行你的鳕鱼e在调试器中查看什么是和不工作。

Your query needs a WHERE clause for your "userid" to filter the data.

Run your code in the debugger and see what is and isn't working.

是的先生，我修改过这样的，之后我收到错误，如





将nvarchar值'haelzxpdrhkgwxpufxoughp4'转换为数据类型int时转换失败。











string id = System.Web.HttpContext.Current.Session.SessionID;



string connn = ConfigurationManager.ConnectionStrings [conn]。ConnectionString;

SqlConnection con = new SqlConnection（connn）;

con.Open（ ）;

string str =选择详细信息，来自tb_userdata.uidfromtb1 = tb_userlogin.id的tb_userdata内部联接tb_userlogin的地址，其中tb_userlogin.id = @ id;



SqlCommand cmd = new SqlCommand（str，con）;

cmd.Parameters.AddWithValu e（@ id，id）;

SqlDataAdapter da = new SqlDataAdapter（cmd）;

DataSet ds = new DataSet（）;

da.Fill（ds）;



谢谢和问候

yes sir,i modified like this,after this i got error like


Conversion failed when converting the nvarchar value 'haelzxpdrhkgwxpufxoughp4' to data type int.





string id = System.Web.HttpContext.Current.Session.SessionID;

string connn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection con = new SqlConnection(connn);
con.Open();
string str = "select details,address from tb_userdata inner join tb_userlogin on tb_userdata.uidfromtb1=tb_userlogin.id where tb_userlogin.id=@id";

SqlCommand cmd = new SqlCommand(str, con);
cmd.Parameters.AddWithValue("@id",id);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

Thanks and Regards

这篇关于Datalist不会拖延结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！