SQLquery Using Parameter Help Needed Please C#???

Hi All,





I'm trying to pass in a parameter value from an array in a loop that is used in a sql query and the results are populated to an xml file. The trouble is that I'm only getting the colums values in the outputted xml file. So I feel that the paramter is not being read.





So can anyone help as I'm really stuck on this one. The code is as follows :





public void DisplayUserInfo()


{





ArrayList UserIdArrayList = IdentifyUserID();


foreach(string ShowUserIDString in UserIdArrayList)


{


try


{


SqlConnection SqlConn = new SqlConnection(DBConnString);


SqlConn.Open();


Console.WriteLine("Connected to DB");


SqlDataAdapter SqlAD = new SqlDataAdapter();


SqlAD.SelectCommand = new SqlCommand("Select * from UserSystemSpecs where UserName ='+ShowUserIDString.ToString()+'",SqlConn);


DataSet ds = new DataSet();


SqlAD.Fill(ds);


ds.WriteXml(".\ResultsXML.xml", XmlWriteMode.WriteSchema);


}





catch (Exception ex)


{


throw new Exception ("Error Connecting to DB. " + ex.Message);


}


//SqlConn.Close();








}





}








Thanks





Garry