TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Abhimanyu Singh
NA
116
49k
How can fetch/differentiate experienced from same table....
May 27 2013 1:54 AM
Hello All,
As i am new in this field so i need some help from you all..Please!!
Actually i am working on one old project that have 3-registration page as it has older flow of itself but now i have to differentiate it i mean have to fetch the separate model list as per their experianced/fresher...on radiobutton selected event of searching page so that models can see easly their profile...problem is that if i am creating seperate table for both it will be complex and will take more pages...So i created one more column "experienced" and inserted the radiobutton selected value in it.
Now insertion is ok but i need to display it on basis of their categories...on radiobutton selection(Searching option: 1) Fresher & 2) Experienced ).
.CS code of 3rd registration page is:
con.Open();
SqlCommand
cmd =
new
SqlCommand
(
"update Models set Experience_details = '"
+
RadioButtonList1.SelectedItem.Text
+
"', profile_image = '"
+ Label4.Text +
"' where Model_name = '"
+ Session[
"selected"
].ToString() +
"'"
, con);
SqlDataReader
dr = cmd.ExecuteReader();
con.Close();
.CS code For Searching
:(
This is
older one
but i want as i mentioned in query
)
protected
void
Page_Load(
object
sender,
EventArgs
e)
{
if
(Session[
"to"
] !=
null
)
{
if
(!IsPostBack)
{
con.Open();
SqlDataAdapter
da1 =
new
SqlDataAdapter
(
"select * from Models where (Gender='"
+ Session[
"gender"
].ToString() +
"' and approval='Accept') and Age between '"
+ Session[
"to"
].ToString() +
"' AND '"
+ Session[
"from"
].ToString() +
"' "
, con);
DataSet
ds1 =
new
DataSet
();
da1.Fill(ds1);
DataTable
dt1 = ds1.Tables[0];
DataList2.DataSource = dt1;
DataList2.DataBind();
con.Close();
}
}
else
{
if
(!IsPostBack)
{
con.Open();
SqlDataAdapter
da1 =
new
SqlDataAdapter
(
"select * from Models where approval = 'Accept'"
, con);
DataSet
ds1 =
new
DataSet
();
da1.Fill(ds1);
DataTable
dt1 = ds1.Tables[0];
DataList2.DataSource = dt1;
DataList2.DataBind();
con.Close();
}
}
}
Any body can help me to fetch it as per their categories
Reply
Answers (
2
)
Font Size via C#
how to get the value from gridview into input box?