Programmatical Parameters w/MultiRowEdit on DataGrid

[Derek]

I have an aspx page where I use a reversebind and
templates to edit the entire datagrid at one time. I
added a textbox and button to change the parameter
criteria and then rerun the databind2 procedure. That
works fine the data is requeried and the new results are
displayed in the datagrid and the reversebind works for
saving the information. However if I add another text
box or dropdown box it does not seem to requery
correctly. If I remove the reversebind it will, but
without the reversebind I can not save changes to the
datagrid as a whole. I think I understand why using the
ddcp.selectedin dex change sub will not work because it is
posting back however I can not figure out why adding an
additional text box for input and placing that within the
button1 command is not. I have looked at the stored
procedure also. I need to be able to either look at all
or a particular type of cp. I would prefer to use a drop
down box either inside or out of the button1 command.
Any help would appreciated. Thanks in advance

Here is both the code for page and stored_proc. page
also draws really slow:

Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArg s) Handles MyBase.Load

If Not IsPostBack Then

datcurrent = Date.Now.ToShor tDateString

lblselectedcald t.Text = DateAdd
(DateInterval.D ay, 1, datcurrent)

squad = Request.QuerySt ring("usersquad ")

lblusersquad.Te xt = squad

lblselectedCP.T ext = ddcp.SelectedVa lue

BindData2()

lbltoday.Text = datcurrent

txtdaysout.Text = ""

Else

ReverseBind()

End If

End Sub

Sub BindData2()

Dim cp As String

'cp = "c"

'If ddcp.SelectedIn dex > -1 Then

cp = lblselectedCP.T ext

'ElseIf ddcp.SelectedIn dex = -1 Then

' cp = "%"

'End If

'If lblselectedCP.T ext = "" Then

'cp = "%"

'Else

' cp = lblselectedCP.T ext

'End If

sdate = CType(lblselect edcaldt.Text, DateTime)

If lbl4days.Text = "" Then

daysout = 36

Else

daysout = CType(lbl4days. Text, Integer)

End If

'squad = lblusersquad.Te xt

SqlSelectComman d1.Parameters(" @sdate").Value =
sdate

SqlSelectComman d1.Parameters(" @time").Value =
daysout

SqlSelectComman d1.Parameters(" @squad").Value =
lblusersquad.Te xt

If lblselectedCP.T ext = "All" Then

SqlSelectComman d1.Parameters(" @cp").Value
= "%"

Else

SqlSelectComman d1.Parameters(" @cp").Value =
lblselectedCP.T ext

End If

'SqlConnection1 .Open()

SqlDataAdapter2 .Fill(DsCrewNot ify1)

DataGrid2.DataB ind()

_LastEditedPage = DataGrid2.Curre ntPageIndex

'SqlConnection1 .Close()



End Sub

Public Sub ReverseBind()

Dim gridrow As DataGridItem

Dim datarow As dsCrewNotify.og _getCrewNotifyR ow

For Each gridrow In DataGrid2.Items

datarow = DsCrewNotify1.o g_getCrewNotify
(gridrow.DataSe tIndex)

datarow.notifie d() = CType(gridrow.F indControl
("chkNotify" ), CheckBox).Check ed

DsCrewNotify1.o g_getCrewNotify
(gridrow.DataSe tIndex).ItemArr ay = datarow.ItemArr ay

Next

End Sub

Protected Overrides Sub LoadViewState(B yVal
savedstate As Object)

MyBase.LoadView State(savedstat e)

If (Not Me.ViewState("D ata") Is Nothing) Then

DsCrewNotify1 = CType(Me.ViewSt ate("Data"),
dsCrewNotify)

End If

If (Not Me.ViewState("L astEditedPage") Is
Nothing) Then

_LastEditedPage = CType(Me.ViewSt ate
("LastEditedPag e"), Integer)

End If

End Sub

Protected Overrides Function saveViewState() As Object

Me.ViewState("D ata") = DsCrewNotify1

Me.ViewState("L astEditedPage") = _LastEditedPage

Return (MyBase.SaveVie wState())

End Function

Private Sub DataGrid1_ItemD ataBound(ByVal sender As
Object, ByVal e As
System.Web.UI.W ebControls.Data GridItemEventAr gs) Handles
DataGrid2.ItemD ataBound

