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
Rahul Goyal
NA
57
64k
Retrive a data from database and show in text boes and gridview
Nov 15 2010 3:58 AM
hiiii
i am new in asp.net. I make a one project in which we use textboxes and gridview to save the data in database.....
now i place a one search text box and a button on that page through which i enter the data into the database...
now i want that when i fill the email id of any person in search text box and click on the search button, then all data regarding that email id show me on that page from where i enter the data in to the data base(means the textboxes data show me in textboxes and the gridview data show me in gridview. NOte that i have only one form).
I try to do it but no result come....
so plzzzz help me!!!!!!!!!!!!!
my code shown below:
protected void Button4_Click(object sender, EventArgs e)
{
SqlConnection con3 = new SqlConnection();
con3.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
{
con3.Open();
}
DataTable dt=new DataTable();
SqlCommand cmd3 = new SqlCommand("select * from Pinfo where id=@E_mail", con3);
SqlDataAdapter da = new SqlDataAdapter(cmd3);
cmd3.Parameters.AddWithValue("@E_mail", User);
da.Fill(dt);
if(dt.Rows.Count>0)
{
TextBox1.Text = dt.Rows[0]["Job_applied"].ToString();
TextBox2.Text = dt.Rows[0]["Name"].ToString();
TextBox3.Text = dt.Rows[0]["Date_brith"].ToString();
RadioButtonList1.Text = dt.Rows[0]["Sex"].ToString();
TextBox4.Text = dt.Rows[0]["Present_add"].ToString();
TextBox5.Text = dt.Rows[0]["permanent_add"].ToString();
TextBox6.Text = dt.Rows[0]["Contact_no"].ToString();
TextBox7.Text = dt.Rows[0]["Mobile_no"].ToString();
TextBox8.Text = dt.Rows[0]["E_mail"].ToString();
RadioButtonList2.Text = dt.Rows[0]["Marital_st"].ToString();
RadioButtonList3.Text = dt.Rows[0]["Agreement"].ToString();
TextBox20.Text = dt.Rows[0]["Min_salary"].ToString();
}
con3.Close();
cmd3.ExecuteNonQuery();
cmd3.Dispose();
}
Reply
Answers (
4
)
Mouse event in c# winforms application
how to cache Images