我的数据列表没有显示任何结果 [英] My data list is not showing any results

问题描述

Hai所有我试过下面的代码，在这里我有这个问题



1.我的datalist没有加载，因为它没有显示任何结果，wen我正在调试它加载null。





我的代码是







string id = Session [" id"]。ToString（）;

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

SqlConnection con = new SqlConnection（connn）;

con.Open（）;

string str =" select详细信息，其他来自tb_userdata内部联接tb_userlogin tb_userdata.uidfromtb1 = tb_userlogin.id其中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）;



和aspx页面是





< asp：DataList runat =" server" ID =" ds">

< ItemTemplate>

< a href ='<％＃Eval（" detials"）％>'> ;< / a>

< a href ='<％＃Eval（" others"）％>'>< / a>



< / ItemTemplate>





< / asp：DataList>



任何人都可以帮助我



谢谢和问候

Hai all i tried below code,in this i have this problem

1. my datalist is not loading that is it doesn't show any results ,wen i'm debugging it loads null.


my code is



string id = Session["id"].ToString();
string connn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection con = new SqlConnection(connn);
con.Open();
string str = "select details,others 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);

and aspx page is


<asp:DataList runat="server" ID="ds">
<ItemTemplate>
<a href='<%# Eval("detials") %>'></a>
<a href='<%# Eval("others") %>'></a>

</ItemTemplate>


</asp:DataList>

can any one help me

Thanks and Regards

推荐答案

你使用SqlDataAdapter完全不同的东西。 SqlDataAdapter用于表映射。如果我理解得很好，你想从数据库中选择数据并将其存储到数据集中，我是对的吗？首先，我不知道，Data List是什么，但我认为DataSet也许。使用SqlDataReader从db中进行选择，如果选择一个表，则不能使用DataSet，而是使用DataTable。



因此请使用以下代码：

You use SqlDataAdapter for quite different thing. SqlDataAdapter is used for tablemapping. If I have understood well you want to select data from db and store it into a dataset, am I right? First, I don't know, what Data List is, but I thought DataSet perhaps. Use SqlDataReader for selecting from db and if you select one table, you can't use DataSet, but DataTable.

So use this code:

string id = Session["id"].ToString();
string connn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection con = new SqlConnection(connn);
con.Open();
string str = "select details,others 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);
SqlDataReader reader = new SqlDataReader(cmd, con);
DataTable table = new DataTable("UserData");
table.Columns.Add(new DataColumn("details", typeof(string)));
table.Columns.Add(new DataColumn("others", typeof(string)));
while (reader.Read)
{
   DataRow row = table.NewRow();
   row[0] = (String) reader.GetString(0);
   row[1] = (String) reader.GetString(1);
}
return table;

Pepin zHané

Pepin z Hané

我认为你应该检查连接字符串

，因为你声明连接字符串为connn



并打开con连接字符串连接

I think you should check connection string
because you declared connection string as connn

and open connection for con connection string

这篇关于我的数据列表没有显示任何结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！