I can not find fault.please help me
Additional information: Object reference not set to an instance of an object
-----------------------------------------------
public static ENOTLAR Select(ENOTLAR item)
{
try
{
SqlCommand com = new SqlCommand("NOTLAR_SonKayit", Baglanti.Con);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("ID", item.ID);
SqlDataReader rdr = com.ExecuteReader();
while (rdr.Read())
{
item = new ENOTLAR();
item.ID = Convert.ToInt32(rdr["ID"]);
item.KONU = rdr["KONU"].ToString();
item.TARIH = Convert.ToDateTime(rdr["TARIH"]);
item.YAZI = rdr["YAZI"].ToString();
}
rdr.Close();
}
catch
{
item = null;
}
return item;
}
-------------- ---------------private void LastNot()
{
ENOTLAR not = new ENOTLAR();
BLLNOTLAR.Skayit(not);
toolStripLabel3.Text = not.YAZI.ToString();
}
-------------------------- sql procedure
NOTLAR_SonKayit
CREATE PROC NOTLAR_SonKayit
AS
SELECT TOP 1 YAZI FROM NOTLAR
ORDER BY ID DESC;
Umut çelikPosted Apr 14, 2016, 4:15 AM
Nishant MittalPosted Apr 14, 2016, 4:02 AM
Umut çelikPosted Apr 14, 2016, 3:58 AM
Nishant MittalPosted Apr 14, 2016, 3:52 AM
Nishant MittalPosted Apr 14, 2016, 3:51 AM
Umut çelikPosted Apr 14, 2016, 3:48 AM
Nishant MittalPosted Apr 14, 2016, 3:44 AM