Hi friends
I want to fill DataSet with Store Procedure.but when i have run my project i get this error:
Error converting data type nvarchar to date.
1- Do i have to
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = new SqlCommand();
adp.SelectCommand.Connection = con;
adp.SelectCommand.CommandText = "Report";
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet set = new DataSet();
DataTable dtbl = new DataTable("DataTable1");
adp.SelectCommand.Parameters.AddWithValue("@clrk_Name", txtNameReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_Family",txtFamilyReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_MelliCode",txtMelliCodeReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@AzTarikh",txtMelliCodeReport.Text);
adp.SelectCommand.Parameters.AddWithValue("@Ela", txtElaReport.Text);
adp.Fill(set, "DataTable1");
ReportDataSource source = new ReportDataSource ("datatable1",dtbl );
reportViewer1.Visible = true;
reportViewer1.LocalReport.ReportPath = "report1.rdlc";
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(source);
reportViewer1.LocalReport.Refresh();
STORE PROCEDURE
USE [ClerksEvaluation]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Report]
@clrk_Name Nvarchar(50),
@clrk_Family Nvarchar(60),
@clrk_MelliCode Char(10),
@AzTarikh Date,
@Ela Date
AS
Declare @id int
select @id = clrk_Id from Clerk
where clrk_Name = @clrk_Name and clrk_Family = @clrk_Family and clrk_MelliCode = @clrk_MelliCode
select clrk_Name,clrk_Family,clrk_MelliCode,clrk_FatherName, epcnt_Name, clrke_Percent, clrke_Tozihat, clrke_Date, clrke_Hafteh
from ClerkEvaluation
inner join Clerk on Clerk.clrk_Id = @id
inner join EvaluationPercent on ClerkEvaluation.epcnt_Id = EvaluationPercent.epcnt_Id
where clrke_Date Between @AzTarikh and @Ela
//i get date from this line but dataset can't fill data kind of date.I don't know where i should use convert?
how can i put a date into dataset?
[Edit]Code blocks added[/Edit]