ASP.NET

How Can I Use View Here

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 11

Reputation: chinni1 is an unknown quantity at this point

Solved Threads: 0

chinni1

Offline

Newbie Poster

How Can I Use View Here

Jan 6th, 2009

Hi Frends,
Can I use View Insted of query in my code.
If yes Then plz tell me how can.

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
 Protected Sub checkavailabilityusername(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertEventArgs) Handles usersformview.ItemInserting
        Dim name As TextBox
        Dim username As String
        Dim Query As String
        Dim dr As SqlDataReader
        Dim db As DBConnection
        db = DBConnection.getConnection()
        name = usersformview.FindControl("username")
        username = name.Text
 
        Query = "SELECT [username] FROM [customer] where [username] = '" & username & "' "
        dr = db.executeQuery(Query)
        If dr.Read = True Then
            e.Cancel = True
 
            errmsg.Text = "<h5 style='color:#270000;'> The User Name you have entered is already exists.Please enter another  User Name.</h5>"
            'Response.Write("<h4 color=red> The Country name you have entered is already exists.Please enter another the country name.</h4>")
 
        End If
        dr.Close()
 
    End Sub
 
 Protected Sub checkavailabilityusername(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertEventArgs) Handles usersformview.ItemInserting
        Dim name As TextBox
        Dim username As String
        Dim Query As String
        Dim dr As SqlDataReader
        Dim db As DBConnection
        db = DBConnection.getConnection()
        name = usersformview.FindControl("username")
        username = name.Text

        Query = "SELECT [username] FROM [customer] where [username] = '" & username & "' "
        dr = db.executeQuery(Query)
        If dr.Read = True Then
            e.Cancel = True

            errmsg.Text = "<h5 style='color:#270000;'> The User Name you have entered is already exists.Please enter another  User Name.</h5>"
            'Response.Write("<h4 color=red> The Country name you have entered is already exists.Please enter another the country name.</h4>")

        End If
        dr.Close()

    End Sub

Thanks

Last edited by peter_budo; Jan 11th, 2009 at 2:41 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Dec 2008

Posts: 104

Reputation: Aneesh_Argent is an unknown quantity at this point

Solved Threads: 18

Aneesh_Argent Aneesh_Argent is offline

Offline

Junior Poster

Re: How Can I Use View Here

Jan 6th, 2009

A view is, in essence, a virtual table which is based on SQL SELECT query. It does not physically exist. A view is an object that can derive data from one or more tables. For Eg Suppose there is a Users Table named customer which has some 100 columns and your wish to create a view with just the userName column

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE VIEW view_UserNames AS
SELECT UserName
FROM customer
CREATE VIEW view_UserNames AS
SELECT UserName
FROM customer

Now rather than using the customer table you can use the view 'view_UserNames' in you code.

Last edited by peter_budo; Jan 11th, 2009 at 2:42 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Dec 2008

Posts: 11

Reputation: chinni1 is an unknown quantity at this point

Solved Threads: 0

chinni1

Offline

Newbie Poster

Re: How Can I Use View Here

Jan 6th, 2009

•

Originally Posted by Aneesh_Argent

A view is, in essence, a virtual table which is based on SQL SELECT query. It does not physically exist. A view is an object that can derive data from one or more tables. For Eg Suppose there is a Users Table named customer which has some 100 columns and your wish to create a view with just the userName column

CREATE VIEW view_UserNames AS
SELECT UserName
FROM customer

Now rather than using the customer table you can use the view 'view_UserNames' in you code.

Ok Thanq