ASP.NET

SELECT MyName FROM MyTable WHERE DATEPART(year, MyDate) = @MyYear

CREATE PROCEDURE GetNames
@Year int
AS
    SELECT MyName FROM MyTable WHERE DATEPART(year, MyDate) = @Year
GO

using(SqlConnection conn = new SqlConnection(myConnectionString))
{
    SqlCommand cmd = new SqlCommand();
    cmd.Connection = conn;
    cmd.CommandText = "GetNames";
    cmd.CommandType = CommandType.StoredProcedure;
    conn.Open();
    SqlDataReader reader = cmd.ExecuteReader();
    while(reader.Read())
    {
        string name = reader.GetString(0);
        // Do what you need to do with name here.
    }
}

danasegaranea wrote:

gridiview during postpack(VS2003)

Private Sub dgResources_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles dgResources.PageIndexChanged
        dgResources.CurrentPageIndex = e.NewPageIndex
        dgResources.DataBind()
    End Sub

For i = 0 To dgResources.Items.Count - 1
            chk = (dgResources.Items(i).Cells(0).FindControl("chkResource_First"))
            If Not chk Is Nothing Then
                If chk.Checked = True Then  ' Always false.
                      'Do some thing 
                End If
            Else
            End If
        Next

danasegaranea wrote:

dgResources.CurrentPageIndex = e.NewPageIndex
dgResources.DataBind()