ASP.NET

aransiola wrote:

Dim intCount As Integer = 0
Dim strSQL As String = "Select ClientID,CPassword From Client Where "
strSQL &= "ClientID='" & CustCode.Trim & "'"
strSQL &= " AND CPassword='" & PinID.Trim & "'"

oConn = New OleDbConnection
oConn.ConnectionString = strConn
oConn.Open()

With oCmd
.CommandText = strSQL
.Connection = oConn
intCount = .ExecuteScalar
End With

ValidCustomer = False
If intCount > 0 Then
ValidCustomer = True
End If
oConn.Close()

Dim strSQL As String = "Select COUNT(ClientID) From Client Where "
strSQL &= "ClientID='" & CustCode.Trim & "'"
strSQL &= " AND CPassword='" & PinID.Trim & "'"

<br />
For i As Int16 = 0 To DataGrid1.Items.Count - 1<br />
    If CType(DataGrid1.Items(i).Cells(0).Controls(1), CheckBox).Checked Then<br />
<br />
       Dim cmd As New SqlCommand("update abctable set changed='abc' where id=" & Val(DataGrid1.Items(i).Cells(1).Text))               <br />
           cmd.Connection = conn<br />
           conn.Open()<br />
           cmd.ExecuteNonQuery()<br />
           conn.Close()<br />
     End If<br />
  Next<br />
<br />

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
    <Columns>
        <asp:TemplateField HeaderText="Logged On">
            <ItemTemplate>
                <asp:CheckBox ID="CheckBox1" runat="server" Checked="<%# GetValue(Container.DataItem)  %>"/>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="user_name" HeaderText="Username" />
    </Columns>
</asp:GridView>

Protected Function GetValue(ByVal DataItem As Object) As Boolean
    If DataBinder.Eval(DataItem, "logged_on") = "1" Then
        Return True
    Else
        Return False
    End If
End Function

set currentdate = first date + 1 day
while currentdate is less than second date
  print currentdate
  currentdate = currentdate + 1 day
end while