Inserting date problem

[Rajani]

Hello,

I replaced the calendar control to 3 dropdownlists(d ay,month and year) coz
i want to display the calendar as just like DTPicker in vb.6. But i cant able
to display like that. The form ocupies more space. But i am facing another
problem.

My table structure is staff(empid integer,joindat e datetime)

i am getting the date selected as

dim doj as new datetime(yr.sel ectedValue,mnth .selectedvalue, dy.selectedvalu e)

qry="insert into staff(empid,joi ndate) values(@empid,@ joindate)"
dim idparam as new sqlparameter("@ empid",sqlDBTyp e.integer)
dim dtparam as new sqlparameter("@ joindate",sqlDB Type.datetime)
idparam.value=t xtID.text
dtparam.value=d oj.toShotdatest ring()

conn.open()
dbcommand=new sqlcommand(qry, conn)
dbcommand.param eters.add(idpar am)
dbcommand.param eters.add(dtpar am)
dbcommand.execu tenonquery()
conn.close()

'i am getting the error "input string is not in correct format. only the
problem is with date. When using calendar, executed well. I hope some cating
problem but i couldn't resolve?

thanks for the reply

[Greg Young]

Don't see why you are doing the ToString(), it will only put it back to a
datetime internally .. try this.

dtparam.value=d oj

Cheers,

Greg
"Rajani" <Ra****@discuss ions.microsoft. com> wrote in message
news:6D******** *************** ***********@mic rosoft.com...

Hello,

I replaced the calendar control to 3 dropdownlists(d ay,month and year)
coz
i want to display the calendar as just like DTPicker in vb.6. But i cant
able
to display like that. The form ocupies more space. But i am facing another
problem.

My table structure is staff(empid integer,joindat e datetime)

i am getting the date selected as

dim doj as new
datetime(yr.sel ectedValue,mnth .selectedvalue, dy.selectedvalu e)

qry="insert into staff(empid,joi ndate) values(@empid,@ joindate)"
dim idparam as new sqlparameter("@ empid",sqlDBTyp e.integer)
dim dtparam as new sqlparameter("@ joindate",sqlDB Type.datetime)
idparam.value=t xtID.text
dtparam.value=d oj.toShotdatest ring()

conn.open()
dbcommand=new sqlcommand(qry, conn)
dbcommand.param eters.add(idpar am)
dbcommand.param eters.add(dtpar am)
dbcommand.execu tenonquery()
conn.close()

'i am getting the error "input string is not in correct format. only the
problem is with date. When using calendar, executed well. I hope some
cating
problem but i couldn't resolve?

thanks for the reply

[Rajani]

Hello,

I tried as u said. Still the same problem "Input string is not correct
format"

what could be the problem?
"Greg Young" wrote:

Don't see why you are doing the ToString(), it will only put it back to a
datetime internally .. try this.

dtparam.value=d oj

Cheers,

Greg
"Rajani" <Ra****@discuss ions.microsoft. com> wrote in message
news:6D******** *************** ***********@mic rosoft.com...

Hello,

I replaced the calendar control to 3 dropdownlists(d ay,month and year)
coz
i want to display the calendar as just like DTPicker in vb.6. But i cant
able
to display like that. The form ocupies more space. But i am facing another
problem.

My table structure is staff(empid integer,joindat e datetime)

i am getting the date selected as

dim doj as new
datetime(yr.sel ectedValue,mnth .selectedvalue, dy.selectedvalu e)

qry="insert into staff(empid,joi ndate) values(@empid,@ joindate)"
dim idparam as new sqlparameter("@ empid",sqlDBTyp e.integer)
dim dtparam as new sqlparameter("@ joindate",sqlDB Type.datetime)
idparam.value=t xtID.text
dtparam.value=d oj.toShotdatest ring()

conn.open()
dbcommand=new sqlcommand(qry, conn)
dbcommand.param eters.add(idpar am)
dbcommand.param eters.add(dtpar am)
dbcommand.execu tenonquery()
conn.close()

'i am getting the error "input string is not in correct format. only the
problem is with date. When using calendar, executed well. I hope some
cating
problem but i couldn't resolve?

thanks for the reply

[Chris Chilvers]

What about this line:
idparam.value=t xtID.text

Have you tried using:
idparam.value = Int32.Parse(txt ID.text)

On Mon, 1 May 2006 02:37:01 -0700, Rajani
<Ra****@discuss ions.microsoft. com> wrote:

Hello,

I tried as u said. Still the same problem "Input string is not correct
format"

what could be the problem?
"Greg Young" wrote:

Don't see why you are doing the ToString(), it will only put it back to a
datetime internally .. try this.

dtparam.value=d oj

Cheers,

Greg
"Rajani" <Ra****@discuss ions.microsoft. com> wrote in message
news:6D******** *************** ***********@mic rosoft.com...

> Hello,
>
> I replaced the calendar control to 3 dropdownlists(d ay,month and year)
> coz
> i want to display the calendar as just like DTPicker in vb.6. But i cant
> able
> to display like that. The form ocupies more space. But i am facing another
> problem.
>
> My table structure is staff(empid integer,joindat e datetime)
>
> i am getting the date selected as
>
> dim doj as new
> datetime(yr.sel ectedValue,mnth .selectedvalue, dy.selectedvalu e)
>
> qry="insert into staff(empid,joi ndate) values(@empid,@ joindate)"
> dim idparam as new sqlparameter("@ empid",sqlDBTyp e.integer)
> dim dtparam as new sqlparameter("@ joindate",sqlDB Type.datetime)
> idparam.value=t xtID.text
> dtparam.value=d oj.toShotdatest ring()
>
> conn.open()
> dbcommand=new sqlcommand(qry, conn)
> dbcommand.param eters.add(idpar am)
> dbcommand.param eters.add(dtpar am)
> dbcommand.execu tenonquery()
> conn.close()
>
> 'i am getting the error "input string is not in correct format. only the
> problem is with date. When using calendar, executed well. I hope some
> cating
> problem but i couldn't resolve?
>
> thanks for the reply