в бд имеется табличка CREATE TABLE [tblEvents] (
 [fldCode] [int] IDENTITY (1, 1) NOT NULL ,
 [fldUserCode] [int] NULL ,
 [fldEventType] [varchar] (128) COLLATE Cyrillic_General_CI_AS NULL ,
 [fldDateStart] [datetime] NULL ,
 [fldDateEnd] [datetime] NULL ,
 [fldText] [char] (128) COLLATE Cyrillic_General_CI_AS NULL ,
 CONSTRAINT [PK_tblEvents] PRIMARY KEY  CLUSTERED
 (
  [fldCode]
 )  ON [PRIMARY]
) ON [PRIMARY]
GO

в поля fldDateStart, fldDateEnd я должен сохранить не только дату но и время.CREATE procedure [dbo].[org_AddEvent]
 @fldUserCode int = 0,
 @fldEventType varchar(128),
 @fldDateStart datetime,
 @fldDateEnd datetime,
 @fldText varchar(128)
as
Insert into tblEvents
(fldUserCode, fldEventType,  fldDateStart, fldDateEnd,  fldText)
values
(@fldUserCode, @fldEventType, @fldDateStart, @fldDateEnd, @fldText )
GO

 // Добавитьprotected void ImageButton1_Click(object sender, ImageClickEventArgs e){string UserCode = this.UserList.SelectedItem.Value;string Event = this.EventTypes.Text;DateTime Date = this.CtlCalendar1.Date;Date.AddHours(Convert.ToInt32(this.TimeHour.SelectedItem.Text));Date.AddMinutes(Convert.ToInt32(this.TimeMinute.SelectedItem.Text));DateTime DateEnd = Date;DateEnd.AddHours(Convert.ToInt32(this.LongHour.SelectedItem.Text));DateEnd.AddMinutes(Convert.ToInt32(this.LongMinute.SelectedItem.Text));string Text = this.TextBox1.Text;SqlConnection SqlCon = new SqlConnection(Portal.Kabinet.cBasePage.connectionString);SqlCommand sqlCommand = new SqlCommand("org_AddEvent", SqlCon);sqlCommand.CommandType = CommandType.StoredProcedure;sqlCommand.Parameters.Add("@fldUserCode", SqlDbType.Int).Value = UserCode;sqlCommand.Parameters.Add("@fldEventType", SqlDbType.VarChar, 128).Value = Event;sqlCommand.Parameters.Add("@fldDateStart", SqlDbType.DateTime).Value = Date.ToString("yyyy-MM-dd HH:mm:ss");sqlCommand.Parameters.Add("@fldDateEnd", SqlDbType.DateTime).Value = DateEnd.ToString("yyyy-MM-dd HH:mm:ss");;sqlCommand.Parameters.Add("@fldText", SqlDbType.VarChar, 128).Value = Text;SqlCon.Open();sqlCommand.ExecuteNonQuery();SqlCon.Close();this.Page.Response.Redirect("org_Home.aspx");}

 
Проблема в том, что дата сохраняется а время нет, подскажите как правильно сохранять.--------------
Любое удобство идет за счет мегагерцеф! : {1, 2, 3, 4}

Спасибо всем прочитавшим топик :) проблема решилась так:
// Добавитьprotected void ImageButton1_Click(object sender, ImageClickEventArgs e){string UserCode = this.UserList.SelectedItem.Value;string Event = this.EventTypes.Text;DateTime Date = this.CtlCalendar1.Date;Date = Date.AddHours(Convert.ToInt32(this.TimeHour.SelectedItem.Text));Date = Date.AddMinutes(Convert.ToInt32(this.TimeMinute.SelectedItem.Text));DateTime DateEnd = Date;DateEnd = DateEnd.AddHours(Convert.ToInt32(this.LongHour.SelectedItem.Text));DateEnd = DateEnd.AddMinutes(Convert.ToInt32(this.LongMinute.SelectedItem.Text));string Text = this.TextBox1.Text;SqlConnection SqlCon = new SqlConnection(Portal.Kabinet.cBasePage.connectionString);SqlCommand sqlCommand = new SqlCommand("org_AddEvent", SqlCon);sqlCommand.CommandType = CommandType.StoredProcedure;sqlCommand.Parameters.Add("@fldUserCode", SqlDbType.Int).Value = UserCode;sqlCommand.Parameters.Add("@fldEventType", SqlDbType.VarChar, 128).Value = Event;sqlCommand.Parameters.Add("@fldDateStart", SqlDbType.DateTime).Value = Date;//= Date.ToString("yyyy-MM-dd hh:mm:ss");sqlCommand.Parameters.Add("@fldDateEnd", SqlDbType.DateTime).Value = DateEnd;//= DateEnd.ToString("yyyy-MM-dd hh:mm:ss");;sqlCommand.Parameters.Add("@fldText", SqlDbType.VarChar, 128).Value = Text;SqlCon.Open();sqlCommand.ExecuteNonQuery();SqlCon.Close();this.Page.Response.Redirect("org_Home.aspx");}

--------------
Любое удобство идет за счет мегагерцеф! : {1, 2, 3, 4}