Friday, September 28, 2007

To execute stored procedure from vb.net

Dim cmd As New SqlCommand("getlast", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@last", "last name"))
Dim adp As New SqlDataAdapter() adp.SelectCommand = cmd
Dim ds As New DataSet adp.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()

No comments: