Click here to Skip to main content
15,397,264 members
Home / Discussions / Database
   

Database

 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz3-Jul-08 1:09
Memberrrrriiizz3-Jul-08 1:09 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
Mycroft Holmes4-Jul-08 0:26
professionalMycroft Holmes4-Jul-08 0:26 
GeneralRe: Stored Procedure or Trigger for Autogenerate Colunm Pin
rrrriiizz5-Jul-08 1:35
Memberrrrriiizz5-Jul-08 1:35 
QuestionTrigger with Time Pin
obarahmeh2-Jul-08 20:08
Memberobarahmeh2-Jul-08 20:08 
AnswerRe: Trigger with Time Pin
Mycroft Holmes2-Jul-08 21:00
professionalMycroft Holmes2-Jul-08 21:00 
GeneralRe: Trigger with Time Pin
obarahmeh2-Jul-08 22:50
Memberobarahmeh2-Jul-08 22:50 
QuestionsqlDataReader Execution in a Function Pin
IlseBrase2-Jul-08 18:29
MemberIlseBrase2-Jul-08 18:29 
AnswerRe: sqlDataReader Execution in a Function Pin
Vimalsoft(Pty) Ltd3-Jul-08 4:03
professionalVimalsoft(Pty) Ltd3-Jul-08 4:03 
Firstly you should post this in vb Forum,

Secondly your Code is messy, it seems you dont know where to put your code. You are Executing the command outside your connection. Open the Connection and Execute your command and Close the Connection and Close the reader and after that you dont need to loop through the reader. Here is my Suggestion, why dont you use a StoredProcedure that returns number of rows ,and when you call that Stored Procedure you will test for records that are returned. if you planned it well you will be looking for an integer that is "1" or less than one , e.g

C#
if(intTeturned < 1)
{
   //Invalid Login
}
else
{
//Valid Login , then you can redirect your users to the page you want.
}
}


Hope this Helps

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za


QuestionSQL image data Pin
nelsonpaixao2-Jul-08 14:02
Membernelsonpaixao2-Jul-08 14:02 
AnswerRe: SQL image data Pin
Giorgi Dalakishvili2-Jul-08 21:58
mentorGiorgi Dalakishvili2-Jul-08 21:58 
AnswerRe: SQL image data Pin
Hesham Amin2-Jul-08 22:08
MemberHesham Amin2-Jul-08 22:08 
QuestionConnection-string [modified] Pin
nelsonpaixao2-Jul-08 13:59
Membernelsonpaixao2-Jul-08 13:59 
AnswerRe: Connection-string Pin
rrrriiizz2-Jul-08 19:31
Memberrrrriiizz2-Jul-08 19:31 
GeneralRe: Connection-string Pin
Mycroft Holmes2-Jul-08 21:12
professionalMycroft Holmes2-Jul-08 21:12 
QuestionOracle instant client Pin
Muammar©2-Jul-08 1:00
Member Muammar©2-Jul-08 1:00 
QuestionFinaly I Found it. Compare and synchronize SQL Server database structures and data. Pin
dingoishere2-Jul-08 0:12
Memberdingoishere2-Jul-08 0:12 
AnswerRe: Finaly I Found it. Compare and synchronize SQL Server database structures and data. Pin
Syed Mehroz Alam2-Jul-08 18:44
MemberSyed Mehroz Alam2-Jul-08 18:44 
QuestionPerformance Issue Pin
sujithkumarsl1-Jul-08 19:43
Membersujithkumarsl1-Jul-08 19:43 
AnswerRe: Performance Issue Pin
Paul Conrad1-Jul-08 20:03
professionalPaul Conrad1-Jul-08 20:03 
GeneralRe: Performance Issue Pin
sujithkumarsl1-Jul-08 20:24
Membersujithkumarsl1-Jul-08 20:24 
AnswerRe: Performance Issue Pin
N a v a n e e t h1-Jul-08 20:36
MemberN a v a n e e t h1-Jul-08 20:36 
GeneralRe: Performance Issue Pin
sujithkumarsl1-Jul-08 22:04
Membersujithkumarsl1-Jul-08 22:04 
GeneralRe: Performance Issue Pin
N a v a n e e t h1-Jul-08 22:51
MemberN a v a n e e t h1-Jul-08 22:51 
GeneralRe: Performance Issue Pin
sujithkumarsl1-Jul-08 23:12
Membersujithkumarsl1-Jul-08 23:12 
GeneralRe: Performance Issue Pin
TheFM2342-Jul-08 4:37
MemberTheFM2342-Jul-08 4:37 

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.