SQLConnection

Question

Now I want to connect my C#/XAML code to my sqlserver database and get the max id in the stock table.

There's another problem that I hadn't made any Datasets or Connectionstrings through visual studio and when I try to .. I don't find my server while creating new connection for the new dataset, actually it's a null list.

Here's my code

int maxstockid; //Identify the maximum ID of current Stocks

            //Command to Get the maximum stock ID.
            string queryString = "select max (Inventory_ID) from dbo.Stocks;";
            using (SqlConnection connection = new SqlConnection("Data Source = MRBRILLIANTPC; Initial Catalog = AGDB; Integrated Security = True"))
            {
                SqlCommand command = new SqlCommand( queryString, connection);
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                try
                {
                    while (reader.Read())
                    {
                        maxstockid =  int.Parse(reader[1].ToString());
                    }
                }
                finally
                {
                    // Always call Close when done reading.
                    reader.Close();
                }
            }