Форум программистов [Powered by Invision Power Board]

Код


ALTER PROCEDURE dbo.StoredProcedure2
    /*
    (
    @parameter1 int = 5,
    @parameter2 datatype OUTPUT

    )
    */
AS
    /* SET NOCOUNT ON */ 
    RETURN 
    
select [ID],[Predmet]from [Predmet]

Код


Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.DataSet
Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim ds As DataSet
        Dim da As SqlDataAdapter
        Dim con As SqlConnection
        Dim cmd As SqlCommand
        ds = New DataSet
        da = New SqlDataAdapter
        con = New SqlConnection("server=Home;database=Test_Lan;Trusted_Connection=yes;User ID=SA;Password=1")
        cmd = New SqlCommand
        cmd.Connection = con
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "StoredProcedure2"
        con.Open()
        da.AcceptChangesDuringFill = True
        da.MissingSchemaAction = MissingSchemaAction.AddWithKey
        da.TableMappings.Add("Spisok", "Test_Lan")
        da.SelectCommand = cmd
        da.Fill(ds)
        GridView1.DataSource = ds.Tables("Spisok")
        con.Close()
    End Sub
End Class