how to display data in text boxes of form using data grid view

Question

0.00/5 (No votes)

See more:

.NET3.5

i have created a form in which there are 4 labels teacher id ,teacher name and department and description along with respective textboxes.i have inserted the values in the database through ADD button (using insert query).I have taken datagrid view to display the data .The problem is now i want that one i select one row of datagridview then it should display in respective text boxes. i have tried following code but not able to get desired write properly.

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Integrated security =SSPI;Initial catalog=institute");
            con.Open();
            SqlCommand com = new SqlCommand("select * from teacher2", con);
            SqlDataReader dr = com.ExecuteReader();
            DataTable dt = new DataTable();

            dt.Load(dr);
            dr.Close();
            dataGridView1.DataSource = dt;

            if (dr.HasRows)

                dr.Read();
            txtteacherid.Text = dr[0].ToString();
            txtteachername.Text = dr[1].ToString();
            txtdepartment.Text = dr[2].ToString();
            txtdescription.Text = dr[3].ToString();
}

Please help
me
regards
shivani

Posted 29-Apr-11 0:54am

shivani 2013

Add a Solution

Comments

Ankit Rajput 2-May-11 1:02am

I think you forget to put where clause in your query.
Please check it once.

6 solutions

Solution 1

Use Array Concept It will Work.

ArrayList ar = new ArrayList();
ar.Add(Session[id]);
ar.Add(Session[ Name]);
ar.Add(Session[dept]);
ar.Add(Session[desc;]);

grd.DataSource = ar;
grd.DataBind();
txtName.Text = Convert.ToString(Session[Name]);

txtdesc.Text = Convert.ToString(Session[desc]);
txtdept.Text = Convert.ToString(Session[dept]);

Posted 29-Apr-11 1:06am

rakesh4657

Updated 1-May-11 18:09pm

v2

Comments

shivani 2013 29-Apr-11 7:46am

can you explain it briefly

shivani 2013 2-May-11 1:25am

where to write this code????????????

Solution 2

Hi,

I noticed that you are closing data reader before you read it. And there is no need to bind data to grid view again.

you can modify your code as below

SqlCommand com = new SqlCommand("select * from teacher2", con);
SqlDataReader dr = com.ExecuteReader();
 if (dr.HasRows)
{
while(dr.Read())
{
 txtteacherid.Text = dr[0].ToString();
 txtteachername.Text = dr[1].ToString();
 txtdepartment.Text = dr[2].ToString();
 txtdescription.Text = dr[3].ToString();
}
dr.Close();
}

Posted 29-Apr-11 1:13am

Rashmi_Karnam

Updated 29-Apr-11 10:49am

v3

Comments

shivani 2013 29-Apr-11 7:43am

thanx for ur effort but it always display data of last row in text boxes

RaviRanjanKr 29-Apr-11 16:49pm

Always Wrap your Code in "pre" tags :)

Solution 3

I think below code will work..:):)

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Integrated security =SSPI;Initial catalog=institute");
            con.Open();
            SqlCommand com = new SqlCommand("select * from teacher2", con);
            SqlDataReader dr = com.ExecuteReader();
            DataTable dt = new DataTable();
 
            dt.Load(dr);
            dr.Close();
            dataGridView1.DataSource = dt;
 
            if (dr.HasRows)
 {
                dr.Read();
            txtteacherid.Text = dr[0]["id"].ToString();
            txtteachername.Text = dr[0]["name"].ToString();
            txtdepartment.Text = dr[0]["dept"].ToString();
            txtdescription.Text = dr[0]["description"].ToString();
}
}

Posted 29-Apr-11 1:16am

Sujeet Pardeshi

Comments

shivani 2013 29-Apr-11 7:43am

no,its not working

Solution 5

u can use javascript for this

Its very easy

on page load write this

C#

foreach (GridViewRow row in GridView1.Rows)
{
               Button bk = (Button)row.FindControl(Button2);// Your Edit button
               bk.Attributes.Add(onclick,return getmew(+row.RowIndex+));
}

then in javascript write this

C#

function getmew(dd)
    {
     var b=document.getElementById(GridView1);
     var c=document.getElementById(TextBox1);
     var d=document.getElementById(TextBox2);
     dd=dd+1;
     c.value=document.getElementById(GridView1).rows[dd].cells[2].innerHTML;
     d.value=document.getElementById(GridView1).rows[dd].cells[3].innerHTML;
}

u can use rowdatabound also...do it in your way
good luck....

Posted 1-May-11 18:48pm

Ashishmau

Updated 1-May-11 18:49pm

v2

Comments

shivani 2013 2-May-11 1:26am

can u tell how to write javascript code......

Ankit Rajput 2-May-11 2:59am

Downvoting: Its a windows application. How to use javascript?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ankit Rajput · Accepted Answer · 2011-05-01T19:51:00

Solution 6

Hi,

Please add the Where Clause in your query with Key Column on which basis you want to fetch data.

[EDIT]

