Click here to Skip to main content
15,901,205 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: datetime value Pin
anujbanka178419-Feb-09 18:24
anujbanka178419-Feb-09 18:24 
QuestionVStudio 2008 Model View Controller Menu Item missing Pin
dwolver18-Feb-09 13:44
dwolver18-Feb-09 13:44 
Questionvs 2008 single web.config Pin
omer erakman18-Feb-09 7:05
omer erakman18-Feb-09 7:05 
AnswerRe: vs 2008 single web.config Pin
Christian Graus18-Feb-09 12:40
protectorChristian Graus18-Feb-09 12:40 
QuestionHow to create an email application for receiving emails? Pin
sandip singh18-Feb-09 6:09
sandip singh18-Feb-09 6:09 
AnswerRe: How to create an email application for receiving emails? Pin
vaghelabhavesh18-Feb-09 6:17
vaghelabhavesh18-Feb-09 6:17 
QuestionCalling a Web Service from Test Harness Pin
rkajal18-Feb-09 5:12
rkajal18-Feb-09 5:12 
Questionplz check y there is an erro in reading data Pin
Ali_10018-Feb-09 4:46
Ali_10018-Feb-09 4:46 
errror generate when the data reader read.i have made the login project,

the error write that
(Incorrect syntax near the keyword 'user')
. but there is not a problem in table name because i have change it to users than it will give different error
the error occurred in loReader = loCommand.ExecuteReader()


Imports System
Imports System.Data.Sql
Imports System.Data
Imports System.Data.SqlClient

Partial Public Class _Default
Inherits System.Web.UI.Page

Public Shared lsConnectionString As String



Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

End Sub

Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate





Dim loConnection = New SqlConnection(lsConnectionString)
Dim loCommand As New SqlCommand("SELECT * FROM user", loConnection)
Dim lsUsername, lsPassword, lsUserType, lsstatus, lscount As String
Dim loReader As SqlDataReader
'Dim abc As IDataReader
loConnection.Open()
error here loReader = loCommand.ExecuteReader()
'abc = loCommand.ExecuteReader()
loReader = loCommand.ExecuteReader



While loReader.Read()
lsUsername = CStr(loReader("username"))
lsPassword = CStr((loReader("password")))
lsUserType = CStr((loReader("usertype")))


End While
loConnection.Close()

End Sub
End Class
AnswerRe: plz check y there is an erro in reading data Pin
ABitSmart18-Feb-09 5:08
ABitSmart18-Feb-09 5:08 
AnswerRe: plz check y there is an erro in reading data Pin
Agweet18-Feb-09 20:16
Agweet18-Feb-09 20:16 
QuestionImage Control Question Pin
Aptiva Dave18-Feb-09 4:18
Aptiva Dave18-Feb-09 4:18 
QuestionHow to bind Checkbox in <asp:listbox xmlns:asp="#unknown"> control dynamically?</asp:listbox> Pin
CM Makwana18-Feb-09 3:44
CM Makwana18-Feb-09 3:44 
QuestionError while calling Com Object Pin
Vignesh Krishnan18-Feb-09 3:19
Vignesh Krishnan18-Feb-09 3:19 
QuestionRetrive value in three textr box Pin
JAYRAJ GIRI18-Feb-09 2:37
JAYRAJ GIRI18-Feb-09 2:37 
AnswerRe: Retrive value in three textr box Pin
Christian Graus18-Feb-09 12:37
protectorChristian Graus18-Feb-09 12:37 
GeneralEmbedding the ASP.Net engine Pin
Mustafa Ismail Mustafa18-Feb-09 2:27
Mustafa Ismail Mustafa18-Feb-09 2:27 
GeneralRe: Embedding the ASP.Net engine Pin
N a v a n e e t h18-Feb-09 3:05
N a v a n e e t h18-Feb-09 3:05 
GeneralRe: Embedding the ASP.Net engine Pin
N a v a n e e t h18-Feb-09 3:07
N a v a n e e t h18-Feb-09 3:07 
GeneralRe: Embedding the ASP.Net engine Pin
Mustafa Ismail Mustafa18-Feb-09 3:54
Mustafa Ismail Mustafa18-Feb-09 3:54 
GeneralRe: Embedding the ASP.Net engine Pin
N a v a n e e t h18-Feb-09 14:37
N a v a n e e t h18-Feb-09 14:37 
Questionupdate panel dosen't work Pin
radupopescu77718-Feb-09 2:12
radupopescu77718-Feb-09 2:12 
AnswerRe: update panel dosen't work Pin
keyur satyadev18-Feb-09 2:46
keyur satyadev18-Feb-09 2:46 
GeneralRe: update panel dosen't work Pin
radupopescu77718-Feb-09 2:59
radupopescu77718-Feb-09 2:59 
GeneralRe: update panel dosen't work Pin
keyur satyadev18-Feb-09 19:29
keyur satyadev18-Feb-09 19:29 
QuestionPersistent lists of objects Pin
#realJSOP18-Feb-09 2:08
professional#realJSOP18-Feb-09 2:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.