publicDataTable RetrieveFilterPerson(string PersonSearched)
{
DataTable DT = newDataTable();
SqlConnection Conn = PublicClass.OpenConnection();
Conn.Open();
SqlDataAdapter MyCommand = newSqlDataAdapter("SELECT * FROM Persons WHERE PersonName Like @PersonSearched or PersonCode Like @PersonSearched order by PersonID DESC", Conn);
MyCommand.SelectCommand.Parameters.AddWithValue("@PersonSearched", "%"+PersonSearched+"%");
MyCommand.Fill(DT);
Conn.Close();
return DT;
}
[RTL]
اینجوری خوبه مهندس؟؟
[/RTL]