Hi everyone im trying cascading dropdown example for the first time but im gettin the execption
The multi-part identifier "h.DoktorNo" could not be bound.
The multi-part identifier "h.HastaNo" could not be bound.
The multi-part identifier "h.Adi" could not be bound.
my code like this i wonder my mistake because of the code or i made a mistake while modeling db couldy you help plase
void FillHasta(int id)
{
string strConn = "server=.\\sqlexpress;database=Hastahane ;integrated Security=sspi";
SqlConnection con = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select h.HastaNo,h.Adi,d.DoktorNo from Hastalar inner join Doktorlar d on h.DoktorNo=d.DoktorNo";
cmd.Parameters.AddWithValue("@id", id);
DataSet objDs = new DataSet();
SqlDataA ...
Go to the complete details ...