How To Connect *****!!!!!!!!?

How to connect With sql server database with C# forms.....sample code|||System.Data.SqlClient.SqlConnection conn =
new System.Data.SqlClient.SqlConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString =
"integrated security=SSPI;data source=SQL Server Name;" +
"persist security info=False;initial catalog=northwind";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}|||

ConnectionString =
"integrated security=SSPI;data source=SQL Server Name;" +
"persist security info=False;initial catalog=northwind";

SqlCeConnection connection =
new SqlCeConnection(ConnectionString);
connection.Open();

SqlCeCommand command = connection.CreateCommand();
command.CommandText = "SELECT count(*) FROM customer";
int result = (System.Int32)(command.ExecuteScalar());

command.CommandText = "SELECT * FROM customer";
SqlCeDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
for (int i = 0; i < dataReader.FieldCount; i++)
{
string value = dataReader.GetValue(i).ToString();
}
}

for (int i = 0; i < dataReader.FieldCount; i++)
{
string column = dataReader.GetName(i);
}

|||the last reply is specific with pure conn sode.