private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Integrated security =SSPI;Initial catalog=institute");
            con.Open();
            SqlCommand com = new SqlCommand("select * from teacher2", con);
            SqlDataReader dr = com.ExecuteReader();
            DataTable dt = new DataTable();
 
            dt.Load(dr);
            dataGridView1.DataSource = dt;
            dr.Close();
            con.Close();

}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Integrated security =SSPI;Initial catalog=institute");
            con.Open();
            SqlCommand com = new SqlCommand("select * from Media_Method where Media_method_ID ='" + dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() +"'", con);
            SqlDataReader dr = com.ExecuteReader();
            if (dr.HasRows)
            {
                dr.Read();
                txtteacherid.Text = dr[0].ToString();
                txtteachername.Text = dr[1].ToString();
                txtdepartment.Text = dr[2].ToString();
                txtdescription.Text = dr[3].ToString();
            }
            dr.Close();   
            con.Close();         
}

You can directly fetch the data from gridview as well no need to go to database for filling the textboxes every time.

Change your code like this and then try whether your goal achieved or not?
I think now you can understand what I want to say?

regards
AR

Posted 1-May-11 19:51pm

Ankit Rajput

Updated 1-May-11 23:29pm

v6

Comments

shivani 2013 2-May-11 2:14am

can u explain in detail

Ankit Rajput 2-May-11 2:20am

What to explain in it?
"select * from teacher2" its your query. It will select all the data from your table. If you need to pick specific data then you need provide some condition. Like
"select * from teacher2 Where teacherID=1".

shivani 2013 2-May-11 3:05am

the coding which have given me nw.i have alredy dne this.........my question is wat to write in this ??????? in following code
select * from teacher2 Where teacherID=????"
as i am selecting a particular row of dat grid view

shivani 2013 2-May-11 2:34am

i want is on loading form whole data should get displayed in data grid view and i am getting this..............but wen i click one particular row of dat grid view then i should get data for respective selected row in respective text boxes......nw wat coding should i give
m mean select * from teacher where teacher_id=???????????as i m selecting particular row from dat grid view.......

Ankit Rajput 2-May-11 2:50am

First Let me know whether its a Windows Application or Web Application?
If its a Windows Application, Then load all the data for Form Load event.

Do coding for specific value in this event.

shivani 2013 2-May-11 2:54am

its window application using C#.NET and SQL SERVER 2008

Ankit Rajput 2-May-11 2:56am

I have updated my answer. Please check it.
And please use Reply option if you replying for any comment.

shivani 2013 2-May-11 3:05am

the coding which have given me nw.i have alredy dne this.........my question is wat to write in this ??????? in following code
select * from teacher2 Where teacherID=????"
as i am selecting a particular row of dat grid view

Ankit Rajput 2-May-11 3:09am

Write this in Place of ??????

dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()

shivani 2013 2-May-11 3:30am

i am getting following error
incorrect syntax near e.RowIndex

Ankit Rajput 2-May-11 3:34am

show your code. We can not provide you help on Syntax errors without code.

Ankit Rajput 2-May-11 4:22am

Show us the code. Where are you getting Syntax Error?

shivani 2013 2-May-11 5:17am

just wait i""l provide u

shivani 2013 2-May-11 5:22am

on loading form
private void Media_Method_of_Publicity_Load(object sender, EventArgs e)
{

SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Integrated security =SSPI;Initial catalog=PSM");
con.Open();
SqlCommand com = new SqlCommand("select * from Media_Method", con);
SqlDataReader dr = com.ExecuteReader();
DataTable dt = new DataTable();

dt.Load(dr);

dataGridView1.DataSource = dt;
dr.Close();
con.Close();

}
on clicking particular row of data grid view
SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Initial Catalog=PSM;Integrated Security=True");
con.Open();
//SqlCommand com = new SqlCommand("select * from Media_Method", con);
SqlCommand com = new SqlCommand("select * from Media_Method where Media_method_ID =dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()", con);
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{

txtmediaid.Text = dr[0].ToString();
txtmedianame.Text = dr[1].ToString();
txtaudience.Text = dr[2].ToString();

}
dr.Close();
con.Close();
and here Media_method_ID is field name of SQL
and when i run the application every the error shown is
incorrect syntax near e.RowIndex

Ankit Rajput 2-May-11 5:28am

I am updating my Answer Please check it.

Ankit Rajput 2-May-11 5:30am

Now I have updated the query in my Answer.
Please check and revert

shivani 2013 2-May-11 6:14am

thanks i got it.really thank you very very very very much

Ankit Rajput 2-May-11 6:21am

You are most welcome.

Ankit Rajput 2-May-11 6:26am

do not forget to accept the answer.

shivani 2013 2-May-11 6:28am

yes sir i wont

Tarun.K.S 2-May-11 3:21am

Good catch, 5+. But I think dr.Read() should be used in a while loop, though I think there is only one record to display.

Ankit Rajput 2-May-11 3:26am

No need to Use While here because we need to show a row into textboxes. We do not need to iterate.
By the way, Thanks

Tarun.K.S 2-May-11 3:32am

Ohkay, got it. Thanks.

Tarun.K.S · Accepted Answer · 2011-05-01T21:17:00

Simple writing dr.Read() won't help you in reading the values from the Database.
You have to loop through each record using a while statement. Also you are closing the dr before doing the below operation, which is wrong.

Use Ankit's SqlCommand query too.

C#

if (dr.HasRows)
           {
            while(dr.Read())
            {
             txtteacherid.Text = dr[0].ToString();
             txtteachername.Text = dr[1].ToString();
             txtdepartment.Text = dr[2].ToString();
             txtdescription.Text = dr[3].ToString();
            }
           }
           dr.Close();

how to display data in text boxes of form using data grid view

6 solutions

Solution 6

Solution 1

Solution 2

Solution 3

Solution 7

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us