Click here to Skip to main content
15,905,867 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: window dll in web solution ? Pin
Sathesh Sakthivel20-Jul-07 0:03
Sathesh Sakthivel20-Jul-07 0:03 
GeneralRe: window dll in web solution ? Pin
Piyush Vardhan Singh20-Jul-07 0:14
Piyush Vardhan Singh20-Jul-07 0:14 
GeneralRe: window dll in web solution ? Pin
Piyush Vardhan Singh20-Jul-07 0:27
Piyush Vardhan Singh20-Jul-07 0:27 
GeneralRe: window dll in web solution ? Pin
Sonia Gupta20-Jul-07 0:49
Sonia Gupta20-Jul-07 0:49 
GeneralRe: window dll in web solution ? Pin
Piyush Vardhan Singh20-Jul-07 0:57
Piyush Vardhan Singh20-Jul-07 0:57 
GeneralRe: window dll in web solution ? Pin
Sonia Gupta20-Jul-07 1:03
Sonia Gupta20-Jul-07 1:03 
AnswerRe: window dll in web solution ? Pin
N a v a n e e t h20-Jul-07 0:04
N a v a n e e t h20-Jul-07 0:04 
QuestionError in retrieving data using JOINS Pin
n_gchaitra19-Jul-07 23:33
n_gchaitra19-Jul-07 23:33 
hi, I have written the following code to retrieve a value from two table using joins. but i am getting the error code near dr1.Item("m2.fname")

Cant we use the joins here? if so how to get a value from two tabl?

Sub bindsup(ByVal empcode As String)

Dim sqlstr1 As String
Dim dr1 As SqlDataReader
sqlstr1 = "SELECT M2.fname from T_emp_mstr M1,T_emp_mstr M2 where m1.Reportto=m2.Empcode AND M1.Empcode='" & Txtempno.Text & "'"
Dim comm1 As New SqlCommand(sqlstr1, dbconnhr)
If dbconnhr.State <> Data.ConnectionState.Open Then
dbconnhr.Open()
End If
dr1 = comm1.ExecuteReader
While dr1.Read
If IsDBNull(dr1.Item("m2.fname")) Then
Txtsup.Text = ""
Else
Txtsup.Text = dr1.Item("m2.fname")
End If
End While
dr1.Close()
End Sub

Chaitra N

AnswerRe: Error in retrieving data using JOINS Pin
Imran Khan Pathan19-Jul-07 23:40
Imran Khan Pathan19-Jul-07 23:40 
GeneralRe: Error in retrieving data using JOINS Pin
n_gchaitra20-Jul-07 0:53
n_gchaitra20-Jul-07 0:53 
GeneralRe: Error in retrieving data using JOINS Pin
n_gchaitra20-Jul-07 1:00
n_gchaitra20-Jul-07 1:00 
AnswerRe: Error in retrieving data using JOINS Pin
Paddy Boyd19-Jul-07 23:43
Paddy Boyd19-Jul-07 23:43 
GeneralRe: Error in retrieving data using JOINS Pin
n_gchaitra20-Jul-07 0:57
n_gchaitra20-Jul-07 0:57 
AnswerRe: Error in retrieving data using JOINS Pin
Imran Khan Pathan19-Jul-07 23:45
Imran Khan Pathan19-Jul-07 23:45 
GeneralRe: Error in retrieving data using JOINS Pin
n_gchaitra20-Jul-07 0:58
n_gchaitra20-Jul-07 0:58 
AnswerRe: Error in retrieving data using JOINS Pin
Sathesh Sakthivel19-Jul-07 23:47
Sathesh Sakthivel19-Jul-07 23:47 
GeneralRe: Error in retrieving data using JOINS Pin
n_gchaitra20-Jul-07 0:59
n_gchaitra20-Jul-07 0:59 
Questionanybody know Something @ UnauthorisedAccessException? Pin
Amit.Amit.Amit...19-Jul-07 23:20
Amit.Amit.Amit...19-Jul-07 23:20 
AnswerRe: anybody know Something @ UnauthorisedAccessException? Pin
Paddy Boyd20-Jul-07 0:03
Paddy Boyd20-Jul-07 0:03 
AnswerRe: anybody know Something @ UnauthorisedAccessException? Pin
N a v a n e e t h20-Jul-07 0:06
N a v a n e e t h20-Jul-07 0:06 
QuestionRe: anybody know Something @ UnauthorisedAccessException? Pin
Amit.Amit.Amit...21-Jul-07 0:29
Amit.Amit.Amit...21-Jul-07 0:29 
QuestionI have 2 type user.how can I create a login page? Pin
mehran.asg19-Jul-07 22:36
mehran.asg19-Jul-07 22:36 
AnswerRe: I have 2 type user.how can I create a login page? Pin
Amit.Amit.Amit...19-Jul-07 23:38
Amit.Amit.Amit...19-Jul-07 23:38 
AnswerRe: I have 2 type user.how can I create a login page? Pin
aditya_asv22-Jul-07 16:22
aditya_asv22-Jul-07 16:22 
Questionweb user control. Pin
Sonia Gupta19-Jul-07 22:24
Sonia Gupta19-Jul-07 22:24 

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.