If (e.Item.ItemTyp e = ListItemType.It em Or
e.Item.ItemType = ListItemType.Al ternatingItem) Then

Dim datarow As
dsCrewNotify.og _getCrewNotifyR ow

datarow = CType(CType(e.I tem.DataItem,
DataRowView).Ro w, dsCrewNotify.og _getCrewNotifyR ow)

CType(e.Item.Fi ndControl("chkN otify"),
CheckBox).Check ed = datarow.notifie d

End If

End Sub

Sub updateData()

Dim gridrow As DataGridItem

Dim datarow As dsCrewNotify.og _getCrewNotifyR ow

Dim dscrewnotify As DataSet

Dim chkbox As CheckBox

Dim strnotify As String

Dim intid As Integer

For Each gridrow In DataGrid2.Items

datarow = DsCrewNotify1.o g_getCrewNotify
(gridrow.DataSe tIndex)

intid = datarow.Item(0)

datarow.notifie d() = CType(gridrow.F indControl
("chknotify" ), CheckBox).Check ed

DsCrewNotify1.o g_getCrewNotify
(gridrow.DataSe tIndex).ItemArr ay = datarow.ItemArr ay

strnotify = CType(gridrow.F indControl
("chkNotify" ), CheckBox).Check ed

SqlUpdateComman d1.Parameters(" @notify").Value
= strnotify

SqlUpdateComman d1.Parameters
("@schedid").Va lue = intid

SqlConnection1. Open()

SqlUpdateComman d1.ExecuteNonQu ery()

SqlConnection1. Close()

Next

'BindData2()

ReverseBind()

End Sub

Sub doUpdate(ByVal sender As Object, ByVal e As
DataGridCommand EventArgs)

If e.CommandName = "Update" Then

DataGrid2.Allow Paging = False

' DataGrid2.Allow Sorting = True

DataGrid2.DataS ource =
DsCrewNotify1.o g_getCrewNotify

ReverseBind()

updateData()

End If

End Sub

Private Sub Button1_Click(B yVal sender As
System.Object, ByVal e As System.EventArg s) Handles
Button1.Click

Dim numhours As Integer

If txtdaysout.Text = "" Then

numhours = 36

Else

numhours = (CType(txtdayso ut.Text, Integer) *
24) + 12

End If

' numhours = (CType(txtdayso ut.Text, Integer) *
24) + 12

lbl4days.Text = numhours

BindData2()

End Sub



Sub ddcp_SelectedIn dexChanged(ByVa l sender As Object,
ByVal e As System.EventArg s) Handles
ddcp.SelectedIn dexChanged

If ddcp.SelectedIn dex > -1 Then

lblselectedCP.T ext = ddcp.SelectedVa lue

BindData2()

End If

End Sub

End Class



Stored Proc::

CREATE PROCEDURE *********

@sdate as datetime

, @time as int

, @squad as nvarchar(10)

, @cp as nvarchar(10)



AS

Select

s.scheduleid

, s.namelast

, s.namefirst

, s.startdate

, s.stopdate

, s.notified

, e.mission_id

, e.eventName

, e.eventtype

, dateadd(hh,-5,e.alerttime) as alertime

, dateadd(hh, -5,e.showtime) as showtime

, et.EventCat

, e.eventsquadron

, e.eventsid

, e.eventtitle

, p.phonehome

, p.phonecell

, cp.crw_pstn_dty _cd

--, a.FLYR_ORG_UNIT _ID

--, a.person_id

From ****** as p

join ***** s

on p.ssn = s.ssn

join ***** e

on s.eventsid = e.eventsid

join ****** et

on e.eventtype = et.eventtypelon g

left join ******* a

on a.person_id = p.ssn

left join ******* cp

on a.person_id = cp.person_id

Where

--((dateadd(hh, -5,e.startdate)) between @sdate and
(dateadd(hh,36, @sdate)))

(dateadd(hh,-5,e.alerttime) between @sdate and (dateadd
(hh,@time,@sdat e)))

and substring(a.FLY R_ORG_UNIT_ID,1 ,4) like @squad

and cp.arcft_asg_ev t_id = '01'

and cp.crw_pstn_dty _cd like @cp

order by e.alerttime,e.e venttitle,s.nam elast

GO

[MSFT]

Hi Derek,

