Public Function GetProductCategories() As DataSet
Dim sqlcmdSelectCategories As New SqlCommand("sp_Categories_SEL")
With sqlcmdSelectCategories
.CommandType = CommandType.StoredProcedure
End With
Dim dsCategories As New DataSet()
Dim sqlconInetShop As New SqlConnection(Connstring)
sqlcmdSelectCategories.Connection = sqlconInetShop
Dim sqladpCategories As New SqlDataAdapter(sqlcmdSelectCategories)
sqladpCategories.Fill(dsCategories, "Categories")
Return dsCategories
End Function请问在sqlcommand的后面怎么加了with。他的作用是什么啊?
Dim sqlcmdSelectCategories As New SqlCommand("sp_Categories_SEL")
With sqlcmdSelectCategories
.CommandType = CommandType.StoredProcedure
End With
Dim dsCategories As New DataSet()
Dim sqlconInetShop As New SqlConnection(Connstring)
sqlcmdSelectCategories.Connection = sqlconInetShop
Dim sqladpCategories As New SqlDataAdapter(sqlcmdSelectCategories)
sqladpCategories.Fill(dsCategories, "Categories")
Return dsCategories
End Function请问在sqlcommand的后面怎么加了with。他的作用是什么啊?
用了with后,只需要写 .CommandType ,省略了sqlcmdSelectCategories