how to get just one record in gridview

[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(); 
}

[davef]

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();
}

If I understand your code correctly, you call the same getEmployee method for displaying all or one Employee. The difference should be the string eld value. Check what's being sent into this method for a single Employee and see what your getEmployee sp should yield in return.

[newbieAl]

If I understand your code correctly, you call the same getEmployee method for displaying all or one Employee. The difference should be the string eld value. Check what's being sent into this method for a single Employee and see what your getEmployee sp should yield in return.

No I have two methods. One for calling all employees and then one for calling one specific employee. This is the one i'm having a problem with as it is returning no records. The sp should return all fields in the record as this is a select * from employees where employeeid= empid;

[davef]

No I have two methods. One for calling all employees and then one for calling one specific employee. This is the one i'm having a problem with as it is returning no records. The sp should return all fields in the record as this is a select * from employees where employeeid= empid;

Do you have a separate sp for each .NET method, too?

[newbieAl]

Do you have a separate sp for each .NET method, too?

Yes, I do have separate methods for each.

[davef]

Yes, I do have separate methods for each.

Did you try to step into the C# code of your single employee select method in debug?

[newbieAl]

Did you try to step into the C# code of your single employee select method in debug?

Yes, but it just runs through the code and nothing happens.

[davef]

Yes, but it just runs through the code and nothing happens.

The select method that you use in the object datasource is void. Make it return a dataset or datatable, then bind to it again.

[prabunewindia]

hi friend,
what davef told is correct.

and one more thing, u used the below one

cmd.ExecuteNonQuery();

this will return the no of rows affected due to ur query, not the details in row.
normally it will be one, if u r getting one employee record

please use the following
SqlDataReader dr = cmd.ExecuteReader();
return dr;

and make the method as Public SqlDataReader ....

Prabu

The select method that you use in the object datasource is void. Make it return a dataset or datatable, then bind to it again.

[newbieAl]

hi friend,
what davef told is correct.

and one more thing, u used the below one

cmd.ExecuteNonQuery();

this will return the no of rows affected due to ur query, not the details in row.
normally it will be one, if u r getting one employee record

please use the following
SqlDataReader dr = cmd.ExecuteReader();
return dr;

and make the method as Public SqlDataReader ....

Prabu

Great, thanks. Is there a good code example that I could follow for dataset and reader?

[prabunewindia]

hi friend,

try with this one

DB_Connection conn = new DB_Connection();
cmd.Connection = (MySqlConnection)conn.DBConnect();
cmd.CommandText = "getEmployee";
cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("EMPLOYEEID", eId); 
DataTable dt = new DataTable();
 SqlDataAdapter da = new SqlDataAdapter(cmd);
  da.Fill(dt);
  return dt;
 

make the method as Public DataTable ...

Prabu

Great, thanks. Is there a good code example that I could follow for dataset and reader?