Author: tl01621 | Posted on: 3/3/2009 5:53:17 AM | Views : 232

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 ...