question on passing value.. RSS

• • Reply
  

  skwak2

  Member

  430 Points

  86 Posts

  question on passing value..

  Aug 12, 2003 01:46 PM|LINK

  Hi guys.. question on passing value.. code below is delete aspx page. i am getting the studyname from the previous page. "StudyName=Context.items("StudyName")" is the value that i need.. after i delete a row..page should keep that studyname value.. where and how can i do that? thanks guys.. <script language="VB" runat="server"> Dim strConn Sub MyDataGrid_DeleteCommand(s As Object, e As DataGridCommandEventArgs ) strConn="Server=*********;Database=*********;UID=*********;Pwd=*********" 'Dim strConn as strConn="Server=*********;Database=*********;UID=*********;Pwd=*********" Dim DeleteCmd As String = "DELETE from studyusertable Where Userid = @UserId" Dim MyConn as New SQLConnection(strConn) Dim Cmd as New SqlCommand(DeleteCmd, MyConn) Cmd.Parameters.Add(New SqlParameter("@UserID", MyDataGrid.DataKeys(CInt(e.Item.ItemIndex)))) MyConn.Open() Cmd.ExecuteNonQuery() MyConn.Close() BindData End Sub Sub Page_Load(Source As Object, E As EventArgs) If Not Page.IsPostBack Then BindData() End If End Sub Sub BindData() Dim studyname StudyName=Context.items("StudyName") strConn="Server=*********;Database=*********;UID=*********;Pwd=*********" Dim MySQL as String = "SELECT studyusertable.userid, usertable.FirstNm, usertable.LastNm, FDSStudyGroups.studyName, " _ &" FDSStudyGroups.studyFullNm, FDSStudyGroups.remarks, studyusertable.groupID " _ &" FROM studyusertable INNER JOIN " _ &" usertable ON studyusertable.userid = usertable.UserID INNER JOIN " _ &" FDSStudyGroups ON studyusertable.groupID = FDSStudyGroups.groupid " _ &" WHERE studyusertable.groupID = '" & Studyname &"'" _ &" ORDER BY studyusertable.groupID " Dim MyConn as New SQLConnection(strConn) Dim ds as DataSet=New DataSet() Dim Cmd as New SQLDataAdapter(MySQL,MyConn) Cmd.Fill(ds,"studyusertable") MyDataGrid.Datasource=ds.Tables("studyusertable").DefaultView MyDataGrid.DataBind() End Sub </script> <form runat="server" method="post"> </form>
• • Reply
  

  new2ASPnet

  Member

  700 Points

  140 Posts

  Re: question on passing value..

  Aug 12, 2003 03:35 PM|LINK

  Hi skwak, Try adding a hidden control in your page, and in your delete command assign the studyname to the value of that control. HIH
  The most wasted day is that in which we have not laughed.
  
  
  V i r g i l R e b o t o n