ASP.NET

Re: GridView row dissappearing on SelectedIndexChanged

4-May-09 23:25

Right, it might help if I show the code!

<asp:GridView ID="gvIncidents" runat="server" AllowSorting="true" AutoGenerateColumns="false" onrowcommand="gvIncidents_RowCommand">
<HeaderStyle ForeColor="#606060"></HeaderStyle>
<Columns>
    <asp:BoundField DataField="FormID" HeaderText="" />
    <asp:BoundField DataField="FormType" HeaderText="Type" />
    <asp:BoundField DataField="FormDateTime" HeaderText="Date/Time" />
    <asp:BoundField DataField="Description" HeaderText="Description" />
    <asp:BoundField DataField="DateCreated" HeaderText="Date Created" />
    <asp:ButtonField CommandName="Import" Text="Import" ButtonType="Button" />
    <asp:ButtonField CommandName="Deny" Text="Delete" ButtonType="Button" />
</Columns>
</asp:GridView>

In my page load:

...
Me.gvIncidents.DataSource = dtIncidents
Me.gvIncidents.DataBind()
Me.gvIncidents.Visible = True
Me.gvIncidents.Columns(0).Visible = False
...

Handlers:

Protected Sub gvIncidents_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvIncidents.RowDataBound

    Try

        With e.Row
            If .RowType = DataControlRowType.DataRow Then

                .CssClass = "gridrow"

                'Change the cursor on mouseover
                .Cells(2).Attributes.Add("onMouseOver", "this.style.cursor='hand';")
                .Cells(2).Attributes.Add("onclick", ClientScript.GetPostBackEventReference(gvIncidents, "Select$" + .RowIndex.ToString()))

            Else 'Header
                .CssClass = "gridtitle"

            End If
        End With

    Catch ex As Exception
        Throw ex
    End Try

End Sub

Protected Sub gvIncidents_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles gvIncidents.SelectedIndexChanged
    Dim oGrid As GridView
    Dim oRow As GridViewRow

    Try
        oGrid = CType(sender, GridView)
        oRow = oGrid.SelectedRow

        PopulateIncidents() 'temporary hack to stop the rows from dissappearing

        ShowIncidentDetails(CType(oRow.Cells(0).Text, Integer))

    Catch ex As Exception

    End Try
End Sub

Christian Graus4-May-09 23:27

Re: GridView row dissappearing on SelectedIndexChanged [modified]

4-May-09 23:27

binarymax wrote:
Me.gvIncidents.Columns(0).Visible = False

And is it always the top line that disappears ? What if you remove this line ? Do you databind on every postback ? I remember you saying you did, you're saying this solves the issue, but when you have the issue, this code is entirely in an !IsPostback block ?

PopulateIncidents reloads the data ? What does ShowIncidentDetails do ? Have you tried commenting out sections of this code to work out which part is causing the issue ?

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

binarymax4-May-09 23:42

Re: GridView row dissappearing on SelectedIndexChanged

4-May-09 23:42

Good questions, the row that is dissappearing is the last row you selected. So if I select the 5th row, and then the 7th row, row 5 dissappears.

Right that page load is entirely in an !IsPostback block and it initially binds the data. PopulateIncidents is a function that re-binds the data. ShowIncidentDetails shows a panel with details about the row you selected, if I remove that the problem persists. Also I removed Me.gvIncidents.Columns(0).Visible = False from page load and still the same problem.

The part that is causing the problem is having the SelectedIndexChanged event. I can strip out all the code from
SelectedIndexChanged and the problem stays the same. If I remove the event entirely then the problem goes away, but I need the event in order to select the row, so I really can't remove it.

Thanks.

modified on Tuesday, May 5, 2009 5:57 AM

Herman<T>.Instance5-May-09 0:17

Herman<T>.Instance

5-May-09 0:17

