Convertion

[shivabisoi]

HI,

I am storing a value in database table like [0-9]{2}[a-zA-Z]{3},But My problem is that at the time of accessing this value in grid view it should be converted int NNCCC .[0-9]{2} means it convert in to NN [a-zA-Z]{3} means it convert CCC
N-Numeric,C-Character

Protected Sub btnButton_ServerClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnButton.ServerClick
        Dim input, str As String
        Dim l As Integer
        Dim i, j, n As Integer
        input = Text1.Value
        str = ""
        l = 6
        While l < input.Length
            j = Integer.Parse(input.Substring(l, 1))
            For i = l - 5 To l - 3
                If input.Substring(i, 3) = "0-9" Then
                    For n = 0 To j - 1
                        str = str & "N"
                    Next
                ElseIf input.Substring(i, 3) = "A-Z" Then
                    For n = 0 To j - 1
                        str = str & "C"
                    Next
                End If
 
            Next
            l = l + 8
        End While
        Text2.Value = str
    End Sub

This code is working on Two text box Text1 and Text2.When I Enter value in Text1 i get output on Text2.But My problem is that How can i get value from database and display in gridview.

[MrMancunian]

So? What do you want from us then? Do you already have code? Is there even a question?

Steven

[Frinavale]

A GridView will display the data that it is bound to.
You need to retrieve the data from the database first before you can bind the GridView to anything.

Please review the following article that outline how to use a database:
Database tutorial Part 1
Database tutorial Part 2[/quote]

-Frinny