How Can I Use View Here

Expand Post »

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

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.

Similar Threads

Windows 2000 - Windows Explorer folder view is gone in Windows NT / 2000 / XP
why cant i just view in Windows NT / 2000 / XP
Can't view source codes in Web Browsers
View Source in IE6 in Web Browsers

chinni1

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Dec 2008

Permalink

Jan 6th, 2009

Re: How Can I Use View Here

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

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.

Aneesh_Argent

Reputation Points: 16

Solved Threads: 18

Junior Poster

Offline

104 posts
since Dec 2008

Permalink

Jan 6th, 2009

Re: How Can I Use View Here

Click to Expand / Collapse Quote 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

chinni1

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Screen Capturing in a Web Application

Next Thread in ASP.NET Forum Timeline: Using login form control, how to redirect users to different pages?

DaniWeb Message

Cancel Changes