How To Display Data Using Stored Procedure In My Asp.net Form

I want to display the data in datagrid using the stored procedure,





Can you please tell me, how i can create the stored procedure for the following:


using select query(SELECT Top 10 OrderID, CustomerID, EmployeeID, OrderDate FROM Orders)





I want to display the stored procedure data in my Datagrid.





Thank you very much for the help.


the following is complete inline code on my webform.








Dim objConn As New SqlConnection(ConfigurationSettings.AppSettings("NorthwindConnection"))


Dim objCmd As New SqlCommand


Dim dataAdapter As SqlDataAdapter





objCmd.Connection = objConn


objCmd.CommandType = CommandType.Text


objCmd.CommandText = "SELECT Top 10 OrderID, CustomerID, EmployeeID, OrderDate FROM Orders"





objConn.Open()





dataAdapter = New SqlDataAdapter


dataAdapter.TableMappings.Add("Table", "Orders")


dataAdapter.SelectCommand = objCmd





dataSet = New DataSet("Orders")


dataAdapter.Fill(dataSet)


dtgOrders.DataSource = dataSet


dtgOrders.DataBind()





objConn.Dispose()