i fixed my final issue, had to do with what i named the textfield and valuefields....they didnt match up with what i was trying to pull with my SP. Thanks for all of your help!

so i fixed the issue i was having before, now the page loads but in the ddl all it displays is System.Data.DataRowView

code behind:

WebDropDown1.DataSource =

dataAccess .getEmployees();

WebDropDown1.TextField =

"Craftsperson" ;

WebDropDown1.ValueField =

"Craftsperson" ;

WebDropDown1.DataBind();

aspx:

your thoughts?

so i fixed the issue i was having before, now the page loads but in the ddl all it displays is System.Data.DataRowView

code behind:

WebDropDown1.DataSource =

dataAccess .getEmployees();

WebDropDown1.TextField =

"Craftsperson" ;

WebDropDown1.ValueField =

"Craftsperson" ;

WebDropDown1.DataBind();

aspx:

your thoughts?

Hello,

Your code looks fine. I noticied you are using dbo.spGetEmployees in your command and r1.dbo.database in your stored procedure, the error may have to do with how you are connecting to your database or database server. If your connection string does not specify the specific database then you may need to call your stored procedure as r1.dbo.spGetEmployees.

Valerie

I am still having a bit of trouble getting this all figure out. I tried developing the dataset you mentioned inside my dataAccess.cs file, here is what i came up with:

    #region getEmployees()
    /// <summary>
    /// getEmployees()
    /// </summary>
    /// <returns></returns>
    public static DataSet getEmployees()
    {

        SqlConnection connection = null;
        try
        {
            connection = new SqlConnection(utilities.getConnectionString());
            SqlCommand command = new SqlCommand("dbo.spGetEmployees", connection);
            command.CommandType = CommandType.StoredProcedure;

            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataSet dsEmployees = new DataSet();
            adapter.Fill(dsEmployees, "fullname");

            connection.Open();
            return dsEmployees;
        }
        catch
        {
            if (connection != null)
                connection.Close();
            throw;
        }
    }
    #endregion

when i try to load the site i get a Cannot find the object 'spGetEmployees', because it does not exist or you do not have permission. i am not sure why it does this because i left the connection part of the code alone. Here is my SP, im not sure if that will help at all, it selects the id of the person and combines there first, last, middle names together.

SELECT user_id ,
ced_pref_sur + ', ' + ced_pref_giv + ' ' + ced_pref_mi AS fullname
FROM r1.dbo.database (NOLOCK)
ORDER BY fullname

I know this piece of code works correctly, i am worried that since the statement is selecting two values something is happening when the dataset is being loaded, but ultimately i am not sure (i have never used a dataSet before, im rather new to this)

Thanks again!