ASP.NE - Selecting an item from a dropdown listbox control

Question

I have a dropdown listbox whose SQLDataSource connects to an Oracle database from a SQL Server 2005.  Based on the department selection, the query should display all the employees in the selected department.  However, it only list a null value.  The SQL @parameter is not recognized by Oracle but the equivalent search criteria is:
Select * from department
Where department_name LIKE :department_name.
Any help would be greatly appreciated.

Answer 1

Thank you for your valuable reply , i'll  try this solution in my project ..

Answer 2

Hi Can you try this too,

public static string Serialize(object dataToSerialize)     {         if(dataToSerialize==null) return null;          using (StringWriter stringwriter = new System.IO.StringWriter())         {             var serializer = new XmlSerializer(dataToSerialize.GetType());             serializer.Serialize(stringwriter, dataToSerialize);             return stringwriter.ToString();         }     }      public static T Deserialize<T>(string xmlText)     {         if(String.IsNullOrWhiteSpace(xmlText)) return default(T);          using (StringReader stringReader = new System.IO.StringReader(xmlText))         {             var serializer = new XmlSerializer(typeof(T));             return (T)serializer.Deserialize(stringReader);         }     }

Answer 3

Hi Good day,

Suppose I have a collection 

List<Employee> empList = new List<Employee>();

            empList.Add(new Employee() { ID = 1, FName = "John", LName = "Shields", DOB = DateTime.Parse("12/11/1971"), Sex = 'M' });

            empList.Add(new Employee() { ID = 2, FName = "Mary", LName = "Jacobs", DOB = DateTime.Parse("01/17/1961"), Sex = 'F' });

            empList.Add(new Employee() { ID = 3, FName = "Amber", LName = "Agar", DOB = DateTime.Parse("12/23/1971"), Sex = 'M' });

            empList.Add(new Employee() { ID = 4, FName = "Kathy", LName = "Berry", DOB = DateTime.Parse("11/15/1976"), Sex = 'F' });

            empList.Add(new Employee() { ID = 5, FName = "Lena", LName = "Bilton", DOB = DateTime.Parse("05/11/1978"), Sex = 'F' });

            empList.Add(new Employee() { ID = 6, FName = "Susanne", LName = "Buck", DOB = DateTime.Parse("03/7/1965"), Sex = 'F' });

            empList.Add(new Employee() { ID = 7, FName = "Jim", LName = "Brown", DOB =DateTime.Parse("09/11/1972"), Sex = 'M' });

            empList.Add(new Employee() { ID = 8, FName = "Jane", LName = "Hooks", DOB = DateTime.Parse("12/11/1972"), Sex = 'F' });

            empList.Add(new Employee() { ID = 9, FName = "Robert", LName = "", DOB =DateTime.Parse("06/28/1964"), Sex = 'M' });

            empList.Add(new Employee() { ID = 10, FName = "Cindy", LName = "Fox", DOB = DateTime.Parse("01/11/1978"), Sex = 'M' });


Code to convert to xml

var xEle = new XElement("Employees",

                from emp in empList

                select new XElement("Employee",

                             new XAttribute("ID", emp.ID),

                               new XElement("FName", emp.FName),

                               new XElement("LName", emp.LName),

                               new XElement("DOB", emp.DOB),

                               new XElement("Sex", emp.Sex)

                           ));