[DFWOscar]

Hello,

i am currently building an ASPX webpage for internal use. Basically, there are two buttons on this page and I need each one to kick off a different stored procedure on our local SQLServer based on the needed task.
these stored rocedures do quite a bit of work and take 3-5 minutes to finish running. In neither case do I need any kind of gridview or other output from these stored procedures, as they are simply crunching/cleaning data that will populate some tables that the user will then use to complete their task. There are also no inputs or parameters needed.

So i'm OK at ASPX and pretty good at SQL, but have no idea on the VB code behind page. This is what I have ben able to put together based on 3 days of googling. i think i am close but can't quite get across the line.

Imports System.Data.SqlClient

Partial Class _Default
    Inherits System.Web.UI.Page


    Protected Sub RunBillingButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles RunBillingButton.Click
        RunBillingButton.Attributes.Add("onclick", "return confirm('Did you remember to check the Box?');")
        Dim con As String = ConfigurationManager.ConnectionStrings("KFileAddString").ConnectionString
        Dim cmd As New SqlCommand("sp_Production")
        cmd.CommandType = Data.CommandType.StoredProcedure

        con.Open()
        If CheckBox1.Checked = True Then
            cmd.CommandText = "sp_Production"
        End If

    End Sub

End Class 

I'm not sure if you need to see any of my ASPX or my SQL. both work fine on their own, but i am not able to get these buttons to work.

Thanks

Oscar Stiles

[CharlieMay]

Where are you executing the command (cmd)?

[DFWOscar]

I am not sure to be honest. i am not at all familiar with VB.Net syntax.
I have tried to read through some tutorials but it still escapes me. It seems very different than SQL or ASPX or pascal, which are all languages I have experience with. So I really do not know any of the commands or what Dim is/means.
Again, i have tried to do my homework on this, as it were, but i am not sure how to finish the job.

[CharlieMay]

Well, I haven't studied your code but assuming, you've set up your connection properly, let's look at this block

  If CheckBox1.Checked = True Then
     cmd.CommandText = "sp_Production"
  End If

This could also simply have the statement in it

  If CheckBox1.Checked = True Then
     cmd.CommandText = "INSERT INTO myTable (colA, colB) VALUES ("Charlie", "May")
     'But... This is only defining the statement to the command. Now you need to execute it
     cmd.ExecuteNonQuery ' This execute a Non-Query (Not a SELECT statement) 
  End If

This tutorial might help

[Shadar]

You might try looking at this. Even if you don't use it, it is pretty good for a learning tool.

SQL Module

This post has been edited by Shadar: 27 January 2012 - 12:53 PM