isDBNull() on two tables

[luna]

how to i use isdbnull on two tables ?

im pulling out the data with a stored procedure like this :-

CREATE PROCEDURE search

@search varchar(8)

AS

Select * from databasel,database2 where database1.ID = @search and
database2.ID = @search

GO

i need to check if a field is null which i do by

If objDR.IsDBNull(1) Then
field1.Text() = ""
Else : field1.Text = objDR("field1")
End If
but how do i do this over two tables ???
cheers
mark

[Tu-Thach]

I am not sure I know what the problem is. IsDBNull works regardless of the number of tables you join

Tu-Thac

----- luna wrote: ----

how to i use isdbnull on two tables

im pulling out the data with a stored procedure like this :

CREATE PROCEDURE searc

@search varchar(8

A

Select * from databasel,database2 where database1.ID = @search an
database2.ID = @searc

G

i need to check if a field is null which i do b

If objDR.IsDBNull(1) The
field1.Text() = "
Else : field1.Text = objDR("field1"
End I
but how do i do this over two tables ??
cheer
mar

[Michael Ramey]

The two tables issue is irrelvant, one select statement, one data source.
Aside from that, what are you trying to accomplish with that sql statement?
I think I know what you are after, a search of many tables for one element,
you may want to look at the UNION operator in sql server.

"luna" <lu**@themoon.com> wrote in message
news:9R***************@newsfep3-gui.server.ntli.net...

how to i use isdbnull on two tables ?

im pulling out the data with a stored procedure like this :-

CREATE PROCEDURE search

@search varchar(8)

AS

Select * from databasel,database2 where database1.ID = @search and
database2.ID = @search

GO

i need to check if a field is null which i do by

If objDR.IsDBNull(1) Then
field1.Text() = ""
Else : field1.Text = objDR("field1")
End If
but how do i do this over two tables ???
cheers
mark

[Shahram Khosraviani]

First, are you retriving this data into a dataset?

If so, then you would have to do something like
If Not DataBinder.Eval(sDataSet, "tables(0).DefaultView.(0).FieldName".Trim) Is System.DBNull.Value The
....
End I

I hope i understood your questions and directed you in the right direction

Regard
Shahra
----- luna wrote: ----

how to i use isdbnull on two tables

im pulling out the data with a stored procedure like this :

CREATE PROCEDURE searc

@search varchar(8

A

Select * from databasel,database2 where database1.ID = @search an
database2.ID = @searc

G

i need to check if a field is null which i do b

If objDR.IsDBNull(1) The
field1.Text() = "
Else : field1.Text = objDR("field1"
End I
but how do i do this over two tables ??
cheer
mar

[Dilip Krishnan]

luna wrote:

how to i use isdbnull on two tables ?

im pulling out the data with a stored procedure like this :-

CREATE PROCEDURE search

@search varchar(8)

AS

Select * from databasel,database2 where database1.ID = @search and
database2.ID = @search

GO

i need to check if a field is null which i do by

If objDR.IsDBNull(1) Then
field1.Text() = ""
Else : field1.Text = objDR("field1")
End If
but how do i do this over two tables ???
cheers
mark

Mark,
If I understand correctly yr having problems cos' the field names
are the same name. The datareader doesnt care if you have 1 or n tables,
all it gets to see are the fields that are in the collection. I think
you should be fine if you alias the fields.
--
Regards,
Dilip Krishnan
dilip removethis @ msn.com

[luna]

thanks for the suggestions

im basically pulling out all the data from two tables and populating a form
i thought i could retrieve all the data with one while / end while block
but currently i have to use 2 - i was trying to tighten up the code by
pulling out both sets of data in the same while/ end while
i was asking about isdbnull() as im having to use the ordinal number -
im not sure of the ordinal number for the second set of data ? - or does it
just follow on ?