I am not confident that I have understood the problem clearly. Did you need
to add a TextBox or Dropdownlist to let user select some values, and then
requery the database. If so, after user input the value and click a button
to post back, you need to execute BindData2() in PostBack, Is this right?

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Derek]

Yes, I want to call binddata2() on button1_click. It
seems the reverse bind is causing the issue however If I
remove that I can not use the save btn update the
database with multiple selections.

The page is set up so that on load if notispostback it
executes Binddata2() else it executes reversebind(). On
the page load the stored procedure is sent all default
parameters (%) to pull all the data. When the daysout
textbox receives input and the go button is clicked
Binddata2() is called and requeries fine. It is when I
add another textbox asking for input for another filter
parameter that it does not execute the stored procedure
correctly. Example they choose to filter based on "p".
It does not change the parameter to pull records only
with "p". The confusing part is that it will execute
binddata2() with the one textbox.

I would prefer to use the dropdown box with or without
the GO btn but if I could get the text box to work that
would be great. The stored procedure works fine in query
analyzer.

Hope this gives you a little more information.
I am including the Html which may help you to see what I
am trying to do. Thanks for your help, it is appreciated
very much

<%@ Page Language="vb" AutoEventWireup ="false"
Codebehind="get EventTitles.asp x.vb"
Inherits="CrewN otify.getEventT itles"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">

<HTML>

<HEAD>

<title>getEvent Titles</title>

<meta content="Micros oft Visual
Studio .NET 7.1" name="GENERATOR ">

<meta content="Visual Basic .NET
7.1" name="CODE_LANG UAGE">

<meta content="JavaSc ript"
name="vs_defaul tClientScript">

<meta
content="http://schemas.microso ft.com/intellisense/ie5"
name="vs_target Schema">

</HEAD>

<body MS_POSITIONING= "GridLayout ">

<form id="Form1" method="post"
runat="server">

<asp:datagrid
id=DataGrid2 style="Z-INDEX: 101; LEFT: 24px; POSITION:
absolute; TOP: 80px" runat="server"
OnItemCommand=" doUpdate" ShowFooter="Tru e"
AutoGenerateCol umns="False" DataMember="og_ getCrewNotify"
DataKeyField="s cheduleid" DataSource="<%# DsCrewNotify1 %

" BorderColor="#0 00099" BorderStyle="No ne"

BorderWidth="1p x" BackColor="Whit e" CellPadding="3"
GridLines="Hori zontal">
<SelectedItemSt yle Font-Bold="True" ForeColor="Whit e"
BackColor="#008 A8C"></SelectedItemSty le>
<AlternatingIte mStyle
BackColor="Gain sboro"></AlternatingItem Style>
<ItemStyle Font-Size="X-Small" ForeColor="Blac k"
BackColor="#EEE EEE"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="Whit e"
BackColor="#000 084"></HeaderStyle>
<FooterStyle ForeColor="Blac k"
BackColor="#CCC CCC"></FooterStyle>

<Columns>
<asp:TemplateCo lumn HeaderText="CP" >
<ItemTemplate >
<asp:Label id=lblCP
runat="server" Text='<%# DataBinder.Eval
(Container, "DataItem.crw_p stn_dty_cd") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn SortExpression= "namelast"
HeaderText="Cre wmember">
<ItemTemplate >
<asp:Label id=Label8
runat="server" Text='<%# Container.DataI tem("namelast")
&amp;", "&amp;Container .DataItem("name first") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn SortExpression= "eventtitle "
HeaderText="Ali as">
<ItemTemplate >
<asp:Label id=lblAlias
runat="server" Text='<%# DataBinder.Eval
(Container, "DataItem.event title") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn Visible="False"
HeaderText="Cat egory">
<ItemTemplate >
<asp:Label id=lblCategory
runat="server" Text='<%# DataBinder.Eval
(Container, "DataItem.Event Cat") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:BoundColum n Visible="False" DataField="sche duleid"
SortExpression= "scheduleid "
HeaderText="sch eduleid"></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="Not ified">
<ItemTemplate >
<asp:CheckBox id="chknotify"
runat="server"> </asp:CheckBox>
</ItemTemplate>
<FooterTemplate >
<asp:Button id="Update"
runat="server" BackColor="Tran sparent"
CommandName="Up date" Text="Save"></asp:Button>
</FooterTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Ale rt">
<ItemTemplate >
<asp:Label id=lblalert
runat="server" Text='<%# DataBinder.Eval
(Container, "DataItem.alert ime", "{0:g}") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Sho w">
<ItemTemplate >
<asp:Label id=lblShow
runat="server" Text='<%# DataBinder.Eval
(Container, "DataItem.showt ime", "{0:g}") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Hom e#">
<ItemTemplate >
<asp:Label id=lblhome
runat="server" Text='<%# DataBinder.Eval
(Container, "DataItem.phone home") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Cel l#">
<ItemTemplate >
<asp:Label id=lblcell
runat="server" Text='<%# DataBinder.Eval
(Container, "DataItem.phone cell") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Com ments">
<HeaderStyle Width="100px"></HeaderStyle>
</asp:TemplateCol umn>

