.NET CF extremely buggy!

TheMSsForum.com: The Microsoft Software Forum

cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))

cmd.Parameters["@cDateReg"].Value =
Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString();
cmd.Parameters["@cDate"].Value =
Convert.ToDateTime(cDate_tb.Text).ToShortDateString();

Error Code: 80020005
Message: Data conversion failed. [OLE DB status value,,,,,,]

This is typical of the crap I am going through at the moment! If it works in
one instance why won't it work in another??

SSP
Top

Re: .NET CF extremely buggy! by Chris

Chris
Sun Feb 08 06:55:27 CST 2004

Do cDateReg_tb and cDate_tb hold the same value? What values doe they
contain?

-Chris


"SSP" <ssp@dt.com> wrote in message
news:up9EPIh7DHA.3432@TK2MSFTNGP11.phx.gbl...
> cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
>
> cmd.Parameters["@cDateReg"].Value =
> Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString();
> cmd.Parameters["@cDate"].Value =
> Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
>
> Error Code: 80020005
> Message: Data conversion failed. [OLE DB status value,,,,,,]
>
> This is typical of the crap I am going through at the moment! If it works
in
> one instance why won't it work in another??
>
> SSP
>
>


Top

Re: .NET CF extremely buggy! by Alex

Alex
Sun Feb 08 14:30:17 CST 2004

Why are you converting this to string before setting the param value?

What happens if you do this:

cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))

cmd.Parameters["@cDateReg"].Value = DateTime.Parse(cDateReg_tb.Text).Date;
cmd.Parameters["@cDate"].Value = DateTime.Parse(cDate_tb.Text).Date;

How is your table declared?

"SSP" <ssp@dt.com> wrote in message
news:up9EPIh7DHA.3432@TK2MSFTNGP11.phx.gbl...
> cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
>
> cmd.Parameters["@cDateReg"].Value =
> Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString();
> cmd.Parameters["@cDate"].Value =
> Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
>
> Error Code: 80020005
> Message: Data conversion failed. [OLE DB status value,,,,,,]
>
> This is typical of the crap I am going through at the moment! If it works
in
> one instance why won't it work in another??
>
> SSP
>
>


Top

Re: .NET CF extremely buggy! by SSP

SSP
Sun Feb 08 15:35:56 CST 2004

They both get passed the same test values ("1/1/2003").

"Chris Tacke, eMVP" <ctacke[at]Open_NET_CF[dot]org> wrote in message
news:OHS9HKk7DHA.1768@tk2msftngp13.phx.gbl...
> Do cDateReg_tb and cDate_tb hold the same value? What values doe they
> contain?
>
> -Chris
>
>
> "SSP" <ssp@dt.com> wrote in message
> news:up9EPIh7DHA.3432@TK2MSFTNGP11.phx.gbl...
> > cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> > cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
> >
> > cmd.Parameters["@cDateReg"].Value =
> > Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString();
> > cmd.Parameters["@cDate"].Value =
> > Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
> >
> > Error Code: 80020005
> > Message: Data conversion failed. [OLE DB status value,,,,,,]
> >
> > This is typical of the crap I am going through at the moment! If it
works
> in
> > one instance why won't it work in another??
> >
> > SSP
> >
> >
>
>


Top

Re: .NET CF extremely buggy! by SSP

SSP
Sun Feb 08 15:53:56 CST 2004

If I don't convert it then I get a "conversion failed" type of error.

Here's the interesting bit. This used to be the setup:
...
cmd.Parameters.Add(new SqlCeParameter("@cDOB", DbType.Date));
cmd.Parameters.Add(new SqlCeParameter("@cSPN", DbType.String));
cmd.Parameters.Add(new SqlCeParameter("@cSPS", DbType.String));
cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date));
...
cmd.Parameters["@cDOB"].Value =
Convert.ToDateTime(cDOB_tb.Text).ToShortDateString();
cmd.Parameters["@cSPN"].Value = cSPN_tb.Text;
cmd.Parameters["@cSPS"].Value = cSPS_tb.Text;
cmd.Parameters["@cDate"].Value =
Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
...
I used to recieve the error:
Error Code: 80020005
Message: Data conversion failed. [OLE DB status value,,,,,,]

I moved the @cDate paramater right after the @cDOB and everything seemed to
sort itself.

I still have no idea?

SSP


"Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message
news:%23AdjeJo7DHA.3704@tk2msftngp13.phx.gbl...
> Why are you converting this to string before setting the param value?
>
> What happens if you do this:
>
> cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
>
> cmd.Parameters["@cDateReg"].Value = DateTime.Parse(cDateReg_tb.Text).Date;
> cmd.Parameters["@cDate"].Value = DateTime.Parse(cDate_tb.Text).Date;
>
> How is your table declared?
>
> "SSP" <ssp@dt.com> wrote in message
> news:up9EPIh7DHA.3432@TK2MSFTNGP11.phx.gbl...
> > cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> > cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
> >
> > cmd.Parameters["@cDateReg"].Value =
> > Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString();
> > cmd.Parameters["@cDate"].Value =
> > Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
> >
> > Error Code: 80020005
> > Message: Data conversion failed. [OLE DB status value,,,,,,]
> >
> > This is typical of the crap I am going through at the moment! If it
works
> in
> > one instance why won't it work in another??
> >
> > SSP
> >
> >
>
>


Top

Re: .NET CF extremely buggy! by Alex

Alex
Sun Feb 08 23:54:28 CST 2004

Could you post the structure of your data table?

