Database

In C# class, I have written this statement

public class DBConnectionSQL
    {
        string connectionPath = "Data Source=Niladri135\\SQLEXPRESS;Initial Catalog=test;Integrated Security=True";
        string command = "";

            
        public void InsertRecords()
        {

            SqlConnection connection = new SqlConnection(@connectionPath);
            DateTime currentValue  = System.DateTime.Now;
            command = "Insert Into test_Datetime (COL1, COL2,DATE) values('value 1', 'value 2'," + "'" +  currentValue + "'" +  ")";
            try
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand(command, connection);
                cmd.ExecuteNonQuery();
            }
            catch (SqlException sqlExcep)
            {
                string msg = sqlExcep.Message;
            }
            finally
            {
                connection.Close();
            }
        }
    }

DateTime.ParseExact() Method

e.g. I want to convert from 28.06.2009 i.e. dd.mm.yyyy to 

mm/dd/yyyy hh:mm:ss

string OldDateFromat = "28.06.2009";//dd.mm.yyyy
DateTime dt = DateTime.ParseExact(OldDateFromat, "dd'.'MM'.'yyyy",
                                  CultureInfo.InvariantCulture);

Niladri_Biswas wrote:

The default date format in c sharps Datetime.Now is "mm/dd/yyyy hh:mm:ss".

....
Using System.Data.SqlClient;
....
....
SqlConnection oSQLConn = new SqlConnection();
.....
oSQLConn.ConnectionString = "Network Library=DBMSSOCN; Data Source=xxx.xxx.xxx.xxx,1438;Initial Catalog=databaseName;User ID=myUsername;Password=myPassword"

engbahramZarin wrote:

"[strNew] NUMBER(1)," & _

drive name:\Documents and Settings\My Documents\Visual Studio 2005\Projects