ASP.NET PageIndexChanging Event

Question

Sir I am in PageIndexChanging Event in asp.net. I am using this within a Multiview State. Here is the view1 Page:- And the View2 Page:- The task in which i need your help is PageIndexChanging Event. you can see the link button Select in the gridview. when I select one row I need to go to the view1 page. I did the coding for this function. My task is when I click the movieName Hollowman I want to display data in the concerned fields.

Sanjeeb Lenka · Answer

i modified your aspx and code just check that: in grid design write this code: BorderStyle=Solid DataKeyNames=movieId OnRowCommand=dgvMovie_RowCommand AutoGenerateColumns=false> '> '> '> '> ' CommandName=Select runat=server>Select ' CommandName=Delete>Delete VerticalAlign=Middle /> in .cs write this code in rowcommand: protected void dgvMovie_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName == Select) { int id = Convert.ToInt32(e.CommandArgument); if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlDataAdapter sqlDa = new SqlDataAdapter(select * from tbl_Movie where movieid='+id+' sqlCon); DataSet sqlDS = new DataSet(); sqlDa.Fill(sqlDS); txtMovieName.Text = sqlDS.Tables[0].Rows[0][movieName].ToString(); cmbLanguage.SelectedValue = sqlDS.Tables[0].Rows[0][Languge].ToString(); cmbGenre.SelectedValue = sqlDS.Tables[0].Rows[0][Genre].ToString(); cmbYear.SelectedValue = sqlDS.Tables[0].Rows[0][movieYear].ToString(); } }

Sanjeeb Lenka · Answer

hi check this code: in aspx grid: BorderStyle=Solid DataKeyNames=movieId OnRowCommand=dgvMovie_RowCommand AutoGenerateColumns=false OnRowDeleting=dgvMovie_RowDeleting > in .cs: protected void dgvMovie_RowDeleting(object sender GridViewDeleteEventArgs e) { int id = Convert.ToInt32(dgvMovie.DataKeys[e.RowIndex].Value); if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand cmd = new SqlCommand(Delete from tbl_Movie where movieid=' + id + ' sqlCon); cmd.ExecuteNonQuery(); sqlCon.Close(); GridFill(); }

Iftikar Hussain · Answer

yes. this is correct way to display the link text Regards Iftikar

Bineesh VP · Answer

Thank You Sanjeeb for helping mt to find output. Now I want the RowDeleting event in this same program. Could you send me the code?

Sanjeeb Lenka · Answer

look this make the autogeneratedcolumn to false. BorderStyle=Solid DataKeyNames=movieId OnRowCommand=dgvMovie_RowCommand AutoGenerateColumns=false >

Bineesh VP · Answer

The code is working. But the Result is Doubled gridView. Here is how it look like. Please rectify this malfunction.

Iftikar Hussain · Answer

not able to find your page where you added the grid for the below screen shot

Bineesh VP · Answer

Here is the complete code(with database) Extract ZIP file and go through all codes. and try to find the solution.

Sanjeeb Lenka · Answer

is it possible to attach the form here....

Iftikar Hussain · Answer

share the code for the first page. Have you used redirect or not?

Bineesh VP · Answer

Sir The function is still very far As I want to function the selectedIndexChanging Event. The form would be look like when I press the link button:- give me a solution for this.

Sanjeeb Lenka · Answer

hi bineesh So you given your screen shot its good . but if you share your code then only we can understand what you written and what to do.

Bineesh VP · Answer

Sir the code is created a link button. now my form look like:- now how can i go to view1 and display correspondent data in the fields?

Iftikar Hussain · Answer

Hi Please refer the below link http://hightechnology.in/how-to-redirect-to-another-page-by-click-on-linkbutton-in-gridview/ Regards Iftikar

Sanjeeb Lenka · Answer

plz share your Aspx and .cs code so we can able to solve your problem