Insert DateTime Into SQL Server Using C#

Hi,





I have very little C# experience and I am in over my head here. This script will insert all data into the data base after I have removed all refference to the date.





I know I have to change the datatype in code, but I have tried everything I can think of.





Any suggestion would be greatly appreciated.





The .aspx.cs file is below:











using System;


using System.Configuration;


using System.Collections;


using System.ComponentModel;


using System.Data;


using System.Data.SqlClient;


using System.Drawing;


using System.Web;


using System.IO;


using System.Web.SessionState;


using System.Web.UI;


using System.Web.UI.WebControls;


using System.Web.UI.HtmlControls;











namespace News


{


public class AddNews : System.Web.UI.Page


{


protected System.Web.UI.HtmlControls.HtmlInputText txt_news_title;


protected System.Web.UI.WebControls.TextBox txt_news_body;


protected System.Web.UI.HtmlControls.HtmlInputFile txt_news_image;


protected System.Web.UI.WebControls.Button UploadBtn;


protected System.Web.UI.WebControls.Button ResetBtn;


protected System.Web.UI.WebControls.RequiredFieldValidator rfv_news_image;


protected System.Web.UI.WebControls.Label lbl_news_result;





public AddNews() { }








private void Page_Load(object sender, System.EventArgs e)


{}








public void UploadBtn_Click(object sender, System.EventArgs e)


{


if (Page.IsValid) //save the image


{





//news_title


string newsTitle = txt_news_title.Value;





//news_body


string newsBody = txt_news_body.Text;





//news_date


DateTime dtCurrTime = DateTime.Today;


string d = dtCurrTime.ToString();





//news_img & news_imgcontenttype


Stream imgStream = txt_news_image.PostedFile.InputStream;


int imgLen = txt_news_image.PostedFile.ContentLength;


string imgContentType = txt_news_image.PostedFile.ContentType;


byte[] imgBinaryData = new byte[imgLen];


int n = imgStream.Read(imgBinaryData,0,imgLen);





int RowsAffected = SaveToDB( newsTitle,newsBody,d,imgBinaryData,imgContentType);


if ( RowsAffected>0 )


{


//Response.Write("<BR>The Image was saved");


lbl_news_result.Text = "Record was added successfully!";


txt_news_title.Value = "";


txt_news_body.Text = "";


}


else


{


//Response.Write("<BR>An error occurred uploading the image");


lbl_news_result.Text = "Record was NOT added!";


}


}


}





public void Reset_Click(object sender, System.EventArgs e)


{


txt_news_title.Value = "";


txt_news_body.Text = "";


lbl_news_result.Text = "";








}














private int SaveToDB(string newsTitle, string newsBody, string d, byte[] imgbin, string imgcontenttype)


{


//use the web.config to store the connection string


SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["connString"]);








SqlCommand command = new SqlCommand( "INSERT INTO Cover (cover_title,cover_body,cover_date,cover_image,cover_imgcontenttype) VALUES ( @news_title,@news_body,@news_date,@img_data,@img_contenttype )", connection );





SqlParameter param0 = new SqlParameter( "@news_title", SqlDbType.VarChar,50 );


param0.Value = newsTitle;


command.Parameters.Add( param0 );





SqlParameter param1 = new SqlParameter( "@news_body", SqlDbType.VarChar,5000 );


param1.Value = newsBody;


command.Parameters.Add( param1 );





SqlParameter param2 = new SqlParameter( "@news_date", SqlDbType.VarChar,8 );


param2.Value = d;


command.Parameters.Add( param2 );








SqlParameter param3 = new SqlParameter( "@img_data", SqlDbType.Image );


param3.Value = imgbin;


command.Parameters.Add( param3 );





SqlParameter param4 = new SqlParameter( "@img_contenttype", SqlDbType.VarChar,50 );


param4.Value = imgcontenttype;


command.Parameters.Add( param4 );





connection.Open();





int numRowsAffected = command.ExecuteNonQuery();





connection.Close();





return numRowsAffected;


}


}


}














Thanks!