Inserting date

[R Palanivel]

Hi You can insert Data in many ways . try to use stored procedures(for good programming). here i give u some sample code SqlConnection sqlCon=new SqlConnection("connection string"); sqlCon.Open(); SqlCommand insertCmd = new SqlCommand("stored procedure name", sqlCon); insertCmd.CommandType = CommandType.StoredProcedure; //Create parameter and Set values insertCmd.Parameters.Add(, ,); insertCmd.Parameters[].Value = insertCmd.ExecuteNonQuery(); sqlCon.Close(); r_palanivel83 10:01 4 Jan '06

[Kunal P]

hey i m sorry if i cudnt clarify myself.. wanted a walthrough ragarding inserting a DATE... thx..

Kunal Piyush

[badgrs]

DateTime.Now is the .NET method of getting the current date object. or if your using SQL Server you can use the GETDATE() SQL command directly in your query

[R Palanivel]

HI you just use this code insertCmd.Parameters.Add("@DateVale", SqlDbType.DateTime,10); insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")

r_palanivel83 10:01 4 Jan '06

[Colin Angus Mackay]

r_palanivel83 wrote:

insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")

Why on Earth would you convert the date to a string?! Just pass it the DateTime object.

---

Upcoming events: * Glasgow: Geek Dinner (5th March) * Edinburgh: Web Security Conference Day for Windows Developers (12th April) My: Website | Blog | Photos

[Kunal P]

i am now able to add the date to the database.. bu there is on problem.. when i retrive the date when the employee was added.. it will also the time along the date.. i dont want the time to at all get into the database... is it possible.

Kunal Piyush

[badgrs]

A date field also includes the time - I see no reason why you wouldn't want this information available even if you don't want to display it. Use DateTime.ToString(format) to format the output without time.

[Kunal P]

a lil bit of problem.. the date would be retrieved from the database... now how shud i fomat it without the time.. and in DD/MM/YYYY format.. to retrieve i m using this line of code Label1.Text = "" + dread["dt"].ToString(); where dt is the datetime field in the database.

Kunal Piyush

[badgrs]

Kunal P wrote:

Label1.Text = "" + dread["dt"].ToString();

If you look in the documentation you'll see the ToString method is overloaded (has several different methods with different parameters). You can feed is a string format like this: (and you don't need the initial blank string - that just creates another object to be cleaned up by the GC)

Label1.Text = dread["dt"].ToString("dd/MM/yyyy");

You'll probably find you need to cast it to a DateTime object first:

Label1.Text = ((DateTime)dread["dt"]).ToString("dd/MM/yyyy");

This documents the possible formating strings: Custom DateTime Format Strings

[Kunal P]

hi thanks a lot for all the help.. and i am sorry if i am asking way too basic questions.. just started programming..;P

Kunal Piyush