how to display one filtered record in gridview (ASP .NET & C#)

[newbieAl]

I have a stored procedure in mysql and I am calling it via a method and objectdatasource. I have two select methods. One that gets a list of employees and the other that gets one specific employee by passing the employee id via a parameter.

I have two gridviews, one for displaying all employees and one for displaying one employee record. The user should be able to enter the employee id in the textbox and the gridview should display the employee's record. My code is working for displaying all employees but not for displaying one specific employee. The code compiles but does not display any info. Here is my code:

<asp:objectdatasource id="ObData2" runat="server" dataobjecttypename="EmpData" typename="Employee" selectmethod="getEmployee" ><selectparameters>asp:controlparameter controlid="employeeid" name="eId" propertyname="text" type="string" /></selectparameters>
 

<asp:gridview id="GridView2" action="databind" runat="server" datasourceid="ObData2"datakeynames="EmployeeID" allowpaging="True" autogenerateeditbutton="True" autogeneratecolumns="True"emptydatatext="No Records"   allowsorting="True"  > 
 

[DataObjectMethod(DataObjectMethodType.Select)]        
public void getEmployee(string eId)       
 {            
MySqlCommand cmd = new MySqlCommand();            
try           
 {                
    DB_Connection conn = new DB_Connection();                
    cmd.Connection = (MySqlConnection)conn.DBConnect();                        
    cmd.CommandText = "getEmployee";                
    cmd.CommandType = CommandType.StoredProcedure;                    
    cmd.Parameters.Add("EMPLOYEEID", eId);                
    cmd.ExecuteNonQuery();                            
}

[jhardman]

moved to .NET forum

[nateraaaa]

Have your tried using the debugger to find out why no records are displayed?

Nathan

[Frinavale]

Double check that your stored procedure is returning the data.
(Double check that it works...maybe using Query Analyzer or something)

-Frinny