Hi all
can i

<asp:BoundField HeaderImageUrl="~/Images/<%=Session("uno")%>.png" 

Select all Open in new window

need a session value inthere is that posible?
regards

So, a client would like to be able to have their employees receive a message if they haven't entered in time within the last 7 days. Specifically Monday - Monday at 12:00PM. If the employees have not entered in time by noon, they should be locked down and only allowed to enter time for dates that fall within the last 7 days. The code is written in VB.NET and utilizes SQL and Stored Procedures heavily. I was hoping to get some ideas in regards to possible ways to go about this.

I have just started to work with WPF using VB.net and have had trouble getting the DataGrid to work with the Access Database (Jet) that holds my data.  I learn best through examples and I would be grateful if someone can give me sample code (both XAML and VB) to solve the following situation.

I have a DataGrid as follows:
            <DataGrid Name="dgPayment" Margin="10,15,10,10" Grid.Column="0" AutoGenerateColumns="False"
                      ItemsSource="{Binding}"
                      RowEditEnding="dgPayment_RowEditEnding"
                      CellEditEnding="dgPayment_CellEditEnding"
                      SelectionChanged="dgPayment_SelectionChanged"
                      CommandManager.PreviewExecuted="dgPayment_PreviewCommand"
                      IsReadOnly="False" CanUserAddRows="True" CanUserDeleteRows="True" >
                <DataGrid.Columns>
                    <DataGridTextColumn Header="Seq" Binding="{Binding Path=CL_Seq}" />
                    <DataGridTextColumn Header="Name" Binding="{Binding Path=CL_Name}" Width="200" />
                    <DataGridTextColumn Header="Hdr1" Binding="{Binding Path=CL_Hdr1}" />
                    <DataGridTextColumn Header="Hdr2" Binding="{Binding Path=CL_Hdr2}" />
                    <DataGridTextColumn Header="Hdr3" Binding="{Binding Path=CL_Hdr3}" />
                </DataGrid.Columns>
            </DataGrid>

I have code behind as follows:
            Using conn = CashConnection
            …

Dear experts
 how do i achive

 Dim txtemail As String
        Dim registros As Integer


        cn.Open()

        Dim sql4 As String = "select count(*) from nfl"
        Dim cmd4 As New OleDbCommand(sql4, cn)
        registros = (cmd4.ExecuteScalar())
        cn.Close()

        Do While registros >= 0
            cn.Open()
            Dim sql3 As String = "select mail from nfl"
            Dim cmd As New OleDbCommand(sql3, cn)
            txtemail = (cmd.ExecuteScalar())

            cn.Close()

            registros = registros - 1
        Loop

Select all Open in new window

but move bettween records to get the email value

regards

In oracle have a stored procedure return a clob and in vb.net assign the clob to a devexpress richtextbox's rtftext property

Hello all. I have an ASP.NET web forms application that has been working fine until a recent change from cookies to session variables (don't think that has anything to do with it but ...) and an upgrade of the Telerik controls.
The same code behind, in two separate ASPX pages (print and reprint), behave differently. They both use this format:

1 Dim PrintCmd as String = "PrintForm.aspx?var1=value&var2=value..."
2 PrintCmd =  "<script language=javascript> {window.open('" & PrintCmd & "', '_blank');}</script>"
3 WriteNlog.Info(PrintCmd)
4 Response.Write(PrintCmd)
5 Response.Write(PrintCmd.Replace("Some Text","Other Text")
6 CallNlog.Info("Returned from print")

The page being called is a simple ASPX that copies the query values to labels and then the body performs window.print() then window.close(). It makes an NLog entry at preload and load, when it works.

Page1.aspx executes 1,2,3 and 6. Logging in the PrintForm.aspx does not occur, no error is reported, as if 4 and 5 are comments.
Page2.aspx executes 1 through 6 without fail.

Both origination forms use the same site master with Telerik controls (RadScriptManager, RadMenu, RadAjaxLoadingPanel and RadAjaxManager).
The print page is pure ASP webform.

Alternately I have tried:
4 ClientScript.RegisterStartupScript(Me.GetType(), "receipt1", PrintCmd, True)
5 ClientScript.RegisterStartupScript(Me.GetType(), "receipt2", PrintCmd.Replace("Some Text","Other Text"), True)

Again, page2 works flawlessly and …

I want to store HTML code in database.
is it possible? If yes then how?

I need to stop the user register if the username is contained in the password
this work for me

password.Contains(username)

Select all Open in new window

But i need it to stop the registration if is

Ernesto or ernesto

at this moment just if is  ernesto or ernesto  quits

i mean, how to do it no mater the  CASE!

regards

Everything was going well... playing around with Visual Studio 2017 for the first time...

Had a weird problem (#1, but not really what the question is about where even though I set the Assembly Name and Root Namespace names, ApplicationName was still returning "WindowsApp1" when referenced... so I thought maybe it's building using that temp name when run from VS IDE.  So I compiled it into an app and deployed it.  Same result...

So I try re-opening the project - I can't open forms!  I can a new form, but when I try to open the main form, the only "main" reference I have is main.vb.  And when I open that, I don't have any code either!  I have one other form in the app and I can't open that either (but the code is visible).

I'd really like to continue this project but I need to see the forms!  HELP PLEASE!?!

(Classic Windows Forms app).

Hello,
How can i highlight the cell border when clicked on it.

I am using vb.net 2015 desktop.

Cheers

I had this question after viewing search a textbox for a key word in a Listview. VB.net.

I want textbox1 listview1 and button1 to search and display all same items in listview and remove other items to display only the word I search. How?

Like this one , search name Nikko and display Only nikko's record
VB.net-ListView.JPG

I have a series of ListBoxes I inherited. (Many)

I need to build a comma selerated string that I can pass into SQL Server

So...
If a person selects Bob, Tim and Larry

strAccomName below would get built as
'Bob','Tim','Larry'

So that when I pass it ito SQL

It can be used  as
WHERE a.AccomName in (@strAccomName)

        For Each Item As ListItem In ddlAccomName.Items
            If Item.Selected Then
                strAccomName = strAccomName & Item.Value & ","
            End If
        Next


balh... blah... blah...
 oCom1.Parameters.Add(New SqlParameter("@strAccomName", SqlDbType.VarChar)).Value = strAccomName

blah... blah... blah...

I am also open to manipulating them on the SQL Server side.

My previous application in VB6 would create a record using the code below:

Module:

Module basDeclarations

Public Const maxTables = 20

Structure Gametype
    <VBFixedString(6)> Public memberID As String
    Public TableID As Integer
    Public StartTime As Date
    <VBFixedString(1)> Public Occupied As String
End Structure

End Module

Procedure:

Public Sub CreateCurrentGamesFile()
    Dim OneGame As Gametype
    Dim TableNumber As Integer
    Open app.path & "\CurrentGames.dat" For Random As #1 Len = Len(OneGame)
    For TableNumber = 1 To maxTables
        OneGame.memberID = ""
        OneGame.TableID = TableNumber
        OneGame.Occupied = "N"
        Put #1, TableNumber, OneGame
    Next TableNumber
    Close #1
End Sub
End Class

How can I convert this block of code in vb.net to create new records as a random access file? Or Is there a better way to store records which can be easily saved and deleted in vb.net? Thanks

Please provide comments on your code