password or username incorrect or access level

Thanks scottgp it works.:)

Thanks Mycroft Holmes; Groupby gives me no count of student in any city WITH r1 AS (SELECT CAPITALISE_SEMESTRE_1.NUM_INSCRIPTION, CAPITALISE_SEMESTRE_1.CODE_SEMESTRE , CAPITALISE_SEMESTRE_1.CODE_TYPE_RELATION_SEMESTRE ,CAPITALISE_SEMESTRE_1.ann_uni FROM CAPITALISE\_SEMESTRE AS CAPITALISE\_SEMESTRE\_1 WHERE (CAPITALISE\_SEMESTRE\_1.CODE\_TYPE\_RELATION\_SEMESTRE = 4) AND (CAPITALISE\_SEMESTRE\_1.CODE\_SEMESTRE = 2)), r2 AS (SELECT CAPITALISE_SEMESTRE.NUM_INSCRIPTION AS Expr1, CAPITALISE_SEMESTRE.CODE_SEMESTRE AS Expr2, CAPITALISE_SEMESTRE.ann_uni AS Expr4 FROM CAPITALISE_SEMESTRE AS CAPITALISE_SEMESTRE WHERE (CAPITALISE\_SEMESTRE.ann\_uni = '2008/2009') AND (CAPITALISE\_SEMESTRE.CODE\_SEMESTRE = 1)) SELECT r1\_1.NUM\_INSCRIPTION FROM r1 AS r1\_1 INNER JOIN r2 AS r2\_1 ON r1\_1.NUM\_INSCRIPTION = r2\_1.Expr1

No problem. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

Hi, when you are projecting data to gridview ,pass the column id also (ex:if you projecting user info to gridview,then you can pass the user id also as invisble to end user) and by using that id at the runtime you can update the particular row...

Thank you Greg Chelstowski; I tried your code and there: protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = GridView1.Rows[GridView1.SelectedIndex]; string strValCell = row.Cells[2].Text; } //and public void GridView1_SelectedIndexChanged(Object sender, EventArgs e) { TextBox1.Text = GridView1.SelectedRow.Cells\[2\].Text; } but it doesn't work " any result" and if i do public void GridView2_SelectedIndexChanged(Object sender, EventArgs e) { TextBox tb = GridView1.SelectedRow.FindControl("id0") as TextBox; if (tb != null) TextBox1.Text = tb.Text; else TextBox1.Text = "no data"; } I have always "no data"

Thank you Satish Mahapatra and Greg Chelstowski. I tried your solution but it does not work:( I want to have: the value of a cell of selected line in a GridView. I read that i can do that :TextBox1.Text = GridView2.SelectedRow.Cells[1].Text; but it doesn't work.

Thank you Satish Mahapatra it works I forgot a field in my stored procedure.

You're welcome :) The need to optimize rises from a bad design.My articles[^]

Thanks Ashfield!merci beaucoup i have anouther problem with this code ,I posted a new message. Thanks :)

Your query was very close. Just don't group by on years column: SELECT id_student, COUNT(*) as years FROM T1 WHERE (id_MODULE=11 ) AND (id_validat= 2) GROUP BY id_student HAVING (COUNT(*) = 2) The need to optimize rises from a bad design.My articles[^]

HI!! if my table history will be as my table source so my table history is: (id_student, id_module, id_validat_module, note) or informations about students are in student table. if I want to select students in their history with name_etudiants I have to link the history table to student table? Thanks

foryou wrote: Thank you very much You're welcome :) foryou wrote: they say "De rien". I had a feeling it was wrong. Thanks for correcting! It's been over 20 years I studied french and never used it after that so I guess I have forgotten about everything :) The need to optimize rises from a bad design.My articles[^]

Merci Christian Graus c'est gentil.

You are welcome. :) I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

You should be asking this in the SQL Forum. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Without seeing the query you have already built, answering the question is quite difficult, so what's your query like? The need to optimize rises from a bad design. My articles[^]