Search in Naslu

    Dim sqlConn as new SqlConnection("Data Source={0};Initial Catalog={1};
                                      UserID={2};Password={3}")
    Dim sqlda As New SqlDataAdapter
    Dim sqlcomm As New SqlClient.SqlCommand
    With sqlcomm
      .Connection = sqlConn
      .CommandText = "stored_Name"
      .CommandType = CommandType.StoredProcedure
      .Parameters.AddWithValue("@Param1", value1)
      .Parameters.AddWithValue("@Param2", value2)
        End With
    sqlda.SelectCommand = sqlcomm
    sqlConn.Open()
    Try
      sqlda.Fill(ds, TableName)
    Catch ex As SqlException
      Throw ex
    Finally
      sqlConn.Close()
    End Try

fill Dataset calling stored procedure
Uploaded on 6/20/2007 3:42:33 AM
Programming Language: VB .NET

By: Carlos
See more code snippets of Carlos

.NET Stored procedure SqlDataAdapter