FindByPrimaryKey(keyID) returns null

[Nime]

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

//DataTable
DataSetOrganizasyon.tableGeziDataTable tblGeziDT = new
DataSetOrganizasyon.tblGeziDataTable();

//DataTableAdapter
DataSetOrganizasyonTableAdapters.tblGeziTableAdapter tblGeziTA = new
Organizasyon.strDataSetOrganizasyonTableAdapters.tblGeziTableAdapter();

tblGeziRow = tblGeziDT.FindBygeziID(intAktifOrganizasyonID);

Now I cannot load the data...

Autogenerated lines are below:
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(this.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]

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

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

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...

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

//DataTable
DataSetOrganizasyon.tableGeziDataTable tblGeziDT = new
DataSetOrganizasyon.tblGeziDataTable();

//DataTableAdapter
DataSetOrganizasyonTableAdapters.tblGeziTableAdapter tblGeziTA = new

Organizasyon.strDataSetOrganizasyonTableAdapters.tblGeziTableAdapter();

tblGeziRow = tblGeziDT.FindBygeziID(intAktifOrganizasyonID);

Now I cannot load the data...

Autogenerated lines are below:
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(this.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.

 

[Nime]

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

tblGeziRow = tblGeziDT.FindBygeziID(intAktifOrganizasyonID);

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]
- (e-mail address removed)

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

//DataTable
DataSetOrganizasyon.tableGeziDataTable tblGeziDT = new
DataSetOrganizasyon.tblGeziDataTable();

//DataTableAdapter
DataSetOrganizasyonTableAdapters.tblGeziTableAdapter tblGeziTA = new

Organizasyon.strDataSetOrganizasyonTableAdapters.tblGeziTableAdapter();

tblGeziRow = tblGeziDT.FindBygeziID(intAktifOrganizasyonID);

Now I cannot load the data...

Autogenerated lines are below:
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public tblGeziRow NewtblGeziRow() {
return ((tblGeziRow)(this.NewRow()));
}