 |  |  |  |  |  |  |  |
Can we use view Instead of Query
Please support our ASP.NET advertiser: Intel Parallel Studio Home
 |
This is my code.Here Instead of query string can i use view.
plz reply me.
Protected Sub btnchk_name_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnchk_name.Click
Dim str As String = "select ID from table1 where ID = '" & txtid.Text & "'"
Dim con As String = ConfigurationManager.AppSettings("preeconn")
Dim com As New SqlCommand(str, New SqlConnection(con))
com.Connection.Open()
Dim da As New SqlDataAdapter(str, con)
Dim dr As SqlDataReader
dr = com.ExecuteReader 'where sqldatareader ain't run without using
If Not dr.Read() Then
datagrid.datasource=com.executereader()
datagrid.databind()
End If
End Sub
plz reply me.
Protected Sub btnchk_name_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnchk_name.Click
Dim str As String = "select ID from table1 where ID = '" & txtid.Text & "'"
Dim con As String = ConfigurationManager.AppSettings("preeconn")
Dim com As New SqlCommand(str, New SqlConnection(con))
com.Connection.Open()
Dim da As New SqlDataAdapter(str, con)
Dim dr As SqlDataReader
dr = com.ExecuteReader 'where sqldatareader ain't run without using
If Not dr.Read() Then
datagrid.datasource=com.executereader()
datagrid.databind()
End If
End Sub
•
•
Join Date: Dec 2008
Posts: 104
Reputation: 
Solved Threads: 18
Junior Poster
Can you pls explain your objective first. I cant get it form you code. I have made some comments in your code. Can u pls explain those things
Protected Sub btnchk_name_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnchk_name.Click
Dim str As String = "select ID from table1 where ID = '" & txtid.Text & "'"
Dim con As String = ConfigurationManager.AppSettings("preeconn")
Dim com As New SqlCommand(str, New SqlConnection(con))
com.Connection.Open()
Dim da As New SqlDataAdapter(str, con)
' I cant see you using this object anywhere
Dim dr As SqlDataReader
dr = com.ExecuteReader 'where sqldatareader ain't run without using
' Are you sure this is the condition you really meant to give
If Not dr.Read() Then
datagrid.datasource=com.executereader()
' When you already have the result of your query in the sqldatareader object, why are u executing the same query the again, you could have used the same old object
datagrid.databind()
End If
End Sub
Protected Sub btnchk_name_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnchk_name.Click
Dim str As String = "select ID from table1 where ID = '" & txtid.Text & "'"
Dim con As String = ConfigurationManager.AppSettings("preeconn")
Dim com As New SqlCommand(str, New SqlConnection(con))
com.Connection.Open()
Dim da As New SqlDataAdapter(str, con)
' I cant see you using this object anywhere
Dim dr As SqlDataReader
dr = com.ExecuteReader 'where sqldatareader ain't run without using
' Are you sure this is the condition you really meant to give
If Not dr.Read() Then
datagrid.datasource=com.executereader()
' When you already have the result of your query in the sqldatareader object, why are u executing the same query the again, you could have used the same old object
datagrid.databind()
End If
End Sub
•
•
•
•
Originally Posted by Aneesh_Argent 
Can you pls explain your objective first. I cant get it form you code. I have made some comments in your code. Can u pls explain those things
Protected Sub btnchk_name_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnchk_name.Click
Dim str As String = "select ID from table1 where ID = '" & txtid.Text & "'"
Dim con As String = ConfigurationManager.AppSettings("preeconn")
Dim com As New SqlCommand(str, New SqlConnection(con))
com.Connection.Open()
Dim da As New SqlDataAdapter(str, con)
' I cant see you using this object anywhere
Dim dr As SqlDataReader
dr = com.ExecuteReader 'where sqldatareader ain't run without using
' Are you sure this is the condition you really meant to give
If Not dr.Read() Then
datagrid.datasource=com.executereader()
' When you already have the result of your query in the sqldatareader object, why are u executing the same query the again, you could have used the same old object
datagrid.databind()
End If
End Sub
Actually my question is can we use views instead of query in our code.
|
Similar Threads
- SQL query problem with WHERE clause (ASP)
- Problems using a php generator (PHP)
- Need Help connecting to a view (MS SQL)
- create a query in access from vb6 (Visual Basic 4 / 5 / 6)
- I need to trace or view that the stored proc is saving the data. (VB.NET)
- Create View syntax problem (Oracle)
- call resultset in join query (JSP)
- PHP Query, Make users login before accessing a movie? (PHP)
- Invision Power Board mysql error when trying to view newly created forums (PHP)
- Cant view Site with Changed DNS (Windows NT / 2000 / XP)
Other Threads in the ASP.NET Forum
- Previous Thread: Session Variable - Question
- Next Thread: file upload
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
.net 2.0 activexcontrol advice ajax alltypeofvideos asp asp.net bc30451 bottomasp.net browser businesslogiclayer button c# c#gridviewcolumn checkbox click commonfunctions compatible confirmationcodegeneration content contenttype courier css dataaccesslayer database datagrid datagridview datagridviewcheckbox datalist deadlock development dgv dropdownlist dropdownmenu dynamically edit expose fill flash flv formatdecimal forms formview gridview homeedition iframe iis javascript jquery listbox menu microsoft mono mouse mssql multistepregistration news numerical objects opera order panelmasterpagebuttoncontrols radio ratings registration reportemail rotatepage save schoolproject search security serializesmo.table silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking unauthorized validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webapplications webarchitecture webdevelopemnt webprogramming webservice xml xsl youareanotmemberofthedebuggerusers
