How can I use GridView or DetailsView to Bind to a DataSet

[masoumeh]

I use this code

SqlDataSource1.SelectParameters.Add("F_Employer", TypeCode.String, _ txtSearch.Text)
SqlDataSource1.SelectCommand = "ALLV_Employer"

but I recive this error in the execution time

System.Data.SqlClient.SqlException: Procedure or Function 'ALLV_Employer' expects parameter '@F_Employer', which was not supplied.

Please help me.

[khamoshe]

I use this code

SqlDataSource1.SelectParameters.Add("F_Employer", TypeCode.String, _ txtSearch.Text)
SqlDataSource1.SelectCommand = "ALLV_Employer"

but I recive this error in the execution time

System.Data.SqlClient.SqlException: Procedure or Function 'ALLV_Employer' expects parameter '@F_Employer', which was not supplied.

Please help me.

plz would u like to tell the version u r using of .net

[ssmeshack]

plz would u like to tell the version u r using of .net

Hi,

I also having the same problem.
Here is the code im using. Im using hyperlink in gridview to get the data to update form.
im using .net 2008 with c#.

please anyone can help me?

SqlConnection conn = new SqlConnection("Data Source=MIS_HP;Initial Catalog=DBhelpdesk;User ID=sa;Password=sapassword");
        conn.Open();
        SqlCommand comm = new SqlCommand("SelectUserByStaffID", conn);
        comm.CommandType = CommandType.StoredProcedure;
 
        comm.Parameters.AddWithValue("@StaffID", Request.QueryString["StaffID"]);
        SqlDataReader rdr2 = comm.ExecuteReader();
 
        while (rdr2.Read() && !rdr2.IsDBNull(0))
        {
            tbUserID.Text = Convert.ToString(rdr2["StaffID"]);
            tbFullName.Text = (string)rdr2["StaffFullName"];
            tbName.Text = (string)rdr2["StaffName"];
            tbPassword.Text = (string)rdr2["StaffPassword"];
            ddlLevel.Text = (string)rdr2["StaffLevel"];
            rbAutoAssign.SelectedValue = Convert.ToString(rdr2["AutoRotation"]);
            tbEmail.Text = (string)rdr2["StaffEmail"];
        }
        rdr2.Close();
        conn.Close();

Regards,
Meshack