Jump to content

pansy

Members
  • Posts

    3
  • Joined

  • Last visited

Reputation

0 Neutral

About pansy

  1. i have text box and dropdownlist , i bind dropdownlist values to this text box , but i have to clock enter twice to show a result , so i don't know where i should write my code ?
  2. i solved by removing the cmd.parameters.add to addvalue and it's works Thank you
  3. the problem is here public static List GetClientByStaffId(string STAFF_CL) { List clients = new List(); SqlCommand selectCmd = new SqlCommand("select * from TRS_LUT_CLIENT C, TRS_TASKS T where C.CLIENT_ID = T.CLIENT_ID and T.STAFF_CL = @ STAFF_CL"); selectCmd.Parameters.Add("STAFF_CL", SqlDbType.NVarChar).Value = STAFF_CL; DataTable dt = DBManager.ExecuteQuery(selectCmd); foreach (DataRow row in dt.Rows) { clients.Add(new TRS_LUT_CLIENTS(int.Parse(dt.Rows[0]["CLIENT_ID"].ToString()), dt.Rows[0]["CLIENT_NAME"].ToString(), dt.Rows[0]["CLIENT_ADDRESS"].ToString(), dt.Rows[0]["CLIENT_DESCRIPTION"].ToString())); } return clients; } i can't c it at all !! i thought that it may be the parameters.add . but what exactly i don't know !!
×
×
  • Create New...