"Gis" wrote:

> Hi,
> I'm using a data adapter daReadAdmin which is delcared like this:
>
> SqlDataAdapter daReadAdmin = new SqlDataAdapter("p_ReadAdmin",
> strConnection);
>
> Where p_ReadAdmin is a parametrized Stored procedure in SQL Server then the
> following code states:
>
> daReadAdmin.SelectCommand.CommandText = "p_ReadAdmin";
> daReadAdmin.SelectCommand.CommandType = CommandType.StoredProcedure;
>
> After this i set the parameters:
>
> daTimeRecording.SelectCommand.Parameters.Add("@EmployeeID",
> SqlDbType.UniqueIdentifier,0,cboName.SelectedValue.ToString());
> daReadAdmin.SelectCommand.Parameters.Add("@TRDate", dtpDate.Value);
>
> Then the DataSet must be filled:
> daReadAdmin.Fill(dsReadAdmin, "p_ReadAdmin");
>
> Then use a DataView:
> dvdgTimeRecording = new DataView(dsReadAdmin.Tables["p_ReadAdmin"]);
> dgTimeRecording.DataSource = dvdgTimeRecording;
>
> The Result..: "An unhandled exception of type
> 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional
> information: System error."
> the exception shows on the line "daReadAdmin.Fill(dsReadAdmin,
> "p_ReadAdmin");
>
> I think the problem is on passing parameter for @EmployeeID which should be
> given by cboName.SelectedValue. EmployeeID is a GUID. If I modify the sp on
> SQL to recieve only @TRDate as parameter then everything works fine. How
> should I add the GUID Parameter?