Why you have the line
<asp:BoundField DataField="FormID" HeaderText="" />
in your ASP if your code behind removes the column.
Or skip it
Or you might want to add DataKeyNames
to this line:
<asp:GridView ID="gvIncidents" runat="server" AllowSorting="true" AutoGenerateColumns="false" onrowcommand="gvIncidents_RowCommand">

If you debug the SelectedIndexChanged event what is the value for oGrid.SelectedIndex? And is the oGrid.SelectedRow the row you selected?

In Word you can only store 2 bytes. That is why I use Writer.

Re: GridView row dissappearing on SelectedIndexChanged

binarymax5-May-09 0:35

Re: GridView row dissappearing on SelectedIndexChanged

5-May-09 0:35

Thanks for the reply, The FormID is bound because that is the PK that I don't want the user to see, but when the row is selected then I use FormID to lookup data so I can populate a panel with record details. Even when it is visible I still have the same problems. oGrid.SelectedIndex and SelectedRow are behaving as expected.

Herman<T>.Instance5-May-09 4:07

Herman<T>.Instance

5-May-09 4:07

that is why you can use the DataKeyNames to store your PK in. So not visiblle but accessible and no columns to hide. If you set the selectedIndex value, the property SelectedValue will contain the PK value.

ShowIncidentDetails(CType(oRow.Cells(0).Text, Integer))
isn't cells[0] now formtype in stead of formID?

In Word you can only store 2 bytes. That is why I use Writer.

Re: GridView row dissappearing on SelectedIndexChanged

binarymax5-May-09 5:52

5-May-09 5:52

