FindByPrimaryKe y(keyID) returns null

[Nime]

I use a dataset and autogenerated logic codes.
VS2005 generated FindByPrimaryKe y method but the method
returns null instead of the related row even ý use a valid key.
The lines are below:

//DataTable
DataSetOrganiza syon.tableGeziD ataTable tblGeziDT = new
DataSetOrganiza syon.tblGeziDat aTable();

//DataTableAdapte r
DataSetOrganiza syonTableAdapte rs.tblGeziTable Adapter tblGeziTA = new
Organizasyon.st rDataSetOrganiz asyonTableAdapt ers.tblGeziTabl eAdapter();

tblGeziRow = tblGeziDT.FindB ygeziID(intAkti fOrganizasyonID );

Now I cannot load the data...

Autogenerated lines are below:
[System.Diagnost ics.DebuggerNon UserCodeAttribu te()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(t his.NewRow()));
}

[Nime]

I think it doesn't attemp to read the row from the DB and just load the data
from
datatable object..... And I should load the data from the sql server...

"Nime" <ni**@yes.no> , haber iletisinde þunlarý
yazdý:OO******* *******@TK2MSFT NGP02.phx.gbl.. .

>I use a dataset and autogenerated logic codes.
VS2005 generated FindByPrimaryKe y method but the method
returns null instead of the related row even ý use a valid key.
The lines are below:

//DataTable
DataSetOrganiza syon.tableGeziD ataTable tblGeziDT = new
DataSetOrganiza syon.tblGeziDat aTable();

//DataTableAdapte r
DataSetOrganiza syonTableAdapte rs.tblGeziTable Adapter tblGeziTA = new
Organizasyon.st rDataSetOrganiz asyonTableAdapt ers.tblGeziTabl eAdapter();

tblGeziRow = tblGeziDT.FindB ygeziID(intAkti fOrganizasyonID );

Now I cannot load the data...

Autogenerated lines are below:
[System.Diagnost ics.DebuggerNon UserCodeAttribu te()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(t his.NewRow()));
}

[Nime]

Related sample is here:
http://msdn2.microsoft.com/en-us/lib...h1(vs.80).aspx

I'm not sure hot to load the data by primary key...

"Nime" <ni**@yes.no> , haber iletisinde þunlarý
yazdý:%2******* *********@TK2MS FTNGP06.phx.gbl ...

>I think it doesn't attemp to read the row from the DB and just load the
data from
datatable object..... And I should load the data from the sql server...

"Nime" <ni**@yes.no> , haber iletisinde þunlarý
yazdý:OO******* *******@TK2MSFT NGP02.phx.gbl.. .

>>I use a dataset and autogenerated logic codes.
VS2005 generated FindByPrimaryKe y method but the method
returns null instead of the related row even ý use a valid key.
The lines are below:

//DataTable
DataSetOrganiz asyon.tableGezi DataTable tblGeziDT = new
DataSetOrganiz asyon.tblGeziDa taTable();

//DataTableAdapte r
DataSetOrganiz asyonTableAdapt ers.tblGeziTabl eAdapter tblGeziTA = new

Organizasyon.s trDataSetOrgani zasyonTableAdap ters.tblGeziTab leAdapter();

tblGeziRow = tblGeziDT.FindB ygeziID(intAkti fOrganizasyonID );

Now I cannot load the data...

Autogenerate d lines are below:
[System.Diagnost ics.DebuggerNon UserCodeAttribu te()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(t his.NewRow()));
}

[Nicholas Paldino [.NET/C# MVP]]

Nime,

Well, you are calling FindBygezID on an empty data table. You need to
use the data adapter you created to populate the data table, or add rows
yourself.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Nime" <ni**@yes.nowro te in message
news:OO******** ******@TK2MSFTN GP02.phx.gbl...

>I use a dataset and autogenerated logic codes.
VS2005 generated FindByPrimaryKe y method but the method
returns null instead of the related row even ý use a valid key.
The lines are below:

//DataTable
DataSetOrganiza syon.tableGeziD ataTable tblGeziDT = new
DataSetOrganiza syon.tblGeziDat aTable();

//DataTableAdapte r
DataSetOrganiza syonTableAdapte rs.tblGeziTable Adapter tblGeziTA = new
Organizasyon.st rDataSetOrganiz asyonTableAdapt ers.tblGeziTabl eAdapter();

tblGeziRow = tblGeziDT.FindB ygeziID(intAkti fOrganizasyonID );

Now I cannot load the data...

Autogenerated lines are below:
[System.Diagnost ics.DebuggerNon UserCodeAttribu te()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(t his.NewRow()));
}

[Nime]

THANK YOU A LOT : ) NOW I CAN SEE THE ROW!
tblGeziTA.Fill( tblGeziDT); //I'VE ADDED THIS LINE

tblGeziRow = tblGeziDT.FindB ygeziID(intAkti fOrganizasyonID );

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om>, haber
iletisinde þunlarý yazdý:%2******* *********@TK2MS FTNGP03.phx.gbl ...

Nime,

Well, you are calling FindBygezID on an empty data table. You need to
use the data adapter you created to populate the data table, or add rows
yourself.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Nime" <ni**@yes.nowro te in message
news:OO******** ******@TK2MSFTN GP02.phx.gbl...

>>I use a dataset and autogenerated logic codes.
VS2005 generated FindByPrimaryKe y method but the method
returns null instead of the related row even ý use a valid key.
The lines are below:

//DataTable
DataSetOrganiz asyon.tableGezi DataTable tblGeziDT = new
DataSetOrganiz asyon.tblGeziDa taTable();

//DataTableAdapte r
DataSetOrganiz asyonTableAdapt ers.tblGeziTabl eAdapter tblGeziTA = new

Organizasyon.s trDataSetOrgani zasyonTableAdap ters.tblGeziTab leAdapter();

tblGeziRow = tblGeziDT.FindB ygeziID(intAkti fOrganizasyonID );

Now I cannot load the data...

Autogenerate d lines are below:
[System.Diagnost ics.DebuggerNon UserCodeAttribu te()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(t his.NewRow()));
}