将DateTimePicker值传递给c#存储过程

本文关键字：存储过程 DateTimePicker 值传 | 更新日期: 2023-09-27 18:02:51

我有DataGridView和DateTimePicker，我想根据DateTimePicker的值显示DataGridView中的数据。

下面是存储过程: 
create proc Get_Employers_All_Day
    @Date_Day date
as 
SELECT 
    [Employer_ID] as 'رقم الموظف'
    , Employer_Name as 'اسم الموظف'
FROM [dbo].[Come_Out]
inner join Employers 
    on Employers .Epmloyer_ID = Come_Out .Employer_ID 
where 
    Come_Out .Status = '2'
     and Come_Out .Data_Come_Out = @Date_Day
下面是c#代码: 
public void Get_Employers_All_Day(DateTime Date_Day)
{
    DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
    DAL.Open();
    SqlParameter[] param = new SqlParameter[1];
    param[0] = new SqlParameter("@Date_Day", SqlDbType.DateTime);
    param[0].Value = Date_Day;
    DAL.ExecuteCommand("Get_Employers_All_Day", param);
    DAL.Close();
}

和事件:

private void Frm_Daily_Come_Out_Load(object sender, EventArgs e)
{
    BL.Employers emp = new BL.Employers();
    dataGridView1.DataSource = emp.Get_Employers_All_Day(dateTimePicker1 .Value );
}

错误是:

不能隐式地将"void"类型转换为"object"类型

将DateTimePicker值传递给c#存储过程

您的Get_Employers_All_Day()方法有一个返回类型void，这意味着它没有返回类型。

修改它以返回所需的数据。例如，如果您的DAL.ExecuteCommand()返回DataTable，则修改它以返回:

public DataTable Get_Employers_All_Day(DateTime Date_Day)
{
    ...
    ...
    DataTable result;
    try
    {
        result = DAL.ExecuteCommand("Get_Employers_All_Day", param);
    }
    finally
    {
        // Even if ExecuteCommand() fails, close any open connections
        DAL.Close();
    }
    return result;
}
相关文章：