SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2006
    Posts
    101
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Open frmDataGrid from Form # 1

    This code on my form # 1 button.

    Code:
    Code VBNET:
          If txtDate.MaskCompleted = True Then
                      Dim form As New frmDataGrid
                       form.Show()
          Else
                         MessageBox.Show("You must input a date")
                         Exit Sub
          End If



    I added a form "frmDataGrid" (used vb.net toolbox to create datagrid). I did picked Stored Procedure(@tDate is require parameter) during the wizard. How do I pass a parameter from my form #1 (txtDate) to frmDataGrid?

  2. #2
    SitePoint Zealot
    Join Date
    Aug 2006
    Posts
    101
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I got it to read the sp but i have hard code the date. any help ???

    Me.Usp_View_Adder_FeeTableAdapter.Fill(Me.Open_AirDataSet.usp_View_Adder_Fee, "2008-6-6") - works


    Need help here. My text box is masked text box. i need to make this to a date type and use it as parameter.
    Me.Usp_View_Adder_FeeTableAdapter.Fill(Me.Open_AirDataSet.usp_View_Adder_Fee, Me.txtDate2.Text = Format(DateTime, "YYYY-MM-DD"))


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •