Database

kikeman wrote:

Can I develop a distributed database?
So that, actually the DB is all over on the networked computers?

<a href="http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx">http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx</a>[<a href="http://www.dotnetspider.com/SqlServer-Tutorial-158.aspx" target="_blank" title="New Window">^</a>]

There is no hard-coded limit to the number of users that can attach to SQL Server Express but their CPU and memory limits impose practical limits on the number of users that can achieve acceptable response times from a SQL Server Express 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"