join 2 tables bind in dropdown in asp.net

Guest User

hi Experts,

my scenario is i have two different tables and i want bind in dropdown according to user Id....

Security Question1	"ddlQuestion" runat="server" AppendDataBoundItems="true"> "TxtAnswer" runat="server">
"btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" />
"lblerror" runat="server">

I am using this scenario but didn't show any data in frontend...and when I give static UserId == 1..it's showing...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
where c.UserId == Id has no meaning unless you have stored some value in id

it should be
private void bindSecQue(int userId)
{
using (schoolEntities6 context = new schoolEntities6())
{
List newlist = (from c in context.SecurityQuestionDetails
join sq in context.SecurityQuestions on c.SecQueId equals sq.Id
where c.UserId == userId
select new SecurityModel
{
Id = c.Id,
SecQue = sq.SecQue,
SecQue2 = sq.SecQue2,
SecQueId = c.SecQueId
}).ToList();
ddlQuestion.DataTextField = "SecQue";
ddlQuestion.DataValueField = "SecQueId";
ddlQuestion.DataBind();
ddlQuestion.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select"));
}
}

in pageLoad
if(!IsPostBack)
{
  // ask user for his id or get currently logged in user's id
int id=Convert.Toint32(txtUxer.text);
bindSecQue(id)
}
Kiran Mohanty5y ago
Please check the value of "Id" variable. Either is't null or a valid number but you dont have any matching userId record is databse.