I can use DataKeyNames which is nice to know but unfortunately it doesnt solve the problem Frown | :(

Also, even if I set visible=false on the first column the data is still bound as index 0 so cells[0] returns the formid as expected.

View State Problem

ybla824-May-09 22:28

4-May-09 22:28

Hi,
I've realized an APS.NEt application that used a SQLServer DB. It is just installed and it works fine.

The same application is installed on a Virtual Machine ( S.O. Windows Server 2003 + IIS 6.0 . Here, for each postback tha application crashes and says that it has failed to load view state.

I've tryed also to built the application on the VM with visual studio and then reinstalled the application but the problem persists.
The View State problem exists also in DebugMode on VisualStudio. All these problems only on Virtual machine. What could be the mistake?

Thanks in advance for eachone who will help me.

Christian Graus4-May-09 22:44

4-May-09 22:44

What is the precise error message ? Is it a security related message ? If the framework thinks that viewstate has been changed, a crash is the default behaviour, but this can be fixed by changing the web.config.

ybla824-May-09 22:49

4-May-09 22:49

The error is the class View State error:
"Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request."

You say that a possible solution is to change the web.config...how would you change it?

Christian Graus4-May-09 23:03

4-May-09 23:03

No, that's a different error to the one I was thinking of. Have you googled the exact error text ? That's the best way to find solutions to issues like this.

Are you adding controls dynamically ?

ybla824-May-09 23:11

4-May-09 23:11

Yeah, I've googled for two days.

In the application I add controls dynamically, but how I've wrote, the problem is only on the Virtual machine.
Instead, whene the application works in the intranet, there is not any problem.
So I don't think that the error is in the code, but rather in the system configuration (IIS, web.Config or other )

Christian Graus4-May-09 23:12

4-May-09 23:12

So you're using IIS on the intranet and it works ?

ybla824-May-09 23:30

Re: how to change tab event

4-May-09 23:30

yeah

how to change tab event

cspriya4-May-09 21:18

cspriya

4-May-09 21:18

Hi,

when i am in first tab, i click edit button in first tab then i go to second tab then i return back to the first tab means it should be in view mode. But instead of this it is in edit mode itself. how can i change from edit mode to view mode while tab click event.

Christian Graus4-May-09 21:54

insert multiple row using single form

4-May-09 21:54

Don't ask the same thing over and over. Answer is unchanged. When the tab change event occurs, you need to write code to leave edit mode.

prateekfgiet4-May-09 21:10

prateekfgiet

4-May-09 21:10

hi i m using asp.net c# and in backend sql server 2000
i have a web form i m able to save single row in table using asp web page,i want to save multiple row on single click in a single table,i m new in asp.net
pls help me
thanks in advance

Christian Graus4-May-09 21:13

4-May-09 21:13

prateekfgiet wrote:
,i m new in asp.net

Then your task is kind of insane. Start slower. Learn how to lay out an ASP.NET project before worrying about databases. If you're new, I assume you're not doing paid work, or school work. If you were being paid, that would be immoral, basically theft. If it was for school, your tasks would be laid out more logically and you'd have spoken to your teacher. So, if you're teaching yourself, start simpler and build up to this task.

prateekfgiet4-May-09 21:23

prateekfgiet

4-May-09 21:23

i am in job as a fresher and i have to complete this in any condition so pls help

Christian Graus4-May-09 21:53

4-May-09 21:53

OK, so you ARE being asked to steal from a client ? Shame on you, and the people who hired you.

However, people like you are the reason that outsourcing will die over time, and in the meantime, why the only clients it attracts, are idiots.

Nishant Singh4-May-09 23:44

Nishant Singh

4-May-09 23:44

Hi Prateek,
Create a XML string and use that XML string to insert values into table ,
(U have to do some googling to check building XML string and insert into DataBase table)

Alert on successful validation

Uma J5-May-09 0:03

Uma J

5-May-09 0:03

hey i have a solution!!!!!!!!
Just save the values in Temporary datatable and after that run that temporary datatable in a loop and write the insert in it.....

private void SaveGridDataInTempTable()
{
DataTable dtTemp = new DataTable();

if (dtTemp == null || dtTemp.Columns.Count <= 0)
{
dtTemp.Columns.Add("sino");
dtTemp.Columns.Add("name", typeof(String));
dtTemp.Columns.Add("gender", typeof(String));
dtTemp.Columns.Add("qualification", typeof(String));
dtTemp.PrimaryKey = new DataColumn[] { dtTemp.Columns["sino"] };
}

foreach (GridViewRow gvRow in GridView1.Rows)
{
DataRow drTemp = dtTemp.NewRow();
drTemp["sino"] = int.Parse(GridView1.DataKeys[gvRow.RowIndex]["sino"].ToString());
drTemp["name"] = ((TextBox)gvRow.FindControl("TextBox1")).Text.Trim();
drTemp["gender"] = ((RadioButtonList)gvRow.FindControl("RadioButtonList1")).SelectedValue.ToString();
drTemp["qualification"] = ((DropDownList)gvRow.FindControl("DropDownList1")).SelectedValue.ToString();

dtTemp.Rows.Add(drTemp);
}
Temp = dtTemp;
}

//Property to maintain the Datatable
public DataTable Temp
{
get
{
object o = ViewState["Temp"];
if (o == null)
{
DataTable dt = new DataTable();
return dt;
}
else
return (DataTable)o;
}
set
{
ViewState["Temp"] = value;
}
}

After this your normal insert code,

for(int i=0;i

Ramkithepower4-May-09 20:52

Ramkithepower

4-May-09 20:52

Hi ,

I am developing an application with a datagrid using which user can update the data in the datagrid row. Its all in ASP.Net c#.

on click of a button i should do the following.
Check if user has modified atleast one row.
1. If the user has not modified even one row, then i should display a messsage stating user to action atleast one row.--- I have done this check and works good.
2. If the user has changed atleast one row then i should display a alert asking for confirmation if they would like to proceed. If the user selects 'No' i should stop the execution. if he clicks Yes the execution should proceed. -- I need help on this .. I am not able to trigger it becuase the button is already clicked.

Please help me sort the point 2.

Re: Alert on successful validation

Christian Graus4-May-09 21:14