Can't connect to database using a SQL Connection

See more:

SQL

database

Hi, so i'm making a database which is for a film system. I've made the database in SQL, now what I want to do is to display information from the database in a console application using ado.net. Now i've put the code in for this work and it builds successfully but when it runs no data is displayed. Now I think this has something to do with the data source name, the server name i've used in SQL is MASTER\MASTER, but when I entered this in for the data source name it came up with an error message saying "Unregonized Escape Sequence". So to recify this I put in two backslashs instead of one so it looked like this MASTER\\MASTER. This resolved the error, but the program still doesnt work.

Heres the code i've used for it so you can see if it's this problem or something else that might be causing my program not to work.

class Program
    {
        static void Main(string[] args)
        {
            try
            {
                // set up data connection
                string cs = "Data Source=MASTER\MASTER;Initial Catalog=FilmDB;Integrated Security=True;Pooling=False";
                SqlConnection cn = new SqlConnection(cs);
                // Set up SQL command
                SqlCommand cm = cn.CreateCommand();
                ///
                ///Sql Select Command (Read table and return data)
                ///
                cm.CommandText = "SELECT FilmID, FilmName FROM [dbo].[Film];";
                // Set up adapter manager
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cm;
                //Set dataset for results
                DataSet ds = new DataSet();
                ds.Clear();
                //Open Connection to database
                cn.Open();
                //Ask adapter to transfer data from table to dataset
                da.Fill(ds, "Film");
                //Set up data table
                DataTable dt = ds.Tables["Film"];
                //Read data from table rows
                foreach (DataRow dr in dt.Rows)
                {
                    Console.WriteLine(dr["FilmID"].ToString() + "\t" + dr["FilmName"].ToString());
                }
                //Close connection to database
                cn.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
            finally
            {
                //cn.close();
            }
        }
    }