</Columns>
<PagerStyle HorizontalAlign ="Center" ForeColor="Blac k"
BackColor="#999 999" Mode="NumericPa ges"></PagerStyle>
</asp:datagrid><a sp:label id="lblselected caldt" style="Z-
INDEX: 102; LEFT: 136px; POSITION: absolute; TOP: 40px"
runat="server"> </asp:label><asp: label id="Label1"
style="Z-INDEX: 103; LEFT: 136px; POSITION: absolute;
TOP: 16px" runat="server"> Mission
date:</asp:label><asp: button id="Button1" style="Z-INDEX:
104; LEFT: 376px; POSITION: absolute; TOP: 40px"
runat="server"
BackColor="Gray " Width="40px"
Text="Go"></asp:button><asp :label id="lbl4days" style="Z-
INDEX: 105; LEFT: 544px; POSITION: absolute; TOP: 40px"
runat="server"> </asp:label>

<asp:Label
id="Label2" style="Z-INDEX: 106; LEFT: 24px; POSITION:
absolute; TOP: 16px" runat="server"> Today:</asp:Label>

<asp:Label
id="lbltoday" style="Z-INDEX: 107; LEFT: 24px; POSITION:
absolute; TOP: 40px" runat="server"> </asp:Label>

<asp:TextBox
id="txtdaysout " style="Z-INDEX: 108; LEFT: 288px;
POSITION: absolute; TOP: 40px"
runat="server" Width="40px"></asp:TextBox>

<asp:Label
id="Label3" style="Z-INDEX: 109; LEFT: 280px; POSITION:
absolute; TOP: 16px" runat="server"> # days to
view</asp:Label>

<asp:Label
id="Label9" style="Z-INDEX: 110; LEFT: 544px; POSITION:
absolute; TOP: 16px" runat="server"> Hours
ahead:</asp:Label>

<asp:Label
id="lblusersqua d" style="Z-INDEX: 111; LEFT: 768px;
POSITION: absolute; TOP: 24px"
runat="server" Visible="False" ></asp:Label>

<asp:DropDownLi st
id="ddcp" style="Z-INDEX: 112; LEFT: 440px; POSITION:
absolute; TOP: 40px" runat="server"
Visible="False" >
<asp:ListItem Value="C">C</asp:ListItem>
<asp:ListItem Value="L">L</asp:ListItem>
<asp:ListItem Value="P">P</asp:ListItem>
<asp:ListItem Value="S">S</asp:ListItem>
<asp:ListItem Value="All"
Selected="True" >All</asp:ListItem>

</asp:DropDownLis t>

<asp:Label
id="Label10" style="Z-INDEX: 113; LEFT: 440px; POSITION:
absolute; TOP: 16px" runat="server"
Visible="False" >Filter by CP:</asp:Label>

<asp:Label
id="lblselected CP" style="Z-INDEX: 114; LEFT: 648px;
POSITION: absolute; TOP: 40px"
runat="server" Visible="False" ></asp:Label>

<asp:TextBox
id="txtSelected CP" style="Z-INDEX: 115; LEFT: 840px;
POSITION: absolute; TOP: 80px"
runat="server" Width="64px" Visible="False" ></asp:TextBox>

<asp:Label
id="Label11" style="Z-INDEX: 116; LEFT: 848px; POSITION:
absolute; TOP: 56px" runat="server"
Visible="False" >CP</asp:Label></form>

</body>

</HTML>

[MSFT]

Hi Derek,

The problem is that when you click the button1, it is also a postback so
that the reverse update also get executed. Is possible to move
ReverseUpdate out of Form load and add it in the Save/Update button's Click?

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)