"SSP" <ssp@dt.com> wrote in message
news:etKFf2o7DHA.712@tk2msftngp13.phx.gbl...
> If I don't convert it then I get a "conversion failed" type of error.
>
> Here's the interesting bit. This used to be the setup:
> ...
> cmd.Parameters.Add(new SqlCeParameter("@cDOB", DbType.Date));
> cmd.Parameters.Add(new SqlCeParameter("@cSPN", DbType.String));
> cmd.Parameters.Add(new SqlCeParameter("@cSPS", DbType.String));
> cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date));
> ...
> cmd.Parameters["@cDOB"].Value =
> Convert.ToDateTime(cDOB_tb.Text).ToShortDateString();
> cmd.Parameters["@cSPN"].Value = cSPN_tb.Text;
> cmd.Parameters["@cSPS"].Value = cSPS_tb.Text;
> cmd.Parameters["@cDate"].Value =
> Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
> ...
> I used to recieve the error:
> Error Code: 80020005
> Message: Data conversion failed. [OLE DB status value,,,,,,]
>
> I moved the @cDate paramater right after the @cDOB and everything seemed
to
> sort itself.
>
> I still have no idea?
>
> SSP
>
>
> "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message
> news:%23AdjeJo7DHA.3704@tk2msftngp13.phx.gbl...
> > Why are you converting this to string before setting the param value?
> >
> > What happens if you do this:
> >
> > cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> > cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
> >
> > cmd.Parameters["@cDateReg"].Value =
DateTime.Parse(cDateReg_tb.Text).Date;
> > cmd.Parameters["@cDate"].Value = DateTime.Parse(cDate_tb.Text).Date;
> >
> > How is your table declared?
> >
> > "SSP" <ssp@dt.com> wrote in message
> > news:up9EPIh7DHA.3432@TK2MSFTNGP11.phx.gbl...
> > > cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> > > cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
> > >
> > > cmd.Parameters["@cDateReg"].Value =
> > > Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString();
> > > cmd.Parameters["@cDate"].Value =
> > > Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
> > >
> > > Error Code: 80020005
> > > Message: Data conversion failed. [OLE DB status value,,,,,,]
> > >
> > > This is typical of the crap I am going through at the moment! If it
> works
> > in
> > > one instance why won't it work in another??
> > >
> > > SSP
> > >
> > >
> >
> >
>
>


Top

Re: .NET CF extremely buggy! by SSP

SSP
Thu Feb 12 04:56:08 CST 2004

CREATE TABLE tblChecklist (clCustomerName nvarchar (50), clMobileNo int, cl1
bit, cl2 bit, cl17 nvarchar (50), clSalesRepName nvarchar (50),
clSalesRepSig nvarchar (50), clSalesRepDate datetime, clCustSigName nvarchar
(50), clCustSig nvarchar (50), clCustDate datetime)


"Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message
news:eDiWvEt7DHA.2472@TK2MSFTNGP10.phx.gbl...
> Could you post the structure of your data table?
>
> "SSP" <ssp@dt.com> wrote in message
> news:etKFf2o7DHA.712@tk2msftngp13.phx.gbl...
> > If I don't convert it then I get a "conversion failed" type of error.
> >
> > Here's the interesting bit. This used to be the setup:
> > ...
> > cmd.Parameters.Add(new SqlCeParameter("@cDOB", DbType.Date));
> > cmd.Parameters.Add(new SqlCeParameter("@cSPN", DbType.String));
> > cmd.Parameters.Add(new SqlCeParameter("@cSPS", DbType.String));
> > cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date));
> > ...
> > cmd.Parameters["@cDOB"].Value =
> > Convert.ToDateTime(cDOB_tb.Text).ToShortDateString();
> > cmd.Parameters["@cSPN"].Value = cSPN_tb.Text;
> > cmd.Parameters["@cSPS"].Value = cSPS_tb.Text;
> > cmd.Parameters["@cDate"].Value =
> > Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
> > ...
> > I used to recieve the error:
> > Error Code: 80020005
> > Message: Data conversion failed. [OLE DB status value,,,,,,]
> >
> > I moved the @cDate paramater right after the @cDOB and everything seemed
> to
> > sort itself.
> >
> > I still have no idea?
> >
> > SSP
> >
> >
> > "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message
> > news:%23AdjeJo7DHA.3704@tk2msftngp13.phx.gbl...
> > > Why are you converting this to string before setting the param value?
> > >
> > > What happens if you do this:
> > >
> > > cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> > > cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
> > >
> > > cmd.Parameters["@cDateReg"].Value =
> DateTime.Parse(cDateReg_tb.Text).Date;
> > > cmd.Parameters["@cDate"].Value = DateTime.Parse(cDate_tb.Text).Date;
> > >
> > > How is your table declared?
> > >
> > > "SSP" <ssp@dt.com> wrote in message
> > > news:up9EPIh7DHA.3432@TK2MSFTNGP11.phx.gbl...
> > > > cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date));
> > > > cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date))
> > > >
> > > > cmd.Parameters["@cDateReg"].Value =
> > > > Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString();
> > > > cmd.Parameters["@cDate"].Value =
> > > > Convert.ToDateTime(cDate_tb.Text).ToShortDateString();
> > > >
> > > > Error Code: 80020005
> > > > Message: Data conversion failed. [OLE DB status value,,,,,,]
> > > >
> > > > This is typical of the crap I am going through at the moment! If it
> > works
> > > in
> > > > one instance why won't it work in another??
> > > >
> > > > SSP
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Top