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 z Hané