Hi
Here's what I have so far;
I have a dropdownlist that is binded to a stored procedure which just returns a column called dir
The 'dir' column holds the directory location of some files for example;
c:\program files\myprogram\mytestfile.txt
c:\program files\adifferentlocation\file1.txt
c:\program files\adifferentlocation\file2.txt
c:\program files\adifferentlocation\file3.txt
d:\location3\anotherfile.txt
Now this all gets populated in the dropdownlist just fine using the below c# code;
private void GetDirectoryList()
{
SqlConnection conn2 = new SqlConnection("Data Source=.; database=mydb; integrated security=TRUE");
SqlCommand command2 = new SqlCommand("mystoredprocedure", conn2);
try
{
command2.CommandType = CommandType.StoredProcedure;
conn2.Open();
SqlDataAdapter adapter2 = new SqlDataAdaptor(command2);
DataTable dt2 = new DataTable();
...
Go to the complete details ...